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

From: cipher (removefolf_at_yahoo.com)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 16:10:46 -0700

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!

Relevant Pages

  • Combo Box Form Query - Erases Existing Fields When Formatted
    ... I have a .mdb table Linked in to my ... access database. ... that will be used for adding and editing values in the table. ... This query allows all of the existing records to be in alphabetical ...
    (microsoft.public.access.forms)
  • Re: error messages when connecting to an MS Access query
    ... I'm actually opening the Word document from VBA in the Access database, ... It's actually easy to run a Make Table query in Access, ... I got messages saying it couldn't make the connection. ... When you try to make a DDE connection, if the database is not already ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Oneys Book, HandleQueryStop(): Why is there no race condition?
    ... The simplest approach is to just deny the query. ... allow the query but leave the system vulnerable as the race condition cannot ... >> If there is need to stop the device, the driver should be ... >>> Conexant Systems, Inc. ...
    (microsoft.public.development.device.drivers)
  • Re: Update db FE with "power user"
    ... You mentioned you are distributing an MDB. ... Your boss also modified the original query to ... You could likely do that by hiding the table links and only giving him access to queries that are snapshots. ...
    (comp.databases.ms-access)
  • Re: A2007 ADPs
    ... What is the defination of a query being too complex? ... an Access MDB to suck more data across the network than necessary? ... an aeroplane in flames just use an ADP instead. ... are hitting one of the main point of using passthrough queries. ...
    (microsoft.public.access.adp.sqlserver)