MySQL Forums
Forum List  »  Connector/ODBC

Re: Every new machine blocks connection
Posted by: Bogdan Degtyariov
Date: June 20, 2023 05:55PM

About your connection string:

"DSN=DPCOMP;server=IP_ADDRESS;uid=root;pwd=password;OPTION=35;Database=mysql"

What is the point of using DSN if you are changing nearly everything by specifying other options like SERVER=...;DATABASE=...?

Another point of concern is DATABASE=mysql

This is a system database, there is very little sense of making it your default database. Normally the database is either not specified or set to some user DB.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.