Re: Sybase SQL Anywhere

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 04/18/04


Date: Sat, 17 Apr 2004 21:09:55 -0500

I would first create a DSN (ODBC datasource). You can then point to this DSN
when select to link tables. A great method of connecting to external data is
with Pass-Through queries. You can specify a DSN when building a connection
string within the P-T.

-- 
Duane Hookom
MS Access MVP
"Michael" <anonymous@discussions.microsoft.com> wrote in message
news:9DDBC6EB-6909-43EA-9707-17523BDE9D3B@microsoft.com...
> We are running Sybase SQL Anywhere.  I have been using Infomaker for
simple reports.  I was told that Access is  a much better alternative.  How
do you connect to database with Access 2003?


Relevant Pages

  • Re: DSN VS Logon
    ... What protocol are you connecting with? ... We're moving on servers to a new Domain then we will reimage ... Before we moved it the DSN file worked fine we ... You can check your MDAC ...
    (microsoft.public.sqlserver.security)
  • Re: ConnectionString using DSN not working
    ... DSNs are not supported for SqlClient, ... When connecting to a SQL Server database from ... The only exception to that rule would be if you were connecting to ... And here is the one using DSN ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ODBC connection without knowing user and password
    ... ODBC System DSN did not store password. ... As a rule, the a DBMS checks for credentials, not a DSN or the Driver ... You have not specified the DBMS you are connecting to. ...
    (microsoft.public.data.odbc)
  • Re: ADO Connection via DSN
    ... Isn't the point of connecting via a DSN so my program doesn't have to worry about login and security information? ... the DSN will get you to the server. ...
    (borland.public.delphi.database.ado)
  • Re: Connecting via File DSN?
    ... Add-ins | Relink Manager, or File | Get External Data. ... > a file dsn. ...
    (microsoft.public.access.modulesdaovba)