ODBC con error

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

From: "David" <dlchase@xxxxxxxxxxxxxxx>
Date: Fri, 15 Jul 2005 11:46:21 -0500

We have an Access 2003 application that connects to SQL Server 2000 via ODBC
"linked" tables. One network user is getting the following error message
when they try to open the application:

ODBC--connection to '{SQL Server}-LIFEDEV03' failed.

All other users are able to open the application fine. We are using Windows
and SQL Server security so that valid domain users should have access to the
database. We do not use a username and password on the ODBC connect string
as we are using a "Trusted Connection".

Can anyone help? Thanks.

David

.

Prev by Date: Re: Problem with reading in packet mode
Next by Date: odbc driver for AIX??
Previous by thread: Accessing DB2 database on Mainframe with openrowset gives error
Next by thread: odbc driver for AIX??
Index(es):
- Date
- Thread

Relevant Pages

Re: How to have SQL_ERROR returned from RAISERROR within IF-BLOCK
... The problem has been fixed in SQL Server 2005. ... even modify the sequence of ODBC function calls and checking of the return ... I want to return SQL_ERROR to my application with a custom error message ... I get it returned fine when I execute the following statement using ...
(microsoft.public.data.odbc)
SQL Server ODBC Driver Ignores Authentication Setting
... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
(microsoft.public.sqlserver.security)
Re: Linking tables access - sql server 2005
... Another advantage of this method is that you don't need an ODBC setting on the local computer, ... Create a linked table to SQL Server without using a DSN ... Name of the table that you are linking to on the SQL Server database ... Function AttachDSNLessTable(stLocalTableName As String, stRemoteTableName As String, stServer As String, stDatabase As String, Optional stUsername As ...
(microsoft.public.access.adp.sqlserver)
Re: sql server + ODBC: error suppressed
... I have a program that connects to SQL Server through ODBC, one of my clients ... no error message is displayed either (which is strange and it works fine on ... are there any configuration parameters on sql server or ODBC ...
(microsoft.public.sqlserver.server)
Linked server to ODBC dsn.....
... Using my favorite ODBC sql query tool, i can select the System DSN, specify ... i go into SQL Server, and want to create a linked server to this same ODBC ... the error message really shouldn't matter. ...
(microsoft.public.sqlserver.server)