sql server odbc: 1. Using the ODBC tool I created System DSN (SysbaseDSN) and the “Test
Connect” established a connection … after prompting for the UserName and PW.

2. Ran the following from Query Analyzer
USE MASTER
EXEC sp_linkedservers

USE MASTER
EXEC sp_addlinkedserver 'SyBaseServer', ' ', 'MSDASQL', 'SyBaseDSN'

USE MASTER
EXEC sp_linkedservers

The link was added.

3. From Query Analyzer ran the following
SELECT *
FROM SyBaseServer.SyBaseDB.dbo.Table1

The following error was returned.

OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [DataDirect][ODBC Sybase Wire Protocol
driver][Sybase ASE]Login Failed. Check for valid user ID, server name and
password.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize
returned 0x80004005: ].


Is this an issue with how the DSN was created and the fact that it prompts
for the UserName and PW to establish the connection??

--
Thanks in advance

Hello,

You can refer to the following article:

How to set up a linked server to a Sybase database server and troubleshoot
problems that may occur

http://support.microsoft.com/?id=280102

If you use a third-party driver or provider to connect to the Sybase
database server, you must contact the third-party vendor for any problems
that occur with the driver or with the provider.

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.