page error number 2!!

[benbacardi]

ok, i have inc_menu.asp, which has this code for the first few lines:

Code: Select all

Home


<%
Set conn = server.createobject("adodb.connection")
DSNtemp = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("data.mdb")
conn.Open DSNtemp

sql = "SELECT * FROM pages"

Set rsPage = conn.Execute(sql)

When i view the pages which include it on my own pc, i get no error. However, i get this on the server:

Code: Select all

An exception occurred: 'Open' 

/benbacardi/wsc/includes/inc_menu.asp, line 6

or sometimes the error is "Unspecified" but the same line... whats going wrong? the website is www.websamba.com/benbacardi/wsc

[benbacardi]

in fact, just checked it out, and its where any connection to the database occurs

[Smokie]

Code: Select all

DSNtemp = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("data.mdb") & ";"

...or try actually using a DSN.

[Rob]

I think what *may* be happening Ben, is that your database is not being found.

I would do as Smokie suggests, and set up a system DSN. I'm sure you host will allow for a DSN.

[spinal007]

the problem may be that you're using a physical path to find the database.

e.g.:
let's say you database is at the root of your site. so:
www.yoursite.com/data.mdb

server.mappath("data.mdb") returns:
www.yoursite.com/data.mdb

if you view a page on the root of your site, it works fine. e.eg:
www.yousite.com/index.asp

but if you include the inc_menu.asp file in a page within a folder, e.g:
www.yoursite.com/help/inc_menu.asp
then you'll get an error because the server.mappath("data.mdb") function will now return:
www.yoursite.com/help/data.mdb
and your database won't be found....

if that's the problem, just use a virtual path
server.mappath("/data.mdb")
and it will always point to the root....

[Rob]

Thats good advice spinal. To add to it though, I would still recommend using a system DSN, or least moving the database out of the root into an obcurely named folder... similarly give the database an obscure name.

Having a DB called data.mdb in your root is about as unsecure as it gets.

[benbacardi]

oh ok then lol

actually, its just something that happens on the server from time to time, it often allows the site to work, sometimes not... whats a DSN, and once i've set one up how do i use it in my code?

[spinal007]

let me try this one.....
Data Source Name is a key registered on the server which stores the physical path of your database.

so you'd use:
DSNtemp = "Provider=Microsoft.Jet.OLEDB.4.0;DSN=MyMenuDatabase"

where "MyMenuDatabase" holds the path to your database

right?

[Rob]

Yes Spinal.... essentially, this is correct. You Hosting company usually makes provision for setting up DSN's.

Log-in to your domain control panel to access it. If you dont have the option, then email them.

[Smokie]

Its like storing your connection string on the server.

Spinal, i dont think you connect to it like that, i have always done it like this: DSNTemp = "DSN=MyDSN"

I dont think you need to specify the provider because you choose the provider when you setup the DSN on the server.

[Rob]

Well spotted Mr Connection String

[spinal007]

I wouldn't know coz I don't use DSN but I was just trying to get the concept accross.

either way, please accept my most sincere appology dear lord of all connection strings. I shall never fail you again.
:wink:

[Rob]

lol

[Smokie]

hey, no worries :wink: