Changing between EQUAL and LEFT OUTER JOINS in ODBC

[jwoodland]

When trying to convert the joins from equal to left outer (or any other) I recieve the message:

ODBC error : [Informix][Odbc Informix Driver]General error. Syntax Error

Then

Error detected by database DLL.

I am using Crystal Reports 8.5 and with an ODBC database. I'm unsure what other details may be needed.

Thanks in anticipation

Jwood

 

[synapsevampire]

How are you attempting to change the join?

Use the visual linking expert, right click the join and change it.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[jwoodland]

I am using this method.

Thanks

Jwood

 

[Roadkill150]

Hmm.. might try building a new connector and see if you can this still occurs (might have a corrupt odbc connection) also try verify database in crystal and see if that helps. Lastly, are you using the newest sdk version from informix? I noted when i went to 8.5 with informix that there were some odbc issues with crystal needing newer drivers for the informix client.
-Bruce Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com