| |

VerySource

 Forgot password?
 Register
Search
View: 15|Reply: 3

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

[Copy link]

2

Threads

3

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-2-16 18:00:01
| Show all posts |Read mode
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! !! !!
Reply

Use magic Report

0

Threads

97

Posts

56

Credits

Newbie

Rank: 1

Credits
56

 Germany

Post time: 2020-4-29 09:00:02
| Show all posts
No database name, right?
Reply

Use magic Report

0

Threads

19

Posts

14

Credits

Newbie

Rank: 1

Credits
14

 China

Post time: 2020-4-29 09:15:01
| Show all posts
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')
Reply

Use magic Report

0

Threads

11

Posts

10

Credits

Newbie

Rank: 1

Credits
10

 Singapore

Post time: 2020-5-19 20:30:01
| Show all posts
If you have sufficient permissions, connect directly to the "master" database,
Then open your database with the command upstairs
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list