I am going beserk with the following 800 type error.

My "Index" page (basically a welcome page) has a link to a "Log-in Page",
that works fine using IIS on my laptop. ( A Dreamweaver site).

However when using on the Brinkster server I get the following error.


Microsoft JScript compilation error '800a03ec'

Expected ';'

/Shop/Connections/conn_coffee1.asp, line 8

Dim MM_conn_coffee1_STRING
----^


My connection string is:

<%
// FileName="Connection_ado_conn_string.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="true"
// Catalog=""
// Schema=""
Dim MM_conn_coffee1_STRING

Dim oConn, sConnection

Set oConn = Server.CreateObject("ADODB.Connection"
sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" +_
"Data Source =\\premfs17\sites\Premium17\myname\database\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



The log-in page uses javascript so after an initial error, 800a03f7,
where I had
my connection string setup for VB script (after a Google search I found
another lost soul had a similar prob that was fixed by changing her
string " ' " for "//" and "&" to "+"..........that fixed her prob...but not mine).

So I'd appreciate any guru who has a solution to my prob please.
I am sure the person who soves my prob will go straight to heaven....one day !!

Best wishes
Jim