[dba-SQLServer] SQL error in Excel query to IBM DB2 data source

Zimmer, Michael Michael.Zimmer at federalmogul.com
Mon May 2 08:14:53 CDT 2016


I'm looking in the ODBC administration window but cannot seem to find the appropriate menu for the quoted identifiers.  Could you point me in the right direction?


-----Original Message-----
From: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Friday, April 29, 2016 7:06 PM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] SQL error in Excel query to IBM DB2 data source

The OBDC DSN should contain a parameter "Use ANSI Quoted Identifiers:"
Set it to Yes and No and see what happens.

On 29 Apr 2016 at 18:33, Zimmer, Michael wrote:

> NOW here's what's really weird:  On the four, identically set-up PCs 
> we run this Excel sheet on -- only one can successfully change 
> criteria and have the query work, the other three all can successfully 
> use the spreadsheet, but cannot adjust any criteria in the query.
> So the error message says that SQL doesn't like the single '' marks 
> for the alias we want to use.  But I'm thinking that it might be some 
> setting I'm missing in the ODBC administration, maybe something in the 
> Conversions or CCSID?
> Mike

dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list