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]

Re: Problem with my database

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

"zokinjo" <grifone@net4u. hr> wrote in message
news:blf8oj$jbq $1@bagan.srce.h r...[color=blue]
> Hello! I have only recently started to learn ASP and this is the[/color]
situation:[color=blue]
> 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[/color]
pc[color=blue]
> but when I uploaded all of this to the server all I get on my website is[/color]
an[color=blue]
> 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?
>
>
>
>[/color]

[Bullschmidt]

Re: Problem with my database

<<
I'm sure that the path to the database is correct. What could be the
reason?[color=blue][color=green]
>>[/color][/color]

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...


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[zokinjo]

Re: Problem with my database

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.CreateOb ject("ADODB.Con nection")
objConn.Connect ionString = "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?


"Bullschmid t" <paul@bullschmi dt.com-nospam> wrote in message
news:uaF8CyKiDH A.2224@TK2MSFTN GP10.phx.gbl...[color=blue]
> <<
> I'm sure that the path to the database is correct. What could be the
> reason?[color=green][color=darkred]
> >>[/color][/color]
>
> 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...
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]

[zokinjo]

Re: Problem with my database

Thanks Ray, but it seems ok to me.

"Ray at <%=sLocation% >" <myfirstname at lane 34 . komm> wrote in message
news:eYjU5wHiDH A.1508@TK2MSFTN GP10.phx.gbl...[color=blue]
> Do a view source, and you'll probably see there's an error that doesn't[/color]
show[color=blue]
> up in the browser, because it's within an <option> tag or something along
> those lines.
>
> Ray at home
>
> "zokinjo" <grifone@net4u. hr> wrote in message
> news:blf8oj$jbq $1@bagan.srce.h r...[color=green]
> > Hello! I have only recently started to learn ASP and this is the[/color]
> situation:[color=green]
> > I made a database in MS Access and two ASP pages, one with a drop-down[/color][/color]
box[color=blue][color=green]
> > with some options in it and the other one which then shows more data[/color][/color]
from[color=blue][color=green]
> > the database about the chosen option. All of this worked perfectly on my[/color]
> pc[color=green]
> > but when I uploaded all of this to the server all I get on my website is[/color]
> an[color=green]
> > 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[/color][/color]
be[color=blue][color=green]
> > the reason?
> >
> >
> >
> >[/color]
>
>[/color]