[thelist] Database Schema from ASP

Scott Webster pippen at bigpond.net.au
Tue Mar 4 12:17:23 CST 2003

From: "Mike Stenhouse" <Mike.Stenhouse at spiritsoft.com>
To: <thelist at lists.evolt.org>
Sent: Wednesday, March 05, 2003 3:53 AM
Subject: RE: [thelist] Database Schema from ASP

: Thanks for the code Scott, it's much appreciated. I just tried it myself
: on my SQL Server db and got nothing but when I connected to an Access db
: I'm using for a different site I got all the right info... I've had a
: little play with my method of connecting to the SQL Server database -
: changing from DSN to a hardcoded connection string (shown below), and
: now it works fine! Any idea why that would be? There must be something
: about DSN that I don't know or haven't configured...
: Old Conn:
: "dsn=dsnMyDB;uid=UID;pwd=PW;"
: New Conn:
: Provider=sqloledb;Data Source=MyDB;Initial Catalog=SpiritSoft;User
: Id=UID;Password=PW;


Yeah - weird. But these articles explain your findings...

The 4guys article has a reference 1/2 way down the page that says not all the
schemas are supported by DSN/ODBC and that you'll have to use an OLDEB
connection string to use the other schemas.

>From the devguru article it seems that only 3? schemas are supported by DSN?

An excuse to bypass OpenSchema and become intimately aquainted with sysobjects


More information about the thelist mailing list