Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connecting to MySQL
Message
 
 
To
21/08/2012 06:43:51
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MySQL
Application:
Desktop
Miscellaneous
Thread ID:
01550869
Message ID:
01550872
Views:
140
This message has been marked as the solution to the initial question of the thread.
>Hi friends:
>
>A few montht ago I've started to test MySQL. I began with "Sqlstringconnect()", a connection windows appeared and after a few tries I could connect and browse a table. Great! That was fine for me.
>
>But now I have to work on a real case.
>
>And now MySQL connection window is not nice anymore...
>
>I suppose there must be a way to avoid every time I try to connect database connections data appears waiting for an Ok.
>
>I suppose this is the third or fourth question about MySQL I've done but surely is not the last...
>
>Any help?
>
>Thank you.
>
> Hector

Try
SQLSETPROP(0, "ConnectTimeOut", .SQL_ConnectTimeout) && Value of connection timeout property
		SQLSETPROP(0, "DispWarnings", .F.)
		SQLSETPROP(0, "DispLogin", 3)  && disable login dialog if there is a problem
before running the SQLConnect
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform