Calvin;

What driver are you using to connect to VFP? I would not expect a connection time of more than one second.

Tom


>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