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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Date: Wed, 12 Jan 2005 21:09:01 -0700

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

  • How do i connect to a System DSN with my app running on a IIS server?
    ... i have created both a User DSN, and a System DSN to use to connect to ... and when i have my ADOConnection ConnectionString set to ... connect to the User DSN everything works fine. ... i need to make certain that my app (which is running ...
    (alt.comp.lang.borland-delphi)
  • Re: How to manage SQL server Authentication in Access2007
    ... Are you using User DSN or System DSN. ... SQL 2005 is using SQL Server authentication with a password. ...
    (microsoft.public.sqlserver.security)
  • Re: Create DSN
    ... int fRequest, string lpszDriver, string lpszAttributes); ... The int 4 refers to the value "ODBC_ADD_SYS_DSN". ... - ODBC_CONFIG_DSN (use this to configure a user DSN) ... - ODBC_ADD_SYS_DSN (use this to add a system DSN) ...
    (microsoft.public.dotnet.languages.csharp)
  • ODBC connection issues
    ... SQL state IM002 in SQLConnect" ... using User DSN) it appears to connect however the web ... the Test in ODBC for both User & System DSN, ... The PHP script uses exactly the same DSN, ...
    (comp.lang.php)
  • Re: problems with DSN for MS Acess database
    ... > After that by silly mistake User DSN for MS Access Database was created ... if it is a System DSN. ... You can use RegEdit File Export to save text files for these keys and ...
    (comp.databases.ms-access)