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"