Access 2010 - DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)
Posted on 2013-01-22
Both of my coworkers in our Accounting department have been running into this error message whenever they would run a query within Access 2010 against our ERP SQL database: Microsoft Access ODBC—call failed. [Microsoft] [ODBC SQL Server Driver][SQL Server] Incorrect syntax near ‘POFVM’. (#102).
I’ve checked that they have the correct System DSN installed. Also, I ran a trace in which this line caught my attention: DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0).
I’d really appreciate any assistance or pointers in troubleshooting this issue. Below are the components involved:
Domain: Windows 2003 Native.
Client: Windows 7 32-bit with Office 2010 Pro Suite.
SQL Server: Windows 2008 Standard Server with SP2 (32-bit)
SQL Server Info: Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414)
Microsoft Analysis Services Client Tools 2007.0100.1600.022 ((SQL_PreRelease).080709-1414)
Microsoft Data Access Components (MDAC) 6.0.6002.18005 (lh_sp2rtm.090410-1830)
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.4234
Operating System 6.0.6002