I am going beserk with the following 800 type error.
I have a shopping site based on Dreamweaver and accessing an Access database for usename verification.
Running on IIS on my latop the whole site works fine with this connection:
<%
// FileName="Connection_ado_c
onn_string
.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="true"
// Catalog=""
// Schema=""
var MM_conn_coffee1_STRING = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\\Inetpub\\wwwroot\\
coffee\\an
descoffee.
mdb"
%>
==========================
==========
==========
=====
When I try it on my server I get get the following error.:
Microsoft JScript compilation error '800a03ec'
Expected ';'
/Shop/Connections/conn_cof
fee1.asp, line 8
Dim MM_conn_coffee1_STRING
----^
==========================
==========
==========
====
My connection string is:
<%
// FileName="Connection_ado_c
onn_string
.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="true"
// Catalog=""
// Schema=""
Dim MM_conn_coffee1_STRING....
..........
..........
........pr
ob
Dim oConn, sConnection
Set oConn = Server.CreateObject("ADODB
.Connectio
n")
sConnection = "Provider=Microsoft.Jet.OL
EDB.4.0;" +_
"Data Source =\\myserver\database.mdb;"
+_
"Persist Security Info = False"
MM_conn_coffee1_STRING = sConnection
oConn.Open(sConnection)
oConn.Close
Set oConn = nothing
%>
The error occurs at line 8 : Dim MM_conn_coffee1_STRING
This only happens after the Index page has opened (basically a welcome page), , and the button "go to log-in" is clicked. The log-in page utilises javascript.
++++++++++++++++++++++++++
++++++++++
++++++++++
++++++++++
++++++++++
+++++++
I have posted this error on several user sites but I haven't received an answer in 4 weeks. Either I am asking a totally dumb question (always possible), or I
am doing somehting totally dumb (again possible), or no-one knows..........which I cannot believe.
I'd appreciate any guru who has a solution to my prob please.
Please consider me as a newbie...........ie don't laugh too loudly !!
Best wishes
Jim
