Urgent, master invited: About SQL Server connection in Foxpro program! !! !!

wiconell

I use sqlstringconnect to connect to a sql server database in Foxpro program. For some reasons, I cannot provide the database name in the parameters. I can only provide the DSN and the login user and password. In this way, I can get a connection handle. After getting a connection handle, then associate a database with this handle? Because there are many databases in sql server. Please advise. urgent! !! !!

我是杀人狂

No database name, right?

170385215

If you have made a connection to SQL Server, then you can open another database

sqlexec (the obtained SQL handle, 'USE the name of the database you want to open')

kriesscoen

If you have sufficient permissions, connect directly to the "master" database,
Then open your database with the command upstairs