Wrox Programmer Forums
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 6th, 2005, 01:23 PM
Registered User
Join Date: Jan 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Application DSN and Session DSN


I am moving my website from an NT4 box to a Windows 2000 box. Some of the code uses an application level DSN e.g.
Application("db_ConnectionString") = "DSN=DATAWAREHOUSE;UID=sa;PWD=*******"

I cannot find the DSN entry on the machine using the ODBC screen.
However the pages that use this connection string do work on NT4.
Also there is another connection string with the same DSN name, eg.:
Session("ConnectionString") ="DSN=DATAWAREHOUSE;UID=DWOLD;PWD=*******"

I have found the corresponding DSN entry on the machine for this connection string.
Again the pages that use it work on NT4.

Moving to Win2k, the pages that use the 1st connection string do not work. I have not attempted to put add 2 DSN entries to the ODBC screen with the same DSN name.

Do you have any thoughts on why the two connection strings work in NT4 but not Win2k?
Why the application level connection string works without a corresponding DSN entry on the ODBC screen?

Many thanks in advance.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help please.......... DSN kumar1225 Java Databases 1 December 26th, 2007 09:02 AM
DSN umeshtheone SQL Server 2000 1 June 8th, 2007 04:18 AM
dsn umeshtheone SQL Server 2000 1 May 16th, 2007 04:54 AM
Create DSN Anantsharma VB How-To 2 September 28th, 2004 01:07 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.