all groups > sql server replication > september 2007 >
You're in the

sql server replication

group:

Sql 2005 replication


Sql 2005 replication dk
9/6/2007 5:44:02 AM
sql server replication:
I am setting transactional replication from sql 2005 to sybase using Sybase
OLE DB provider and T-SQL scripting. I need help in defining these parameters:
@subscriber_datasource
@subscriber_provider
@subscriber_providerstring
@subscriber_location
@subscriber_catalog
Thanks very much
dk
Re: Sql 2005 replication Hilary Cotter
9/7/2007 12:00:00 AM
don't we all. It is not supported in SQL 2005.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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]

Re: Sql 2005 replication dk
9/13/2007 9:12:06 AM
Thanks for your reply. Well, I installed SYbase SDK 12.5.1 with the OLEDB
provider and, beleive or not, managed to connect to my sybase server. My
sirious issue was @subscriber_provider, as I somehow defined the rest from
the list. This is actually supposed to be 'Sybase.ASEOLEDBProvider'. After
setting that up by running sp_changesubscriber I connected to the test
database. Mind you, I set it up through the scripts, as it wasn't possible to
do it through the GUI.
I can give you more information latter when I see how the testing goes.
Thanks
D.

[quoted text, click to view]
Re: Sql 2005 replication magickarle
9/21/2007 1:37:57 PM
[quoted text, click to view]

Hi, can you post your transactional replication script? Thanks
AddThis Social Bookmark Button