Linking DB2 database in SQL Server 2000 
Author Message
 Linking DB2 database in SQL Server 2000
I am trying to link a DB2 (AS/400) database to my SQL Server 2000. Can
anyone recommend the best driver to use please? I will mostly be reading
from the linked server and performance is critical.

I would like to use the DB2OLEDB driver provided by Microsoft, however, I
think I can only get this through Host Integration Server. I do not want to
install HIS and also do not want to create a DSN as this would cause a
negative impact on performance.

If anyone has done this, please let me know.

Many thanks

Paul G



Tue, 20 Jul 2004 23:25:37 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Is there any way to convert sql server 2000 database to sql server 7.0 database

2. moving from Sql server 2000 evaluation to full version of Sql server 2000

3. Update NT4.0 and SQL Server 7.0 to Windows 2000 and SQL Server 2000

4. Connecting to a Sql Server 2000 SP3 from a Sql Server 2000 SP2

5. Linking DB2 Database in SQL Server 2000

6. Linking DB2 Database in SQL Server 2000

7. Migrating an SQL Server 7.0 database to an SQL Server 2000

8. Upgrading SQL Server 7.0 to SQL Server 2000 - Meta Data Repository Database

9. Upgrading a Database from SQL Server 6.5 to SQL Server 2000

10. link SQL SERVER 7.0 and SQL SERVER 2000?

11. Upgrading SQL Server 7.0 to SQL Server 2000 - Meta Data Repository Database Version Problem

12. Getting a SQL Server 2000 database onto SQL Server 7


 
Powered by phpBB® Forum Software