ASP & Database working fine locally but not online?

[trevorsaint]

I have finally figured out how to connect to a database etc and everything looks great when viewed locally. I have tried everything and all i get online is a 500 error message, I dont understand. I am no manual coder which is why i did this in dreamweaver as I am more a designer than a programmer, but nevertheless there is a glitch somewhere. Everything seems fine, the site was defined both the local and remote were defined, so everything seems ok, but I still have this error message. Can anyone please provide me with a solution :)

Thanks

Trev

[abzoid]

Are you using a DSN (data source name) for your database? If so, has your host set up the DSN on the remote server? There is some system configuration that must be done, similar to what you did locally, to define the database on the server.

[trevorsaint]

I did use a DNS Source name yes. There must be a simple method as all I want to do is mess around with this. Surely you dont have to prepare it via the hosting company is there not a simple method it is an access database file I am connecting to. If that makes any difference and not a mySQL database ??? please help

And thanks for the reply

Trev

[abzoid]

No, the host must still set up the DSN on the server even for Access database.

[prstudio]

yep

and 500 isn't necessarily due to the database, but sounds like that is what your trouble is

[trevorsaint]

Thanks for your input people, I got it working but in terms of sorting it with the host this was not the case, I did it manually no need to get the host to sort it out.

Here it is, just basic but it works.

Sample Dynamic (http://www.blue-leaf.co.uk/dynamic/image.asp)

So thank you for your help.