Re: SQL Server--> Sybase linked server

From: satyaki (satyaki_at_discussions.microsoft.com)
Date: 09/21/04


Date: Mon, 20 Sep 2004 23:39:03 -0700

I think you have to check for the Open Client for ASE 12.5, with Sybase.
Sybase ODBC comes with Open Client.

"Hassan" wrote:

> Can you create an ODBC data source connecting to Sybase ? If so then you
> could choose the OLE DB provider for ODBC source and enter the data source
> name you created.. See if that works..
>
> "Harvinder" <anonymous@discussions.microsoft.com> wrote in message
> news:174d01c499c1$6c3d96d0$a401280a@phx.gbl...
> > Hi,
> >
> > I installed the Sybase ASE 12.5 on win2003 machine and
> > have SQL Server 2000 also on the machine. i need to create
> > linked server from sql server database to sybase
> > database but i can't see the ODBC driver for sybase. Are
> > drivers not installed with ASE or how can i get the
> > drivers. I was not able to find drivers on SYBASE website.
> > Do microsoft have any ODBC drivers to connect to Sybase
> > database?
> >
> > Thanks
> > --Harvinder
> >
>
>
>



Relevant Pages

  • RE: ODBC Error with Sybase from Win2K Server (but works from WinXP!)
    ... I'd like to know if you create a DSN in odbc ... When configuring the DSN for the ODBC connection to Sybase, ... SQL Server connection. ... >> HOWEVER, exeute the same stored proc on my workstation (WinXP Pro SP1, ...
    (microsoft.public.sqlserver.odbc)
  • Re: Sybase Source. What "data flow source" to use?
    ... Is there not a Sybase OLE DB Driver? ... I've been so excited about SSIS and telling my co-workers how ... Sybase seems like a no-brainer need to me. ... that the connection is valid and and I'm even able to get the ODBC ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server--> Sybase linked server
    ... Can you create an ODBC data source connecting to Sybase? ... > drivers not installed with ASE or how can i get the ...
    (microsoft.public.sqlserver.server)
  • Re: Getting external data ODBC connect errors when connecting with Access
    ... You probably have better luck getting solution from Sybase newsgroup. ... Don't have a problem with ODBC with Excel works fine but I run into ... > layer:internal net library error: Net-Lib protocol driver call to connect ...
    (microsoft.public.sqlserver.programming)
  • Insert fails on linked server to Sybase
    ... system ODBC dns pointing to a Sybase server. ... The Sybase OLD DB Provider is very unreliable, so we have to use the ODBC ... I can select, delete and update tables in Sybase using the linked server, ...
    (microsoft.public.sqlserver.odbc)