Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLStringconnect w/ Connector/ODBC (MySQL)
Message
From
13/04/2007 14:13:04
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01215663
Message ID:
01215686
Views:
14
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
Previous
Reply
Map
View

Click here to load this message in the networking platform