[dba-SQLServer] SQL error in Excel query to IBM DB2 data source
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?
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?
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
More information about the dba-SQLServer