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

[Zimmer, Michael]

Stuart,

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?


Mike


-----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
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com