ODBC Connection - Receiving SQL Errors

Question

Question

Jerry Petrole · Feb 5, 2021

Hello,

I have established an ODBC connection with our client based on credentials they provided. The test connection was successful and after using the Link Table wizard I can now see the client's tables and properties. However when we try to execute a query in IRIS we are getting error code -226. I'm trying to determine if this could be just a simple setting problem in IRIS or something with the client.

We have tried with PostgreSQL as well as with TSQL. Same result for each.

Has anyone seen this error before and could it be pointing me in a certain direction? Documentation on the error is sparse at best.

Many thanks!

Jerry Petrole

Five Points Technology Group

Product version: IRIS 2019.1

$ZV: IRIS for Windows (x86-64) 2019.1.1 (Build 612_0_19971U) Mon Jun 1 2020 18:51:40 EDT

Discussion (3)0

Log in or sign up to continue

Neil Thaiss · Feb 8, 2021

Also try putting brackets around the top number of rows, Jerry, i.e.: TOP (100).

I've known this to be a problem for me with linked tables.

0 0

score 0 · Answer 1 · 2021-02-05T15:33:33-05:00

the second line of the error msg tells you that SQLserver raised error 102

This error occurs when Adaptive Server detects a syntax error in a Transact-SQL^® command or query. This error can occur when: A keyword is misspelled. ... You used a variable for a database name and your query contains a parser error; error 102 is raised because the batch was never executed.
from:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00729.1500/html/errMessageAdvRes/CHDGFCCJ.htm

suggestion: Check the SQL-name of the generated class samples.people

score 0 · Answer 2 · 2021-02-16T12:25:51-05:00

Jerry Petrole · Feb 16, 2021

Thanks Neil. This turned out to be the solution!

0 0