ADO Connection String.

ForexSurfr's Avatar, Join Date: Aug 2009
Newbie Member
I am currently having problems with my ADO connection string. I have searched all over the internet for a solution to this problem but I have yet to find a solution. Can someone help me with the proper configuration for a SQL OLEDB connection with a windows authentication? I have attached my C++ code file and a printscreen of my SQL Server Express signon screen.
Attached Files
File Type: doc ConnectionStringCode.doc (40.5 KB, 7 views)
File Type: doc SQLSignon.doc (184.0 KB, 5 views)
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Instead of attaching your problem try posting them as that becomes easier for us to look at
0
ForexSurfr's Avatar, Join Date: Aug 2009
Newbie Member
The following is an error message I am receiving:

Error number: 80040e4d Login failed for user 'mcertini'.
Error
Code = 80040e4d
Code meaning = I
Source = Microsoft OLE DB Provider for SQL Server
0
naimish's Avatar
Banned
Try using below sample code :

Quote:
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Data1\Data1.mdb;"
0
ForexSurfr's Avatar, Join Date: Aug 2009
Newbie Member
naimish,

Thank you for your reply. Listed below is the message I get when I eliminate all of the arguments other than the "Provider" and "Data Source" and modify these to your recommendation.

Error number: 80004005 Unrecognized database format 'C:\SQL Server 2000 Sample
Databases\NORTHWND.MDF'.
Error
Code = 80004005
Code meaning = U
Source = Microsoft JET Database Engine

Listed below is the message I get when I retain all of the original arguments and modify the arguments you specified:

Error number: 80040e21 Multiple-step OLE DB operation generated errors. Check e
ach OLE DB status value, if available. No work was done.
Error
Code = 80040e21
Code meaning = I
Source = Microsoft OLE DB Service Components
0
xpi0t0s's Avatar, Join Date: Aug 2004
Mentor
Try not using quotes, i.e.
Code:
pConnection1->ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;...(etc)";
0
naimish's Avatar
Banned
Quote:
Unrecognized database format
This error only comes when there is some dependency.

The solution I was using it, try to convert your database in 97 format, it ll get closed.

0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
The Connection String Reference: http://www.connectionstrings.com/