Ok, I want you to entertain me for a moment ;] Fire up notepad and place this in the editor.
<%@Langauge=VBScript%>
<%Option Explicit%>
<%
Dim objConn
Dim sConnection
Dim dbPath
Dim rsgameused
dbPath = "/db/HockeyCards.mdb"
sConnection = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=''& Server.MapPath(dbPath)"
Set objConn = Server.CreateObject("ADODB.Connection")
Set rsgameused = Server.CreateObject("ADODB.RecordSet")
objConn.Open sConnection
strSQL = "SELECT * FROM" & tablename
rsgameused.Open strSQL, sConnection
rsgameused.close
Set rsgameused = Nothing
objConn.Close
Set objConn = Nothing
%>
go to file -> save as name the file "test.asp" and place it in your web folder. Call it up in a browser window and see if it bombs on you.
YOU must include adovbs.inc as it contains all the constants used to work with a database (I notice that you do NOT have this include anywhere in your code.) adovbs.inc should be on your server, do a file search for it and place it in the root of your web directory along side test.asp.
(If you can't find adovbs.inc on your pc you can download it from here:
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=123 )
And your error means that sConnection is defined twice in your code e.g.
Dim sConnection
//code
Dim sConnection <--error is thrown here.
================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
