Re: Connect MS Access to Sybase using ADO

From: Carl Prothman [MVP] (carlpr_at_spamcop.net)
Date: 05/24/04 

Date: Mon, 24 May 2004 08:39:17 -0700

Chris wrote:
> Can someone please tell me how to connect to Sybase using ADO in
> Access?
>

Try using it's OLE DB Provider:

oConn.Open "Provider=ASAProv;Data source=myASA"
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForAdaptiveServerAnywhere 

-- 
Thanks,
Carl Prothman
Microsoft ASP.NET MVP
Hire top-notch developers at
http://www.able-consulting.com

Relevant Pages

  • Re: Unbekannter Fehler mit dem SQL Server OLE DB Provider
    ... > ADO 2.8 und den OLE DB Provider verwenden. ... Next by Date: ...
    (microsoft.public.de.sqlserver)
  • Re: Table adapter ???
    ... ADO was a lightweight COM layer built on top of OLE DB. ... ADO and OLE DB updates came in downloads of the MDAC pack (Microsoft Data ... It also came with a OLE DB provider for ODBC which meant ...
    (microsoft.public.data.ado)
  • Re: MySQL via OLE DB
    ... But I could not find an OLE DB Provider for MySQL. ... no OLE DB provider for use with ADO. ... Does anybody know where I can download an OLE DB Provider for MySQL 5? ...
    (borland.public.delphi.database.ado)
  • Is it possible to use ADO in threaded service app?
    ... I have declared ADO DB connection and query for each thread, ... -When I use as ole provider Microsoft Jet 4.0 (for storing data use Access ...
    (borland.public.delphi.database.ado)
  • Re: CREATE DATABASE fails in DBD::ADO 2.75-2.83
    ... > mySQL to SQL Server, and the SQL Server examples I had to work with all ... > could be more dynamic with ADO. ... - OLE DB Provider for ODBC Drivers ...
    (perl.dbi.users)