****URGENT **** Asp-Database Not working Online????

Question

I have a asp supported site hosting. I have a asp form page that collects info and inserts into a ms-access databases. I made a system dsn for the connection. It works perfectly on my pc(localhost) but when i upload on the net it shows http 500 internal error. Why??
any solution???

visit www.indiaearns.com/t1.html for a first hand experience of the problem

Please e-mail me at [e-mail] if possible !!

Answer 1

If you are using DSN then you have to create that DSN on server, so use DSN less connection.
Use the code below

Dim cnn As Object 'Connection Object
Dim rst as Object 'RecordSet Object
Dim varConnectionString 'store connection string in a variable.
Dim sqlQuery 'Store sql query in a string variable.
varConnectionString = "Driver={Microsoft Access Driver (*.mdb)}; User ID=; pwd=; DBQ=" & Server.MapPath(<.mdb name>)
cnn = Server.CreateObject("ADODB.Connection")
cnn.open(varConnectionString)
rst = Server.CreateObject("ADODB.Recordset")
rst.Open(sqlQuery, cnn)
'Now you can populate the recordset object rst to use retrived data.

On the server keep you access .mdb file in a folder and give read and write permission to that folder, so that you can insert data in the .mdb file also.

If the problem not solve you can write me on [e-mail].

Answer 2

Did you create DSN on the server?
1. Create DSN on the server via control panel of ur server
2. Change the Connection query string (if required.)

Answer 3

See this might help you

http://www.google.co.uk/search?hl=en&q=Asp-Database+Not+working+Online&btnG=Search&meta=