[IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConn

cipher · Joined: 08 Aug 2007 Posts: 3

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!

Archived from group: microsoft>public>dotnet>framework>odbcnet

Dilip Krishnan · Joined: 08 Aug 2007 Posts: 6

Hello cipher,
Check if your DSN is a system dsn

HTH
Regards,
Dilip Krishnan
MCAD, MCSD.net
dkrishnan at geniant dot com
http://www.geniant.com

> 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!
>

cipher · Joined: 08 Aug 2007 Posts: 3

Hi,

It was a User DSN but after making it a System DSN there was no change in
behavior. Same error.

"Dilip Krishnan" wrote in message@msnews.microsoft.com...
> Hello cipher,
> Check if your DSN is a system dsn
>
> HTH
> Regards,
> Dilip Krishnan
> MCAD, MCSD.net
> dkrishnan at geniant dot com
> http://www.geniant.com
>
> > 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!
> >
>
>

Dilip Krishnan · Joined: 08 Aug 2007 Posts: 6

Hello cipher,
Yr connection string is probably wrong
try something like this... "mySystemDSN;Uid=myUsername;Pwd=myPassword"

HTH
Regards,
Dilip Krishnan
MCAD, MCSD.net
dkrishnan at geniant dot com
http://www.geniant.com

> Hi,
>
> It was a User DSN but after making it a System DSN there was no change
> in behavior. Same error.
>
> "Dilip Krishnan" wrote in message
> @msnews.microsoft.com...
>
>> Hello cipher,
>> Check if your DSN is a system dsn
>> HTH
>> Regards,
>> Dilip Krishnan
>> MCAD, MCSD.net
>> dkrishnan at geniant dot com
>> http://www.geniant.com
>>> 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!
>>>

cipher · Joined: 08 Aug 2007 Posts: 3

Dilip,

You were correct, the connection string was wrong. It seems the Driver
portion is correct and is required. I still don't know what is wrong with
the one I was using but I changed it to this:

pConnection = new OdbcConnection("Driver={Microsoft Access Driver
(*.mdb)};DBQ=c:\\mydata.mdb");

and all is well. Thanks for your help.

"Dilip Krishnan" wrote in message@msnews.microsoft.com...
> Hello cipher,
> Yr connection string is probably wrong
> try something like this... "mySystemDSN;Uid=myUsername;Pwd=myPassword"
>
> HTH
> Regards,
> Dilip Krishnan
> MCAD, MCSD.net
> dkrishnan at geniant dot com
> http://www.geniant.com
>
> > Hi,
> >
> > It was a User DSN but after making it a System DSN there was no change
> > in behavior. Same error.
> >
> > "Dilip Krishnan" wrote in message
> > @msnews.microsoft.com...
> >
> >> Hello cipher,
> >> Check if your DSN is a system dsn
> >> HTH
> >> Regards,
> >> Dilip Krishnan
> >> MCAD, MCSD.net
> >> dkrishnan at geniant dot com
> >> http://www.geniant.com
> >>> 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!
> >>>
>
>

ERROR [07002] [Microsoft][ODBC Microsoft Access Driver]COUNT Goog morning, I'am using an adapter to pass an inserting querry withb parametrers. the code is : DA_ins[i] = new = new * from tmpDS[i] = new DataSet();

ERROR [22001] [Microsoft][ODBC Excel Driver] The field is to Hi, I'm using ODBC DSN less connection to load an EXCEL file into a dataset. It's raising the error "ERROR [22001] Excel Driver] The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data

ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server Greetings, I am getting this error when I try to populate a DataTable by executing a stored procedure on a SQL Server 2000 database through an ODBC in a VB.NET application: ERROR [42000] SQL Server Driver][SQL 'ABC' expec

Driver Manager Hi all, I want to implement a connection pool and i need to know how can i use the Driver Manager, in which DLL, namespace is?? Thanks

ERROR [ HY000 ] [ Microsoft][ODBC Microsoft Access Controlle Hi Could anybody say me because when doing a INSERT, gives the following error: "ERROR [ HY000 ] [ Microsoft Access Controller] the operation must use a updateable consultation" Thanks Code: conexion = new