MS SQL 2005 to Sybase via Linked server

I'm having an issue setting up a linked server connection on a new SQL 2005
box. The connection is working on the existing sql 2000 box.

I'm using the Merant 3.7 32bit OCBC driver to connection to a Unix hosted
Sybase database.

I first built a System DSN in the "ODBC Data Source Administrator" in
Control Panel. I enter all the sybase server info and use the "Test
Connect" optinon in the Merant ODBC driver setup and it works.

I go to SQL 2005 and add the linked server with the "OLEDB Provider for
ODBC" provider. I add the product name "Sybase", the Data Source (the DSN
name), and the login password.

When I try a test query it just hangs. I get no error message, just
"Executing Query" in the status bar.

I look at sysprocesses and I can see an OLEDB job to the linked server and
the waittime just keeps increasing. I have top stop/start sql to clear it.
I've let it run for 10 minutes.

I do the exact same test query on the existing 2000 box and it works in 2
seconds.

I tried re-building the linked server using the ODBC "Provider String"
rather than the "Data Source" DSN name and I get the same results.

"DRIVER={MERANT 3.7 32-BIT Sybase
ASE};NLN=Winsock;NA=xxx.xxx.xxx.xxx,xxxx;DB=master}"

In one of my rebuild attempts I mistyped the password and I actually did get
an error message from the Merant Driver through the OLEDB provider telling
me "login failed, check login/password". So in that case at least I know
the connection reached the Sybase server.

But apparently with the correct login/password, the connection keeps hanging
for an unknown reason.

Any known compatablilty problems or anything else different on 2005?

Thanks.


.

Relevant Pages

  • Re: MSDASQL headache
    ... The DSN used to create the linked server on SQL ... connected using credentials on the Progress database. ... ASP.NET connection string. ...
    (comp.databases.ms-sqlserver)
  • Re: Link Server
    ... I was trying to use a connection is the DTS packages, ... But it sounds like I have to write out the sql code in order to connect. ... >> I'm not sure what connection to use and how to set it up. ... > do you mean a linked server is defined on your SQL Server? ...
    (microsoft.public.sqlserver.dts)
  • Re: SqlServer to read Sybase
    ... Are you sure that your data source is System DSN, ... And I think account you using for run MS SQL must have corresponding rights ... M> I'm trying to import to SqlServerfrom a Sybase ODBC ... I can use the Sybase connection with appps like MSAcess, ...
    (microsoft.public.sqlserver.odbc)
  • Re: how to mapped the ms access db data to ms sql server
    ... I have setup my linked server. ... and the connection is ok. ... but how can i programmatically use the ms sql in my asp.net page? ...
    (microsoft.public.sqlserver.odbc)
  • Re: MS SQL to Sybase ASE replication using OLE DB
    ... There are two key elements to setting up the OLE DB provider for Sybase. ... The Sybase ids file is similar to a DSN, only it is a text file which is ... Once you have configured your ids you must build your linked server. ...
    (microsoft.public.sqlserver.replication)
Loading