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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only