Connecting to Jade via ODBC

[ConvertFromOldNGs]

by Bob Zirbel >> Tue, 20 Dec 2005 2:13:54 GMT

Hi all.
I have successfully connected to a Jade database from my application using the Jade supplied ODBC driver and an ADO query.
I can see all the tables and their fields but when I attempt to execute a simple query like Select * from CRMContacts, I get the error message 'Expecting statement, found Select at 0'.
I found a reference to this message on the Jade web site that stated that if the message ended in 'at 1' then the ODBC driver is expecting statements to be in uppercase. I tried an uppercase select but I still get the same error.

Any help would be appreciated.

Regards

Bob

[ConvertFromOldNGs]

by Jade Support >> Tue, 20 Dec 2005 19:51:01 GMT

Bob,

Can you please check the specification of the DSN setting of Keywords and check that it's set to "Upper and Lower case".

The JADE ODBC driver is a Core Level implementation of an ODBC Version 3.51 driver. The ODBC driver accepts only SQL keywords that are all uppercase characters (for example, LIKE), or optionally keywords with an initial capital letter (for example, Like, but not like or liKe) or keywords that are all lowercase characters (for example, the SQL Server keywords). The case of identifier characters used in a query must be distinct from those in keywords. For SQL Server queries, you must enclose all table and field names that conflict with SQL keywords with double quotation (" ") characters.

In the Keywords list box, the "All Upper" option is selected by default and specifies that only reserved words (or keywords) that are all uppercase characters are recognized; that is, they adhere to the ODBC standard and minimize reserved word conflicts with your user table or column names. Select the "Initial Upper" option if you want all ODBC reserved words converted to an initial capital letter so that words such as Like (which is used by some applications) are then recognized.
Select the "Upper or Lower" option for SQL Server, whose keywords are sent to the ODBC driver in lowercase format.

I'm not familiar with with the ADO connection type, so if "Upper and Lower case" doesn't resolve the issue please retry the query with "Initial Upper" set.

Regards, Jade Support.

[ConvertFromOldNGs]

by dilip Menon >> Sun, 29 Oct 2006 1:06:50 GMT

THe solution for this is that you have to have all the commands in Upper Case since the odbc drive configured may be ALL UPPER

ex

SELECT

*

FROM


TABLE

WHICH ODBC DRIVER ARE YOU USING , PLEASE SEND IT TO ME IF YOU ARE ABLE TO WRITE INTO JADE DATABASE

dilip_menon1@yahoo.com

[ConvertFromOldNGs]

by Reinier Noom >> Wed, 1 Nov 2006 22:09:08 GMT

Hi Dilip,

The Jade ODBC driver is read-only. I can't see that ever changing.

Thanks

Reinier Noom
Senior Technical Developer
Greentree International Ltd