Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Invalid Connection String
Message
De
16/09/2009 20:15:43
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Invalid Connection String
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01424834
Message ID:
01424834
Vues:
90
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform