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

Scott Marcus scott.marcus at tsstech.com
Mon May 2 11:35:46 CDT 2016


The older the database the more incompatible with new OS's and software. I run into these same kind of issues with an old Oracle 8i system. 

-----Original Message-----
From: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Zimmer, Michael
Sent: Monday, May 2, 2016 12:03 PM
To: Discussion concerning MS SQL Server <dba-sqlserver at databaseadvisors.com>
Subject: Re: [dba-SQLServer] SQL error in Excel query to IBM DB2 data source

Yep, I did change only one variable at a time and worked my way through each variable.  I guess now I'll have to put the two laptops side by side and start looking for differences in set-up etc.  

This is a lot of work just to get column names changed!

Mike

-----Original Message-----
From: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Scott Marcus
Sent: Monday, May 02, 2016 10:40 AM
To: 'Discussion concerning MS SQL Server'
Subject: Re: [dba-SQLServer] SQL error in Excel query to IBM DB2 data source

Did you try renaming one field at a time? It could be that one field is causing this issue.

-----Original Message-----
From: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Zimmer, Michael
Sent: Monday, May 2, 2016 10:18 AM
To: Discussion concerning MS SQL Server <dba-sqlserver at databaseadvisors.com>
Subject: Re: [dba-SQLServer] SQL error in Excel query to IBM DB2 data source

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


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


NOTICE:  This electronic mail transmission is for the use of the named individual or entity to which it is directed and may contain information that is privileged or confidential.  If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of any information contained herein is prohibited.  If you have received this electronic mail transmission in error, delete it from your system without copying or forwarding it, and notify the sender of the error by replying via email or calling TSS Technologies at (513) 772-7000, so that our address record can be corrected.
Any information included in this email is provided on an “as is” and “where as” basis, and TSS Technologies makes no representations or warranties of any kind with respect to the completeness or accuracy of the information contained in this email.

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list