Link to home
Start Free TrialLog in
Avatar of dev_yinz
dev_yinzFlag for Singapore

asked on

What is the Format of Connection String

I want to use CDatabase::OpenEx(LPCTSTR lpszConnectionString, DWORD dwOptions = 0)
Any expert share the format of database connection string lpszConnectionString?

Thank you very much
SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dev_yinz

ASKER

It looks more like the connection strings for .Net framework use.

I am using MFC database class CDatabase to connect to MSSQL server. The MSDN says the format something like "DSN=SQLServer_Source;UID=SA;PWD=abc123". But it doesn't give the complete format.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you very much James. Your informaiton is very helpful.
You are most welcome......