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!