Migrate SQLServer 2000's replication program to SQLServer 2005

microsoft.public.sqlserver.programming

21 Jul 2006 5:40 AM

jacky

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.

--
I like computer!!!