SQL Server V7
Posted: Fri Aug 07, 2009 11:49 am
by ConvertFromOldNGs
by John >> Tue, 14 Mar 2000 0:03:00 GMT
Has anyone had any experience linking the Jade ODBC interface to SQL server V7. I cant seem to find how to tell the SQL server to look at the jade database
Re: SQL Server V7
Posted: Fri Aug 07, 2009 11:49 am
by ConvertFromOldNGs
by Craig Shearer >> Tue, 14 Mar 2000 8:06:15 GMT
From your post, it sounds as if you're trying to get SQL Server to talk to JADE via JADE's relational view. AFAIK, this isn't possible as only reporting tools like Crystal Reports (ie. those that only use a level 0? (or is it 1) compliant ODBC driver) can talk to JADE. Presumeably SQL Server would need to talk to a driver that had a higher level of compliance than JADE provides.
You could of course get it to work the other way getting JADE to write records into an SQL Server database using JADE's external relational database connectivity.
Craig.