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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dilip Krishnan (dkrishnan_at_NOSPAM.geniant.com)
Date: 01/13/05 

Date: Thu, 13 Jan 2005 05:45:27 -0800

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

Relevant Pages