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

[cipher]

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]

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]

Hi,

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

"Dilip Krishnan" <dk*******@NOSPAM.geniant.com> wrote in message
news:14**********************@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]

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" <dk*******@NOSPAM.geniant.com> wrote in message
news:14**********************@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]

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" <dk*******@NOSPAM.geniant.com> wrote in message
news:14**********************@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" <dk*******@NOSPAM.geniant.com> wrote in message
news:14**********************@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!