...

View Full Version : Posting form results to database w/ GoDaddy and Access...



JonathanSCS
07-18-2007, 11:12 PM
I'm new, and of course have a question....

I'm trying to post the results of a form to a database and then have that DB print out to an HTML file.... This is my form: http://ncaaautographs.com/successes/successes_asp.asp

However, as you can see when attempting this using FFox, I get an error. Any help at all would be appreciated.

nbcrockett
07-18-2007, 11:27 PM
Take a look at the database examples on this site.
http://www.asp101.com/samples/

mehere
07-19-2007, 03:16 PM
I'm new, and of course have a question....

I'm trying to post the results of a form to a database and then have that DB print out to an HTML file.... This is my form: http://ncaaautographs.com/successes/successes_asp.asp

However, as you can see when attempting this using FFox, I get an error. Any help at all would be appreciated.
what error are you getting?

miranda
07-20-2007, 04:43 PM
I tested and recieve a message that said General error: Invalid file dsn ''

So that right there tells you where to look. If you are using a DSN generally the System DSN is used and not a File DSN. This allows the webserver to connect to it. Have you tried connecting without a DSN using a DSNLess connection string instead of using a DSN?

mehere
07-20-2007, 04:58 PM
i too use godaddy's hosting and have found that you are better off using a DSNLess connection as miranda suggested.

nbcrockett
07-20-2007, 05:13 PM
Here's the DSNless code I use to connect to my access databases.



Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DBQ=" & Server.MapPath("../Databases/MyDB.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;MaxBufferSize=8192;Threads=20;", "username", "password"



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum