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.
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
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
Try not using quotes, i.e. Code: pConnection1->ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;...(etc)";
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.