Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Access 2010 - DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)

Posted on 2013-01-22
4
2,050 Views
Last Modified: 2013-01-24
Hello Friends,

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

Regards,

Under_Pressure
0
Comment
Question by:Under_Pressure
  • 2
  • 2
4 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 38809721
<<Incorrect syntax near ‘POFVM’. (#102).>>

 A SQL string is being sent to the driver and the syntax is incorrect.

 Most likely a SQL statement that is being constructed on the fly in code in the app, but it could also be an Access bug, or settings for the driver (like quoted identifiers)

  They should note what they were doing just before the error (ie. running a report), and what if any options or operations they were doing to help pin it down.

  Also double check the DSN setup between them and another machine and make sure their identical.

Jim.
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 38809736
Also, if you can generate the error on demand, then turn on ODBC tracing through the ODBC admin applet.

The resulting log will let you see exactly what is being sent to the driver and will give information about what's going on.

If it's a more sporadic error, you might want to leave it on for a few hours to try and catch it.  Just be aware that the log file can grow in size quickly.

Jim.
0
 

Author Comment

by:Under_Pressure
ID: 38810928
Thank you Jim.  I will act on your suggestions this morning and will update you on what transpires.
0
 

Author Closing Comment

by:Under_Pressure
ID: 38816857
Jim,
Thank you for your insight.  By taking your suggestion of making sure that the DSN configurations were identical, we wouldn’t have noticed the 2 boxes under SQL Server DSN Configuration:  Use ANSI quoted identifiers and Use ANSI nulls, paddings and warnings.  When we had unchecked those 2 boxes and ran test queries, they completed successfully without a hitch!  I’m very appreciative and, therefore, awarding you all of the points available.
Regards,
Ray
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration of the Data Protection Manager product. Note that this demonstration was prepared on the basis of Windows OS is 2008 R2 and DPM 2010. DATA PROTECTI…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question