Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr fail

Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr fail

Post by Allee » Thu, 23 Aug 2007 04:16:57


Hello;

I have an ASP application build with Dreamweaver that uses the ODBC
connections to a ms access db that was working until now (for at least 6 to 7
months) for what ever reason I was updating some data in one of the database
tables and once I decided to go to the site I am now getting this error

I have seen this error before and i know there is a fix. but I can't figure
it out

can anyone help

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
/synthnet/verify.asp, line 7


Browser Type:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322;
InfoPath.1; .NET CLR 2.0.50727)

Page:
GET /synthnet/verify.asp
 
 
 

1. Microsoft OLE DB Pro | [Microsoft][ODBC Driver Manager] Driver does not support this function

2. [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

Hello,

I'm creating a webservice that needs to query an Access database (mdb).
Here's my code:

OdbcConnection *pConnection = new OdbcConnection("Driver={Microsoft Access
Driver (*.mdb)};DSN=MyDatasource");
try
{
pConnection->Open();
}
catch(OdbcException *e)
{
Console::WriteLine("An error occurred: '{0}'", e);
}


This always throws an exception with the message : [IM006][Microsoft][ODBC
Driver Manger]Driver's SQLSetConnectAttr failed

I have granted the ASPNET user account Administrative privileges to no
avail. I'm pretty much a web service security noob at this point so help
would be greatly appreciated.

Thanks!

3. [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

4. "0x80004005 Microsoft OLE DB Provider for ODBC Drivers" help!

5. ERROR -> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

6. Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers

7. Middleware lists updated: JDBC drivers, ODBC drivers, .NET providers, OLE DB providers, XQuery engines

8. SQLSummit.com lists: JDBC drivers, ODBC drivers, .NET data providers, OLE DB providers, XQuery engines

9. SQLSummit.com lists updated: ODBC drivers, OLE DB providers, .NET data providers, XQuery engines, JDBC drivers

10. SQLSummit.com lists updated: JDBC drivers, ODBC drivers, .NET data providers, OLE DB providers, XQuery engines

11. SQLSummit.com updated lists: XQuery engines, ODBC drivers, JDBC drivers, .NET data providers, OLE DB providers

12. Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers

13. SQLSummit.com middleware lists: .NET data providers, ODBC drivers, OLE DB providers, XQuery engines, JDBC drivers

14. ODBC drivers, .NET providers, OLE DB providers, JDBC drivers: updated lists