Hello,

I am trying to use the infomix jdbc driver "ifxjdbc.jar" to connect to my database with Crystal Reports XI r2

I want to create a report using jdbc connection on my informix database (informix server version 7.31.UD7). I get an error message while trying to get all the tables of my database : " Error database connector : 'Exception SQL : [status SQL:]42000 [SQL message error]a syntax error has occured [code -201]"
I have read the -201 error. But I haven 't written any SQL code.

-->So I think the error comes from the jdbc driver that tryes to get the table using a query.

The URL I am using :
"jdbc:informix-sqli://myServer:myPort/myDatabase:INFORMIXSERVER=myInformixServer"

the className is : "com.informix.jdbc.IfxDriver"

Any Idea would be great !
Thanks

Thomas