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

[Stuart McLachlan]

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
>