Desktop

Ask something
Discussion Locked

Connecting to different databases

0 helpful
7 replies

by granite2

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like some comments on software that would enable database connectivity. The home database is SQL Server on NT 4.0 Server. My application needs to connect to and withdraw data from a DB2 Database on AS/400, as well as an Oracle 7 database on Unix (SCO). The network is a LAN with TCP/IP.

7 replies

by its a secret

You can run two tcp/ip protocols on one nic. Each with a different subnet mask. This will enable you access the sco and the nt4 simultaneously.

by granite2

Thanks for your response, but it only answered part of the question. I also have the AS400 to connect to. What I am really looking for is software that can connect the disparate databases (such as the DB2 Connect). I appreciate your help!

by tech

you could try looking at Advanced Query Tool at www.cardett.co.nz. It is an easy-to-use query tool which works with most databases including SQL Server and Oracle. It may or may-not work well with DB2 on AS400, depending on what version of this you are running. Note that to access DB2 on AS400 you will need DB2/Connect.

by chrandrob

SQL Server is capable of making direct ODBC connections to both Oracle 7 and DB2 databases. You can then query these databases directly through SQL Server.

Do that and your app can send all of it's interactivity through SQL Server and have all ofthe data processing done by SQL Server.

by granite2

Thank you for your response. I did use SQL Server to connect to the Oracle DB, but I was having great difficulty and never could get it to connect with the AS400/DB2 system.

This discussion is closed to new replies.