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

[Zimmer, Michael]

Ouch!  Monday morning brain reboot needed.  

Found the ODBC DSN in the ODBC Create New Data Source wizard.
"Use ANSI Quoted Identifiers" checked on by default.  Unchecked = no change
"Use ANSI nulls, padding's and warnings" checked on by default.  Unchecked = no change
I tried various combinations of the above all with no change to problem.
Then I unchecked the "Perform translation for character data" box to see if that would help.  = no change.

Still stumped in Wisconsin.  Ugh!

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