Re: MS Access to Sybase ODBC connectivity problem

Managing DSNs from an Access app is always a PITA. Your best bet is
not to use a DSN at all. You can write code to link TableDef and
QueryDef objects dynamically, supplying the correct connection string
at runtime.

--Mary

On Tue, 3 Jan 2006 14:57:02 -0800, "SashaB11"
<SashaB11@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I am trying to connect to a Sybase database from an MS Access db.
>
>The only way it works is if I use System DSN.
>
>Using File DSN or spelling the connection strings out in the linked tables
>or pass-through queries results in the following error:
>
>"Reserved error (-7778); there is no message for this error"
>
>I am using the following connection string:
>
>"ODBC;Driver={SYBASE ASE ODBC
>Driver};Srvr=ServerName;DB=DB_Name;Uid=MyUserID;Pwd=password;"
>
>Thanks!!!
.

Relevant Pages

  • Re: Create DSN Programmatically
    ... Referring to the connection string as a Data ... > Source Name (DSN) is a naming convention used to refer to the connection ... Only in the case of ODBC API ...
    (microsoft.public.vsnet.general)
  • Re: Trying to connect to MySQL db with DAO using ODBC
    ... the connection string I'm using is copied from the example in the ... I did as you suggested and created a DSN. ... works while the 'apparently' equivalent DSN-less connection string does not. ... your code set or add all the properties exactly as you see ...
    (microsoft.public.vb.database.dao)
  • Re: Problems with Access 2003 and SQL Server 2005
    ... Driver in its place. ... Sylvain Lafontaine ... A DSN is just an alias for a connection string that is stored in the ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Using user id and pwd in data source name
    ... If you have a DSN, then all you need to do is to specify this DSN in your ... connection string and it should work. ... ADO does not work with ODBC directly, then ADO will place OLEDB for ODBC ... In the system dsn you>specify all the ODBC information like user, password, server, database>name, etc. ...
    (microsoft.public.data.ado)
  • Re: How to create DSN using asp.net?
    ... William Vaughn ... "Shibu" wrote in message ... > DSN ... >> solution where the connection string contains all of the needed ...
    (microsoft.public.dotnet.framework.adonet)