Forums

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 getDefaultNameDisplay,oid, myPrimaryServiceCode, providerId, activateDate, deactivateDate
from WorkUnitProvider

Querying Jade using the following query from within 'sqlserver management studio' returns error
we have tried a number of syntax variations around 'JCCTEST...' but always receive errors.

select getDefaultNameDisplay,oid, myPrimaryServiceCode, providerId, activateDate, deactivateDate
from JCCTEST...WorkUnitProvider

What option did you have set for Keywords on your DSN definition?

Some SQL query tools send their Keywords in all Upper Case, and some used mixed case or lower case.

You may find you have to tune this setting on your DSN to match what your query tool is supplying and, in some cases, you need two different DSNs for two different SQL query tools due to incompatibility of the case (Upper/Lower/Mixed) they use for the Keywords that they supply.

Cheers,
BeeJay.

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 Corporation][JADE ODBC Server] Expecting: 'FROM'; found 'Col1004' at 32".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "SELECT "Tbl1002"."activateDate" "Col1004","Tbl1002"."deactivateDate" "Col1005","Tbl1002"."getDefaultNameDisplay" "Col1006","Tbl1002"."myPrimaryServiceCode" "Col1007","Tbl1002"."oid" "Col1008","Tbl1002"."providerId" "Col1009" FROM "WorkUnitProvider" "Tbl1002"" for execution against OLE DB provider "MSDASQL" for linked server "JCCTEST".