Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Crystal Reports 2008 and Informix Post Reply Post New Topic
Author Message
jim33
Newbie
Newbie


Joined: 30 Jan 2009
Online Status: Offline
Posts: 8
Quote jim33 Replybullet Topic: Crystal Reports 2008 and Informix
    Posted: 09 Feb 2010 at 1:28pm
I have an ODBC driver installed that allows me to connect to Noble Systems dialer which is an Informix 2.1 database.
 
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
 
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 09 Feb 2010 at 3:04pm
I ran into an similiar issue several years ago using a proprierty ODBC connection.  I could not join more that two tables.
I do not know if you have the access/ablity to create a stored procedure/view.  It might be the only way around the issue.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.