Search found 4 matches

Go to advanced search

by BobNZ
Tue May 25, 2010 4:48 pm
Forum: General Discussion
Topic: Jade ODBC connection to SQL server 2005
Replies: 2
Views: 4451

Re: Jade ODBC connection to SQL server 2005

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 Corpo...
by BobNZ
Mon May 24, 2010 1:46 pm
Forum: General Discussion
Topic: Jade ODBC connection to SQL server 2005
Replies: 2
Views: 4451

Jade ODBC connection to SQL server 2005

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 get...
by BobNZ
Mon May 24, 2010 1:39 pm
Forum: General Discussion
Topic: 6.2.15 thin client ODBC connection
Replies: 6
Views: 9269

Re: 6.2.15 thin client ODBC connection

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
by BobNZ
Tue Apr 27, 2010 3:10 pm
Forum: General Discussion
Topic: 6.2.15 thin client ODBC connection
Replies: 6
Views: 9269

6.2.15 thin client ODBC connection

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?

Go to advanced search

cron