Problem with migriating SQLServer2000's replication program to SQL -- sql server replication

jacky
7/20/2006 10:46:01 PM

I am doing a project to migrate a replication program from SQLServer 2000 to
SQLServer 2005. This program is used to replicate SQLServer's data to an
ODBC/DSN subscriber. The programing can not successfully replicate SQL to
ODBC, I have check the error-log , it seems that, SQLServer pull SQLs like
insert into [table1] values(?,?);
The ODBC is registered for IBM DB2 database, it can not accept the [table1]
qualifier. Can I configure SQLServer 2005 to use a qualifier that DB2 can
accpet ?

Does anyone know this problem? Thanks a lot!!
:)

Jacky.

--

Hilary Cotter
7/21/2006 12:00:00 AM

SQL Server 2005 can be configured to replicate to oracle and db2 servers,
but you need to use ole-db. To make it word for odbc review the notes in the
bol under

How to: Create a Subscription for a Non-SQL Server Subscriber (Replication
Transact-SQL Programming)

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

sql server replication : Problem with migriating SQLServer2000's replication program to SQL