S
Susan Cranford
I know this is simple but I'm new with it and can't see it. I am
calling this sub from an ASP page right after the
<html> tag as:
<!-- #include file="genproc.inc"-->
Then I call the sub below in the asp in the validate routine to 'Call
ConnectDB'
The connection itself is okay.
But, the page will not even display, I get a syntax error on the 'Sub
Connect()' line of this file (include file) :
------------------------
<html>
<head>
</head>
<body>
<%
Sub ConnectDB()
' Database Connection
Dim sConn, dcn
sConn = "Provider=SQLOLEDB; " & _
"Data Source=nnn.nnn.nnn.nnn\ServerName; " & _
"Database=theDB; " & _
"User ID=aUser; " & _
"Password=aUserPW;"
Set dcn = Server.CreateObject("ADODB.Connection")
dcn.ConnectionString = sConn
dcn.Open
End Sub
%>
</body>
</html>
calling this sub from an ASP page right after the
<html> tag as:
<!-- #include file="genproc.inc"-->
Then I call the sub below in the asp in the validate routine to 'Call
ConnectDB'
The connection itself is okay.
But, the page will not even display, I get a syntax error on the 'Sub
Connect()' line of this file (include file) :
------------------------
<html>
<head>
</head>
<body>
<%
Sub ConnectDB()
' Database Connection
Dim sConn, dcn
sConn = "Provider=SQLOLEDB; " & _
"Data Source=nnn.nnn.nnn.nnn\ServerName; " & _
"Database=theDB; " & _
"User ID=aUser; " & _
"Password=aUserPW;"
Set dcn = Server.CreateObject("ADODB.Connection")
dcn.ConnectionString = sConn
dcn.Open
End Sub
%>
</body>
</html>