Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed Issue with SQLConnect
Message
From
27/01/2005 12:20:37
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Speed Issue with SQLConnect
Environment versions
Visual FoxPro:
VFP 7 SP1
Miscellaneous
Thread ID:
00981265
Message ID:
00981265
Views:
58
I am trying to connect to MYSql using the MySQL ODBC 3.51 DSN driver. When I test the ODBC connection it makes connection in < 1 second. However, in VFP using either SQLConnect or SQLString Connect a connection takes 23 to 30 seconds. Anything I can do to speed this up? Thanks for the help. My test code below:

STORE SQLCONNECT('xxxxxx', 'xxxxx','xxxxx') TO myh
*STORE SQLSTRINGCONNECT('dsn=xxxxx;uid=xxxxx;pwd=xxxxx') TO myh
IF myh < 0
= MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
ELSE
* to this point takes 23 to 30 seconds.
= MESSAGEBOX('Connection made', 48, 'SQL Connect Message')
r=SQLTABLES(myh, "TABLE", "mydbresult")
if r=1
select mydbresult
browse
else
wait 'Not able to read' window
endif
= SQLDISCONNECT(myh)
ENDIF
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!
Next
Reply
Map
View

Click here to load this message in the networking platform