ASP and Access

frontz · #1 (**permalink**) 03-18-04, 18:59

Hello,

Here's my question.

Im running a quasi-webserver from my place. Its a school project. Its running fine and dandy. However I needed to upload it to a domain I own in order to have access to if for a presentation.

I uploaded all the pages and the databases. Is it legit to have the db physically on the domain? I can't seem to get it working.

Thanks.

rokslide · #2 (**permalink**) 03-18-04, 19:34

Legit? Definately, although you run the risk of it being available for people to grab depending on where in your site you have placed it...

Your problems probably come from the method you use to connect to the db or due to the fact that your host doesn't supprot asp....

What problems exactly are you having??

frontz · #3 (**permalink**) 03-18-04, 20:28

Quote:

Originally posted by rokslide
Legit? Definately, although you run the risk of it being available for people to grab depending on where in your site you have placed it...

Your problems probably come from the method you use to connect to the db or due to the fact that your host doesn't supprot asp....

What problems exactly are you having??

Well i was using:

Code:

    'Open the Connection
    Set usrConn = Server.CreateObject("ADODB.Connection")
	' Attempt to open connection
	usrConn.Open "driver={Microsoft Access Driver (*.mdb)};" & _
      "dbq=c:\data\data.mdb"

to open my db. not sure really what to use now... i tried using the address that it was stored on the web but not dice.

thanks.

rokslide · #4 (**permalink**) 03-18-04, 20:36

when you say the address that was stored on the web what do you mean?

You should probably look at using mappath to locate the actual drive location for the database file. That should solve your problem if it's a location problem.

frontz · #5 (**permalink**) 03-18-04, 20:39

Basically I have a web domain. And I want everything to reside on it. So I want the database and all the asp pages to be on the domain so it can be stand alone.... i'll check out mappath.

rokslide · #6 (**permalink**) 03-18-04, 20:42

try this....

Code:

    'Open the Connection
    Set usrConn = Server.CreateObject("ADODB.Connection")
	' Attempt to open connection
	usrConn.Open "driver={Microsoft Access Driver (*.mdb)};" & _
      "dbq=" & mappath("data.mdb")

assuming that your data.mdb file is in the same location as your asp page that is making the connection

sjjs · #7 (**permalink**) 03-23-04, 16:23

Without wanting to state the obvious, does your host support the use of a DB and, if so, have they given you a specific location to put it in?

Internet Services

Web Development

Digital Marketing

Consumer Tech