Last symbol read was: 'no'.

[OLP1566]

Hi,

I am using Ingres driver and trying to download the list of tables under one schema but I am getting the following error.

CAIIOD32.DLL error '80131937'

ERROR [42000] [CA][Ingres ODBC Driver][Ingres]Syntax error. Last symbol read was: 'no'.

/CB1/UserArea/235/Processes/ConnectionDownload.asp, line 32

Could you please guide in getting this error corrected.

Sujan

[magxa01]

Hello Sujan,

What is the exact release of your odbc driver ?
(MS odbc admin tab drivers)

i found this about error 42000 :

42000 Syntax error or
access violation
The user did not have permission to execute the
SQL statement contained in the argument

What user is used in the vnode ??
Is it for some tables or for all the tables of the schema ?

Regards.

[loera01]

Hello Sujan,

The error 42000 in this case appears to be a syntax error. The error message comes from the DBMS, and indicates that the syntax was unrecognized when the DBMS parsed the word "on".

Could you please provide the query you used to retrieve your list of tables?

Regards, Ralph