Linking SQL Server and Informix Tables

[fsub]

Hi,

I am trying to link an Informix table to a SQL Server table. I know that both keys are string(10). For some reason, I kept getting "The specified links are of different types" error. Any ideas are greatly appreciated.

 

[kray4660]

I do not know much about Informix. But I know that MS-SQL does not have a 'string' data type. They have char, varchar, nchar, and nvarchar for various string types. Are you using a command or linking the tables in the Database Expert?

 

[fsub]

I am linking it via Database Visual Linking Expert. I'm using Crystal 8.5. Field is actually varchar in SQL Server. Crystal is detecting it as a string. Thanks.

 

[fsub]

I created an ODBC/DSN for the SQL SERVER table which seemed to work better. I am now able to link the two tables. Thanks for the reply.

 

[kray4660]

Glad you have a solution. Unfortunately Crystal 8.5 did not really have the option for a command (entering your own SQL). If I recall, I think you could modify the SQL it gave you.