Wrox Programmer Forums
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." 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 Basics 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 February 9th, 2004, 09:35 PM
Authorized User
Join Date: Jun 2003
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hcweb
Default Multiple DSN's using connection strings

I have a web app that uses a connection string and SSI to connect to a database.

Option Explicit
Dim strConnect

<!-- METADATA TYPE="typelib"
             FILE="c:\program files\common files\system\ado\msado15.dll" -->

In turn, the include file specifies a DSN connection like so:
strConnect = "DSN=DSN1;User Id=username;Password=password;"

Is it possible to connect to more than one datasource at the same time using the SSI, or can I specify another SSI include on the same page as the top include?
Old February 23rd, 2004, 02:42 AM
Friend of Wrox
Join Date: Sep 2003
Posts: 171
Thanks: 0
Thanked 1 Time in 1 Post

Yep. I use a single SSI for all of my connection strings so I can connect to multiple databases within my app.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Connection Strings WFletch Visual Basic 2008 Essentials 1 July 14th, 2008 09:42 AM
Securing connection strings haines ASP.NET 2.0 Basics 1 March 2nd, 2008 04:28 PM
Connection Strings WillyWonker BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 3 January 25th, 2005 10:40 AM
Connection Strings hcweb Classic ASP Basics 6 September 23rd, 2004 03:29 AM

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