setting up connection to access database on a website
From: dickey38 (tbus_at_craftilori.com)
Date: 05/24/04
- Next message: Ulysses Neto: "ADO with Oracle"
- Previous message: Boris Ivanov: "ADO 2.6 Installation"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 24 May 2004 13:01:06 -0700
I am just beginning to experiment with using MS Interdev 6.0 ADO features. I have a sample database on a website which I can connect to with ASP code like: DataConn.Open "DBQ=" & Server.MapPath("mydb.mdb") & ";Driver = ...
Point being that the Server.MapPath("mydb.mdb") will find the path to my database on the web when the .asp document containing this script is running on the web (and will also find the equivalent file on my PC when I am running the script on my PC under IIS). When I try to use a MS Interdev DTC to create a connection to my database, I seem to be forced to reference a database on my own PC or LAN. I can't find a way to specify that the database I want is on the web (or on whatever server is running the .asp document). I thought defining a Data Source Name would help, but I can't find a way to get a DSN to point to a web-based file either. What am I missing?
- Next message: Ulysses Neto: "ADO with Oracle"
- Previous message: Boris Ivanov: "ADO 2.6 Installation"
- Messages sorted by: [ date ] [ thread ]