Database Connection

[Mike]

I need to use the Database Results Wizard to
make a connection to a database that is outside
of the current web. I cannot figure out how to
do this.

My database is in a different folder than my site
on my web server. The layout is like this:

Database Location:
C:\inetpub\wwwPortal\db\database.mdb

Web Site Location:
C:\inetpub\wwwPortal\html

With the DRW, I can only figure out how to
make a connection to the database if it were
in the 'html' folder. As far as I can tell, it will
not let me make a connection to the 'db' folder
that is outside of the web.

I have multiple forms on my site that I am able
to write information to the db. I just cannot
pull information from it using the DRW.

Any help would be appreciated.

Mike

 

[HB]

Create ODBC for the MDB, then add it to the web site by clicking Tools->Web
Settings->Database->Add

That will do

 

[MD WebsUnlimited.com]

Hi Mike,

You'll need to use a DSN to connect to the database.