Solved

ODBC Call Failed

Posted on 2008-10-29
4
389 Views
Last Modified: 2012-05-05
I have an access app that connects to sql server via odbc, on 2 of my computers it works fine but the same code on 2 other computer give me greif I have attached 2 log files one from each computer, any ideas
SQLerr.txt
SQLworking.txt
0
Comment
Question by:jroulgnd
[X]
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
4 Comments
 
LVL 32

Accepted Solution

by:
Brendt Hess earned 500 total points
ID: 22838434
The issue appears to be a difference in how the two access connections handle the QUOTED_IDENTIFIER state.  By default, SQL Server does not allow quotation marks to be used around SQL identifiers, as you have in the code:

SELECT "dbo"."PS10100"."dDOCSUFFIX" ,"dbo"."PS10100"."dAPPDATE" ,"dbo"."PS10100"."dISSUEDDATE" .....

You have three options:
1)  Replace the quotation marks with square brackets, e.g.:

SELECT [dbo].[PS10100].[dDOCSUFFIX] ,[dbo].[PS10100].[dAPPDATE] ,[dbo].[PS10100].[dISSUEDDATE] ....

2)  Set the QUOTED_IDENTIFIER parameter ON in your connection

3)  Set the QUOTED_IDENTIFIER option ON in your database using ALTER DATABASE, e.g.

ALTER DATABASE MyDB SET QUOTED_IDENTIFIER ON
0
 
LVL 44

Expert Comment

by:GRayL
ID: 22956949
grief!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

631 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