asp_databases thread: Establish a Connection using a URL
Message #1 by "Rod Aubertin" <mcountry@n...> on Tue, 18 Apr 2000 13:20:32 -0400
|
|
The problem I'm having is that I can do a database connection using the
pathname but what I need is to use a web server path.
My database is sitting in the fpdb directory and when try to use
"DBQ=URL=fpdb/db1.mdb" I get an error, although if I use the full pathname I
don't get the error.
Suggestions?
Rod Aubertin
Message #2 by Tristian O'brien <obrient@m...> on Wed, 19 Apr 2000 11:52:04 +0100
|
|
Have you set-up a virtual directory on the web server? also remember it's
VIRTUAL instead of FILE in the include directive
<!-- #include virtual="fred/default.asp" -->
-----Original Message-----
From: Rod Aubertin
Sent: 18 April 2000 18:21
To: ASP Databases
Subject: [asp_databases] Establish a Connection using a URL
The problem I'm having is that I can do a database connection using the
pathname but what I need is to use a web server path.
My database is sitting in the fpdb directory and when try to use
"DBQ=URL=fpdb/db1.mdb" I get an error, although if I use the full pathname I
don't get the error.
Suggestions?
Rod Aubertin
---
You are currently subscribed to asp_databases
Message #3 by "Ken Schaefer" <ken.s@a...> on Thu, 20 Apr 2000 12:19:59 +1000
|
|
Look up your documentation on Server.Mappath()
eg DBQ = Server.Mappath("db1.mdb")
Cheers
Ken
----- Original Message -----
From: Rod Aubertin
To: ASP Databases <asp_databases@p...>
Sent: Wednesday, April 19, 2000 3:20 AM
Subject: [asp_databases] Establish a Connection using a URL
> The problem I'm having is that I can do a database connection using the
> pathname but what I need is to use a web server path.
>
> My database is sitting in the fpdb directory and when try to use
>
> "DBQ=URL=fpdb/db1.mdb" I get an error, although if I use the full pathname
I
> don't get the error.
>
> Suggestions?
>
> Rod Aubertin
Message #4 by "Rod Aubertin" <mcountry@n...> on Thu, 20 Apr 2000 07:05:21 -0400
|
|
I found something else out yesterday and that was server.mappath. Got it
working on the internet but haven't tried it locally yet. Thanks for the
other avenue.
Rod
-----Original Message-----
From: Tristian O'brien
Sent: 19-Apr-2000 6:52 AM
To: ASP Databases
Subject: [asp_databases] RE: Establish a Connection using a URL
Have you set-up a virtual directory on the web server? also remember it's
VIRTUAL instead of FILE in the include directive
<!-- #include virtual="fred/default.asp" -->
-----Original Message-----
From: Rod Aubertin
Sent: 18 April 2000 18:21
To: ASP Databases
Subject: [asp_databases] Establish a Connection using a URL
The problem I'm having is that I can do a database connection using the
pathname but what I need is to use a web server path.
My database is sitting in the fpdb directory and when try to use
"DBQ=URL=fpdb/db1.mdb" I get an error, although if I use the full pathname I
don't get the error.
Suggestions?
Rod Aubertin
---
You are currently subscribed to asp_databases
---
You are currently subscribed to asp_databases
|