Problem with my database

[zokinjo]

Hello! I have only recently started to learn ASP and this is the situation:
I made a database in MS Access and two ASP pages, one with a drop-down box
with some options in it and the other one which then shows more data from
the database about the chosen option. All of this worked perfectly on my pc
but when I uploaded all of this to the server all I get on my website is an
empty drop-down box. It seems that my page can't read the data from the
database. I'm sure that the path to the database is correct. What could be
the reason?

 

[Ray at]

Do a view source, and you'll probably see there's an error that doesn't show
up in the browser, because it's within an <option> tag or something along
those lines.

Ray at home

 

[Bullschmidt]

<<
I'm sure that the path to the database is correct. What could be the
reason?
I think it might be a problem with the path to the database in the
connection string. You could try switching over to a DSN whose
connection string is just the name of the DSN.

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...

 

[zokinjo]

Thank you for the tip, but my problem is still unresolved. Here's more
details, maybe it will be more clear: my database is "hnl.mdb" and in the
ODBC administrator I created a DSN called "hnl.dsn". And this is the part of
the code for the connection:

Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "hnl.dsn"

objConn.Open

As I said it works perfectly on my computer but not on the Internet. Here's
what confuses me: my DSN is created with the path to the database in my pc.
When it's uploaded to the server does it automatically find my database
there?

 

[zokinjo]

Thanks Ray, but it seems ok to me.

Do a view source, and you'll probably see there's an error that doesn't show
up in the browser, because it's within an <option> tag or something along
those lines.

Ray at home