DSN less connection fro ASP pages

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: namita (anonymous_at_discussions.microsoft.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 13:43:59 -0800

I have installed Microsoft SQL server 2000 on a server.
My web server is having windows NT having all asp pages.
I want to connect to SQL Server 2000 using a DSN less
connection for my asp pages. Could anyone help me with
that?

Also, if I try to create system DSN on windows NT, it
gives me an error message and does not create DSN. What
could be the reason?

Thanks

Relevant Pages

  • RE: RefreshLink error - 3078
    ... this was tested on Windows XP w/ SP2 installed. ... because the DSN is incorrectly configured/installed. ... and it sure enough had showed the data I had in my SQL server ... Microsoft Online Partner Support ...
    (microsoft.public.access.conversion)
  • Re: Need resources for SQL Server 2000 Application Roles with ASP.NET apps
    ... The end user should never be logged directly in to sql server. ... accessing the asp pages, which in turn will access the database. ... > we intend to replace with ASP.NET applications. ... > log into Windows with their domain account information. ...
    (microsoft.public.sqlserver.security)
  • Re: Anyone can access my Sql Server!
    ... A Windows account needs to be granted access to SQL Server before a database ... If a user can connect to SQL Server via an ODBC DSN using ...
    (microsoft.public.sqlserver.security)
  • Connection.Execute and SQL stored procedures
    ... ..asp, the connection object and MS SQL Server as the DB can help me out. ... Five of the six calls execute as expected. ... This particular stored procedure does quite a bit of work within the DB, ...
    (microsoft.public.sqlserver.odbc)
  • ODBC Call to SQL Server Fails from ASP Application
    ... this DSN connection in the Access 2000 Environment. ... access the same linked SQL Server tables from an ASP ... ASP direct to SQL Server via DSN - OK. ...
    (microsoft.public.sqlserver.security)