Connecting IDS 7.31 with SQL Server 7 
Author Message
 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
 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.
--

- 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
 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
 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
 
 [ 4 post ] 

 Relevant Pages 

1. IDS 7.31 connect Cold Fusion Server 4.5

2. problem connecting to IDS 7.31 thru client used on Informix 5

3. Connect Informix 7.31 (NT) --> SQL Server 2000

4. Restoring IDS 7.31 on IDS 2000

5. IDS 7.31 -> IDS.2000 9.21 upgrade

6. IDS 2000 vrs IDS 7.31

7. IDS.2000 and IDS 7.31 on one unix box

8. IDS 7.31 TC7 and Windows 2000 server?

9. Pb with Informix Online 5.00 Client (I-Star) and IDS 7.31 Server

10. Informix Server Administrator for IDS 7.31 TC4

11. IDS 7.31 on NT with Sequel Server

12. IDS 7.31: SQL equivalent for oncheck -pe


 
Powered by phpBB® Forum Software