add a sybase server as a linked server to sql server 2000

I have done a search on google and as of yet have found nothing to help me add a sybase server as a linked server on sql 2000. I really need the param string values to sp_addlinkedserver. We are running sybase Ase 12.5 on a unix platform. Here is my examp
le
sp_addlinkedserver @.server = 'myservername',
@.provider = 'Sybase ASE ODBC Driver',
@.provstr = 'Driver={Sybase ASE ODBC Driver};NA=servername,port#UID=myUserName;PWD=myUs erPWD;',
@.srvproduct = 'Sybase', @.datasrc = 'report_db'
This is not working.
Any help would be greatly appreciated.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Have you reviewed this article?
280102 How to set up a linked server to a Sybase database server and
http://support.microsoft.com/?id=280102
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.