I connect and can view tables OK w/ CR 2008; but when I add more than 1 table I get an error:

 

Crystal failed to retrieve data from the database.

Details; S0000 (Noble systems corp]

[Atomix ODBC Driver] Atomix error (-201) A syntax error has occured [Database vendor code 4]

 

I have the current driver.

Noble-vendor has been no help. UGH.

 

My select statement is:

 SELECT DISTINCT tsktsrday.time_connect, tsktsrday.time_waiting, tsrmaster.tsr
 FROM   tsrmaster tsrmaster INNER JOIN tsktsrday tsktsrday ON tsrmaster.tsr=tsktsrday.tsr

Which isn't anything complicated.

 

The error screen is:

---------------------------
Crystal Reports
---------------------------
Failed to retrieve data from the database.
Details: S0000:[Noble Systems Corp.][ATOMIX ODBC Driver]Atomix error -  (-522)Table (time_connect) not selected in query.
 [Database Vendor Code: 4 ]
---------------------------
OK  
---------------------------

Its almost as if the ODBC connect is linking to such an old version of SQL that it doesn't like what CR 2k8 generated above when adding more than 1 table. huh?

 

Any help is GREATLY appreciated.

 

419-651-6704