Database Connection Error

[fdsouth]

Can anyone tell me what is wrong with the following lines?

<script LANGUAGE = &quot;VBScript&quot;>

Option Explicit

Dim objDB
Dim objRS
Dim sDBName
Dim sAction
Dim sRowColor
Dim html
Dim sql
Dim sError

sDBName = &quot;driver={Microsoft Access Driver (*.mdb)};dbq=F:\catalog.mdb&quot;
Set objDB = Server.CreateObject(&quot;ADODB.Connection&quot;)
objDB.Open sDBName
.
.
.
</script>

I keep getting an error in the line defining sDBName that states "Variable is undefined: 'Server'" when I try to launch the page. I'm new at ASP programming, so please have patience with these basic questions.

Thanks.

 

[vasah20]

change your first line to this:

<script LANGUAGE = &quot;VBScript&quot; RUNAT=SERVER>

Alternatively, you could drop all the <script> tags, and just use
<%
code goes here
%>

hth
leo leo

 

[fdsouth]

I changed the first line to what you suggested and still received the same error message. I'm running this locally from a workstation for debugging before I post it to our web site at our ISP. I did set up an ODBC link to the database (although I think I set up the DNSless connection correctly), but that didn't help.

I'm stumped.

 

[GlennBSI]

You say you're running this locally from a workstation. You must be running this on a webserver - either full-blown IIS or Personal Web Server (PWS).

 

[fdsouth]

Yes, I finally figured that out last night when reading through a text I have on ASP.

Thanks.