Sunday, March 11, 2012

Connection from SQL 2005 to Informix 2000

Hi All,

I'm trying to set up a SSIS package to pull data from a data sourse on an Informix 2000 server. I'm currently using an OpenLink driver to access the data through ODBC, however when I try to query it through BIDS or using the SQL management Studio's import feature it says that the objects don't exist for what I'm querying.. I can view the tables in the query builder, just not query them?

Has anyone any suggestions as to how I might be able to resolve this? The Informix server is not one that I can modify, so anything that I do will have to be done from the SQL server (running 2005 ent edition)

I'm able to query the tables and fields from another program, however can't output the results from this easily for SQL to use.

If you have any suggestions I'd greatly appreciate them. Let me know if you need any more information

Regards,
Steve

PS, I'm using SQL 2005 Ent Ed, OpenLink Multi Tier ODBC Version 4.2, Informix 2000 connected via TCP/IP, and have a username and password to connect (not a trusted connection)

Hallo,

I have the same Problem.

I think the problem is the sql-syntax.

SQL2005 generate this query: select * from [tablename]

informix need this: select * from tablename

bye

hardy

|||

Hey Steve,

I have the exact same error. Has anyone found the answer?

Mrlace2

No comments:

Post a Comment