ODBC Call to SQL Server Fails from ASP Application

From: Paul Gascoigne (paul.gascoigne@breeze-it.com)
Date: 08/14/02 

From: "Paul Gascoigne" <paul.gascoigne@breeze-it.com>
Date: Wed, 14 Aug 2002 13:06:14 +0100

We have an Access 2000 database that uses a file DSN to link to a number of
SQL Server tables (via linked tables facility), there are no problems with
this DSN connection in the Access 2000 Environment. However, when trying to
access the same linked SQL Server tables (via Access) from an ASP
application, the connection to SQL Server fails (using both a trusted and
non trusted connection with the DSN - we've tried both). However, if we try
to connect directly to the SQL Server tables using the same DSN bypassing
Access, we have no problems.

So to summarise:

ASP direct to SQL Server via DSN - OK.
ASP to Access 2000 to SQL Server via linked tables using same DSN - not OK.

We're assuming we have the correct permission set-up since the ASP
application works fine in scenario 1 described above.

Please help, this problem is torturing 3 developers. Before you ask, there
is a reason good why we want to go via Access and not direct to SQL Server.

Thanks in advance.

PG

Relevant Pages

  • RE: Urgent problem about SQL Server
    ... Most of the problems I've had with ASP have been because of this. ... I have a problem connecting my SQL Server 2005 from a ASP Webpage. ... When I trying to connect using the following connection string: ... or any setting missing in the SQL Server to accept Web ...
    (microsoft.public.sqlserver.security)
  • Re: connecting to sql server from asp page
    ... In your DSN, if you include the login and password, then you are specifying ... Connectivity client application are always ignored by SQL Server ... You have two choices - either supply the uid and pwd in the connection open ... to used both Windows and Sql Server authentication. ...
    (microsoft.public.sqlserver.connect)
  • Re: ODBC timeout when xp_cmdshell execute a long script
    ... I have this problem that seems to be related to ODBC connection ... mainly by setting the connection object's timeout value to 0 ... I have an ASP page connecting to a SQL server retrieving data via a single ... Here's the snippet of my ASP ... ...
    (microsoft.public.sqlserver.programming)
  • cannot access website
    ... Nerve.com--this started a few weeks ago; I do not get the error message on ... Microsoft OLE DB Provider for ODBC Drivers Error '80040e4d' ... Not defined as a valid user of a trusted SQL Server connection. ... The DSN used to connect to the Commerce database is misconfigured to use ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Providers: DSN vs DSNLess. Data Returned is different?
    ... Are you using SQL Server? ... DSNs are basically a mechanism to save and set connection attributes at ... the DSN is setting some attribute that you aren't setting in the DSN-less ... Using ASP I found that the recordset was always closed even the ...
    (microsoft.public.data.odbc)