Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLStringconnect w/ Connector/ODBC (MySQL)
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01215663
Message ID:
01215686
Vues:
13
Now that's really nice!

>See Re: SqlStringConnection Message #884312
>
>
>>I am working on a VFP application client that uses MySQL as backend.
>>
>>On the client I have the Connector/ODBC driver of MySQL installed (v. 3.51.14).
>>Now I issue the following command in order to check whether the database can be accessed:
>>
>>?sqlstringconnect("DRIVER={MySQL ODBC 3.51 Driver};UID=root; server=192.168.0.1")
>>If it returns > 0 then I know that the MySQL server is accessible and the application can continue.
>>
>>If the server is not available at that moment, the MySQL driver pops up a Driver Connect dialog where the user can enter the servername, username, password and database name. Now that is very confusing for the user and I would like to avoid this dialog.
>>
>>Is there another way to check whether the MySQL database is accessible, or is there a way to set in the MySQL driver properties (somewhere) that this dialog should not be shown?
>>
>>Thanks for your help in advance.
Christian Isberner
Software Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform