Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid Connection String
Message
From
16/09/2009 20:15:43
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Invalid Connection String
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01424834
Message ID:
01424834
Views:
91
We have been connecting to a MySQL database with the following:
lnConnectionString = ;
"Driver=MySQL ODBC 3.51 Driver;Server=aa.bb.c.dd;UID=uid;PWD=passwd;DATABASE=dbname;APP=appname"
lnHandle = Sqlstringconnect(lcConnectionString, .T.)
The database is being moved to a new server which (I am told) has been setup identically to the original one.
We change the IP address for the server connection so that it is now
lnConnectionString = ;
"Driver=MySQL ODBC 3.51 Driver;Server=aa.bb.c.ee;UID=uid;PWD=passwd;DATABASE=dbname;APP=appname"
lnHandle = Sqlstringconnect(lcConnectionString, .T.)
But it now errors out with
"Connectivity error: [MySQL][ODBC 3.51 Driver]Could not find driver {MySQL ODBC 3.51 Driver} in system information."

Can somebody please provide some info on where to look and what might need to be changed?

All replies appreciated..............Rich
Next
Reply
Map
View

Click here to load this message in the networking platform