How to Link MS Sql 6.5 to MS Sql 7.0

How to Link MS Sql 6.5 to MS Sql 7.0

Post by gab.. » Thu, 13 Feb 2003 07:02:47



I have Sql Server in 6.5 and 7.0 Versions

my need is that i need to create a trigger
to run in 6.5 that capture some data
after inserted and send it to a table
in a database runnin in sql server 7.

i've read a lot of docs but nothing works.

thanks

**********************************************************************

Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

 
 
 

1. Linked Server MS SQL 7 to MS SQL 6.5

Has anyone had success linking a 7.0 server to a 6.5.

When I attempt a simple query with the servers linked, I get the
following:

OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: The catalog stored procedures
installed on server NTSQL2 are version 6.50.215; version 07.00.0330 or
later is required to support IDBSchemaRowset.  Please contact your
system administrator.]

Sent via Deja.com http://www.deja.com/
Before you buy.

2. Sybase performance problem

3. Making a MS-SQL 6.5 compatible database with MS-SQL 7.0

4. 25015-OK-TULSA-ORACLE-DBA Skills-RDBMS-GUI-Oracle DBA

5. ms sql 6.5 vs ms sql 7.0

6. Visual C++, Sybase SQL Server and Open Client dblib

7. Migration from MS Access 7.0 to MS SQL Server 6.5 - NEED HELP

8. Where can I find ODBC/JetEngine/Access error codes ?

9. How to migrate from MS-ACCESS to MS-SQL server 6.5/7.0

10. Help Convert MS Access SQL to MS SQL Server 6.5

11. MS SQL 2000 to MS SQL 6.5

12. Documents about the changes from MS SQL 6.5 to MS SQL 2000