Re: SQL Server--> Sybase linked server

From: Hassan (fatima_ja_at_hotmail.com)
Date: 09/13/04 

Date: Mon, 13 Sep 2004 15:04:51 -0700

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: SQL Server--> Sybase linked server
    ... I think you have to check for the Open Client for ASE 12.5, with Sybase. ... Sybase ODBC comes with Open Client. ... >> drivers not installed with ASE or how can i get the ...
    (microsoft.public.sqlserver.server)
  • Re: last_insert_id() / MSSQL
    ... > I connect to MSSQL via ODBC, exist some method to get last inserted ... I read in DBI docs: ... > For some drivers the value may only be available if placeholders have ... Sybase DBA/Developer ...
    (perl.dbi.users)
  • 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: AS 2005 / Cant build dimensions when RDBMS is Sybase
    ... Is Informix not supported for AS2005? ... I create a informix oledbdatasource and test connection ... but failed to create a infromix data source view.(More details ... Sybase is not a supported database for AS 2005. ...
    (microsoft.public.sqlserver.olap)
  • 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)