Solved

ODBC Call Failed

Posted on 2008-10-29
4
383 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
4 Comments
 
LVL 32

Accepted Solution

by:
bhess1 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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…

910 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now