Vb program, links within the local area network (LAN) a computer in the other mySQL, always fail

The connection string is
DRIVER={MySQL ODBC DRIVER 5.1}; SERVER=192.168.1.9; The Database=myDB; UID=root; The PWD=12345; OPTION 3=

Error:
[Microsoft] [ODBC driver manager] did not find the data source name and did not specify a default driver

I also try different connection string, such as the following, quote the same mistake,
Driver={MySQL}; Server=192.168.1.9; Option=131072; Stmt=; The Database=myDB; User=root; Password=12345;

Whether this error prompts me to be on the client computer install mySQL ODBC driver?
I need to set up ODBC?
Management tools there are 2 ODBC, respectively is the ODBC data source (32), the ODBC data source (64), if you want to set up, which should be set up?

CodePudding user response:

VB6
The ODBC data source (32)

CodePudding user response:

32 bit, and then see if the root is set up a remote login permissions

CodePudding user response: