Forums

Hi Thanks for the reply, I have upper or lower selected.
When I run the query, this is the error returned by sql server management studio .

The aliasing "Tbl1002"." activateDate" is appended by ssms or jade?


OLE DB provider "MSDASQL" for linked server "JCCTEST" returned message "[Jade Software ...

Does anyone know the syntax for querying jade from sqlserver using the odbc connection as linked server?
I Have created a linked server JCCTEST that connect successfully with jade.

The data source has been tested using visual studio and we are able to retrieve data re the following query.

select ...

There is an issue with jade 6.2.17 the odbc dll's are the wrong version. We had to copy the jadodbc_c.dll from the server to the client bin file, connection then worked.

Jade plant are now aware of this and fixing

Problems setting up thin client. Ran the JADEwin32AnsiThinClient.exe which does not install the JADE ODBC Thin Client driver?
Which 6.2.15 download do I need to install the thin client driver for ODBC data source?