How do i connect remote sql server no use odbc.....(use Visual C++ )

[cibrran]

Help me dear my friends!


I wann'a that connect remote sql server no using ODBC!


Let's read above this



typically we used like that just next line

(Source Start....)
CDatabase db;
db.OpenEx( _T( "DSN=DBName" );
(Source End......)

but if use like just before way....

we must be setting [ODBC] => [sql] => [Server name,

certificate password]

every Install time You'll set your client's ODBC setting


then... I'll Let explain you that just I wann'a issue!

How do i connect remote sql server no use odbc?

like ( no using ODBC setting)

(Source Start....)
CDatabase db;
db.OpenEx( _T( "DSN=Server Address, ID='sa', password=''" );
(Source End......)

this way...


please help me....

I wann'a some your nice help and pretty advice and a little

words!


have a nice day....

 

[LucyP]

don't know about C++,
but use this connection string:

driver={SQL Server}; server=00.00.00.00; database=DatabaseName; User ID=sa; password=""