Quote:> I can link to Oracle or another Sql Server, but can not link up to sybase
> sql server 11, any suggestions???
> Has anyone connected that way ?
1. Problem linking to Sybase as linked server
Anybody out there with experiece in linking to sybase servers ?
Using SQL Server 2000 we have had linked servers working against Sybase
servers using 'Sybase ASE OLE DB Provider'
Recently this stopped working and was only providing the "no error message"
error.
We have tried re-establishing the connection using Microsoft OLE DB Provider
for ODBC and setting up ODBC links to the Sybase server.
This also fails however we get error messages saying "unable to create
distributed tranasction"
In enterprise manager we are able to see all the tables in teh Sybase
database and if we use teh ODBC connection with MS Access we are able to
open the tables and view the contents.
Any suggestions ?
Thanks,
Stephen Brown
3. Link errors while linking a Sybase Client library program
4. HELP - AP/Pro serial I/O speeds
5. SQL Server 2000 -link to- Sybase 11 issue
6. Use OLE DB provider fo Jet with SQL Server 7
9. Linking a Sybase Server in SQL
11. Problem with Delphi SQL Links and Sybase