Cannot create a new Oracle Publisher

I got this error when create a Oracle Publisher:

Oracle server cannot be enabled as a Publisher because of the following error:

Additional inlonnation:

Unable to connect to Oracle database server 'abc’ using the Microsoft OLEDB provider MsDAORA.

For addition ilorrnation, see SQL Server Eiror 21627 in Troubleshooting Oracle Publishers in sQL Server Books 0nline. (Microsoft sQL Server, Error: 21627)

The login works fine in SQL Plus.

My test server:

SQL Server 2005 Developer w/ SP2

Oracle Client installed on SQL Server DB

MSDAORA installed

Please help.

Regards,

d-cpt

What version of Oracle client are you using?

What version of Oracle server are you connecting to?

Regards,

Gary

|||

Thank you for reply to my post.

Just back from a trip...

The Oracle client version is 10g

The Oracle DB version is 8.

Regards,

dcpt

|||

I believe you need to use the Oracle client driver to connect to Oracle publisher. It seems like you are using the Microsoft Oracle Oledb driver. Give that a shoot.

Regards,

Gary