ODBC MS SQL Server and Informix help please
Posted in 2000
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET
Hi all, I am having difficulty creating a view in a SQL Server database from an Informix linked server. The situation is as follows. 1. I downloaded and installed the Informix Client SDK containing the latest Informix ODBC drivers onto my SQL Server machine. 2. I configured and tested a system DSN from the drivers to ensure that they connected, which they did. 3. I created a linked server in SQL Server from this DSN and this returned me a list of tables, therefore proving that the linked server had connected ok. 4. I then try to cretae a view in a SQL Server database by dragging on of the tables in the list and dropping it onto the create view window. 5. I selected some columns from the table in the view window and checked the sql, this is when i get the following error: Server: Msg 7312, Level 16, State 1, Procedure test1, Line 2 Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog and/or schema. What am i doing wrong? I know that the DSN works and is connecting, i can even get a list of tables from the linked server. Am i not filling in all of the required parrameters in the linked server window? Please help, we are quite desperate for this to work!!! Thanks in advance Sent via Deja.com http://www.deja.com/ Before you buy.