DSN Error Connecting to Sql Server, Trusted Connection Error

From: Earl Teigrob (earlt777_at_hotmail.com)
Date: 11/05/03 

Date: Wed, 5 Nov 2003 08:50:29 -0600

I am try to connect to a SQL Database on a differect Domain. A Dsn entry
gives me an error but a connection string works fine. The application we are
using requires a DSN

1. I can connect to the database just fine using a connection string that
includes the username and password

2. When I set up the DSN and press test, it tests successful

3. When I use the DSN in my asp code, it gives the following error.
-------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.

/_landingPg/Default.asp, line 26

-------------------------------------------

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: Connecting to SQL Server on Windows
    ... my $auth = ... attribute to the connection string. ... without a DSN once you replace DSN with DRIVER=xxx (you get this string ... Sorry I forgot to specify that the host, database, user, and auth fields are assigned values. ...
    (perl.dbi.users)
  • Re: Connecting to SQL Server on Windows
    ... my $auth = ... attribute to the connection string. ... without a DSN once you replace DSN with DRIVER=xxx (you get this string ... Sorry I forgot to specify that the host, database, user, and auth fields are assigned values. ...
    (perl.dbi.users)
  • Re: How do I add option ZERO_DATE_TO_MIN in mysql connector?
    ... > For 1, it seems that you can set the value in the "Option" textbox in> GUI, if you are using Windows platform. ... I guess this will override any options set by the checkboxes in the DSN construction dialog so it might be dangerous. ... May be you know a way to get the DSN-less connection string from a DSN? ... ODBC DM will then prompt a dialog to allow users to select a DSN at runtime. ...
    (microsoft.public.data.odbc)
  • 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)