Informix, Connecting IDS 7.31 with SQL Server 7

Connecting IDS 7.31 with SQL Server 7

Author	Message
Paulo Amor #1 / 4	Connecting IDS 7.31 with SQL Server 7 Hello all. I need to perform a search in an SQLServer table, wich is referenced in another database in IDS 7.31. Its like if you have your customer table on SQLServer and orders table in Informix. You must verify if the customer exists before you insert a row in the orders table. Im thinking about creating a trigger calling a stored procedure that calls another SP on SQL Server. Is there any way to do this search ?? The database is under AIX (IBM), and the SQLServer database is under NT. Any help will be welcome. Thanks in advance Paulo Amorim TS&O Consulting Brazil
Tue, 13 Apr 2004 03:11:36 GMT

<andrew> #2 / 4	Connecting IDS 7.31 with SQL Server 7 Quote: > Hello all. > I need to perform a search in an SQLServer table, wich is referenced > in another database in IDS 7.31. Its like if you have your customer > table on SQLServer and orders table in Informix. You must verify if > the customer exists before you insert a row in the orders table. Im > thinking about creating a trigger calling a stored procedure that > calls another SP on SQL Server. > Is there any way to do this search ?? > The database is under AIX (IBM), and the SQLServer database is under > NT. > Any help will be welcome. > Thanks in advance > Paulo Amorim > TS&O Consulting > Brazil You can link the Informix server to the SQLServer system if you're running the job in SQLServer. Create a system DSN linked to your Informix database. In SQLServer enterprise manager, go to Security - linked servers, right click and choose add a new server. Give the linked server a name - tell it that you want to use an OLE DB Provider for ODBC Databases - then in the DAta Source item - enter the name of the DSN you created to link to the Informix db. Once you're linked the SQLServer should retrieve a full list of the tables the login specified in the DSN has access to. Create a new view in the SQLServer, and drag the tables you need from the linked server to the view - and there you go. You can use the view in your sp to do whatever the login you used in the DSN allows you to do. Afraid I'm new to Informix and as yet have not got the faintest idea how to do it the other way around HTH - and good luck. -- - Hide quoted text - - Show quoted text - Quote: > 'One accusation you can't throw at me is that I've always done my best.' > - > Alan Shearer
Tue, 13 Apr 2004 18:35:47 GMT

Raymond Huma #3 / 4	Connecting IDS 7.31 with SQL Server 7 I've done what Allen have explained and it works really could . I've linked Informix, another SQL Server 7 database as well as a Oricale database. Some functions might not work in you're queries but there is alway's a work around for that - enjoy Raymond Quote: > > Hello all. > > I need to perform a search in an SQLServer table, wich is referenced > > in another database in IDS 7.31. Its like if you have your customer > > table on SQLServer and orders table in Informix. You must verify if > > the customer exists before you insert a row in the orders table. Im > > thinking about creating a trigger calling a stored procedure that > > calls another SP on SQL Server. > > Is there any way to do this search ?? > > The database is under AIX (IBM), and the SQLServer database is under > > NT. > > Any help will be welcome. > > Thanks in advance > > Paulo Amorim > > TS&O Consulting > > Brazil > You can link the Informix server to the SQLServer system if you're running > the job in SQLServer. > Create a system DSN linked to your Informix database. > In SQLServer enterprise manager, go to Security - linked servers, right > click and choose add a new server. > Give the linked server a name - tell it that you want to use an OLE DB > Provider for ODBC Databases - then in the DAta Source item - enter the name > of the DSN you created to link to the > Informix db. > Once you're linked the SQLServer should retrieve a full list of the tables > the login specified in the DSN has access to. > Create a new view in the SQLServer, and drag the tables you need from the > linked server to the view - and there you go. You can use the view in your > sp to do whatever the login you used in the DSN allows you to do. > Afraid I'm new to Informix and as yet have not got the faintest idea how to > do it the other way around > HTH - and good luck. > -- > > 'One accusation you can't throw at me is that I've always done my best.' > > - > > Alan Shearer
Fri, 16 Apr 2004 14:35:00 GMT

Pazicky Ludovi #4 / 4	Connecting IDS 7.31 with SQL Server 7 There should be a way to do it the opposite direction. You should be able to use the Informix Gateway Manager (IGM)to connect your IDS database to an ODBC source. I managed to connect IDS to Oracle database such a way and while it was made via ODBC, I assume that it should work with SQL Server too. You have to install the IGM on a NT machine where the SQL Server resides, create an ODBC source to connect IGM to SQL Server and in your IDS you will make a normal inter-server connection between two IDS server, because you will see the IGM as a IDS server. Of course you will have some limitations in your SQL commands, but that is not surprising. Installation and configuration was not difficult and is very good described in install and configuration guides. Be carefull with the case sensitivity, it plays a n important role. Hope this helps. Pazi Quote: -----Original Message----- Sent: Friday, October 26, 2001 12:36 PM Subject: Re: Connecting IDS 7.31 with SQL Server 7 > Hello all. > I need to perform a search in an SQLServer table, wich is referenced > in another database in IDS 7.31. Its like if you have your customer > table on SQLServer and orders table in Informix. You must verify if > the customer exists before you insert a row in the orders table. Im > thinking about creating a trigger calling a stored procedure that > calls another SP on SQL Server. > Is there any way to do this search ?? > The database is under AIX (IBM), and the SQLServer database is under > NT. > Any help will be welcome. > Thanks in advance > Paulo Amorim > TS&O Consulting > Brazil You can link the Informix server to the SQLServer system if you're running the job in SQLServer. Create a system DSN linked to your Informix database. In SQLServer enterprise manager, go to Security - linked servers, right click and choose add a new server. Give the linked server a name - tell it that you want to use an OLE DB Provider for ODBC Databases - then in the DAta Source item - enter the name of the DSN you created to link to the Informix db. Once you're linked the SQLServer should retrieve a full list of the tables the login specified in the DSN has access to. Create a new view in the SQLServer, and drag the tables you need from the linked server to the view - and there you go. You can use the view in your sp to do whatever the login you used in the DSN allows you to do. Afraid I'm new to Informix and as yet have not got the faintest idea how to do it the other way around HTH - and good luck. -- > 'One accusation you can't throw at me is that I've always done my best.' > - > Alan Shearer
Sat, 17 Apr 2004 16:38:05 GMT

Page 1 of 1

[ 4 post ]