[thelist] Database Schema from ASP

[Scott Webster]

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;

http://www.4guysfromrolla.com/webtech/022100-1.2.shtml
http://www.devguru.com/Technologies/ado/quickref/connection_openschema.html

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
;)

hth