I use:

STORE SQLCONNECT(_SCREEN.zSqlDsn, _SCREEN.zSqlId, _SCREEN.zSqlPword) TO returnValue

where:
(_SCREEN.zSqlDsn = datasource name

since the format is:

SQLConnect(cDataSourcename, cUserID, cPassword)

I'm not sure how to insert the database name.

please advise
thanks for the help

regards,

Jerry



>>I'm using MySQL database.
>>each time I want to switch to another database I have to go through MySQL ODBC.
>>is that possible to change the database from inside VFP?
>>
>>regards,
>>
>>Jerry
>
>Once you have a connection that you created with SQLSTRINGCONNECT() you can switch database:
>

>SQLEXEC(nConnectionHandle,"USE MyDatabase;")
>