I'm no programmer but I though i'd be able to manage setting up this simple asp client check asp script, but try as i might, I can't get the script to look at the database. I keep getting error 2147467259.
Below is the script that includes the db location (as you can see its aimed at beginners), can anybody tell me whats wrong from this? If you need more, let me know.
Thanks in advance.
<%
'ASP Client Check - Configuration File
Dim strDBConn, intLog, strLogURL, strAdminName, strAdminPass, strCookieExpire
'Database connection. Edit the url of the following line to point to the "clients.mdb" file on
'the server computer, or replace everything between the double quotes with the name of your system DSN.
strDBConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http:\\
'Set intLog to "1" if you want to keep a log of attempts to enter.
intLog = 0
'Location of log file. For added security, you can make this a location inaccessible via the web.
strLogURL = "d:\
'Administration username and password. Set these variables only if using the admin script.
'Administration script requires cookies to be enabled in browser for session variable.
strAdminName = "admin"
strAdminPass = "admin"
'The date user cookies will expire (for those who opt to save their username/passwords)
strCookieExpire = "January 1, 2005"
'======================================================================================================
'Your custom subroutine
'======================================================================================================
'Please test the script with this default subroutine prior to modifying it.
'The code contained in this subroutine will execute when your clients login successfully.
'Alter only the code within the "Sub" and "End Sub" delimiters.
'See website FAQ on how to secure a redirect page.
Sub subCustomCode
If objRS("URL"
<> "" Then
Response.Redirect objRS("URL"
Session("sesUsername" = strUsername
Else
Response.Write objRS("HTML"
End If
End Sub
%>
Below is the script that includes the db location (as you can see its aimed at beginners), can anybody tell me whats wrong from this? If you need more, let me know.
Thanks in advance.
<%
'ASP Client Check - Configuration File
Dim strDBConn, intLog, strLogURL, strAdminName, strAdminPass, strCookieExpire
'Database connection. Edit the url of the following line to point to the "clients.mdb" file on
'the server computer, or replace everything between the double quotes with the name of your system DSN.
strDBConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http:\\
'Set intLog to "1" if you want to keep a log of attempts to enter.
intLog = 0
'Location of log file. For added security, you can make this a location inaccessible via the web.
strLogURL = "d:\
'Administration username and password. Set these variables only if using the admin script.
'Administration script requires cookies to be enabled in browser for session variable.
strAdminName = "admin"
strAdminPass = "admin"
'The date user cookies will expire (for those who opt to save their username/passwords)
strCookieExpire = "January 1, 2005"
'======================================================================================================
'Your custom subroutine
'======================================================================================================
'Please test the script with this default subroutine prior to modifying it.
'The code contained in this subroutine will execute when your clients login successfully.
'Alter only the code within the "Sub" and "End Sub" delimiters.
'See website FAQ on how to secure a redirect page.
Sub subCustomCode
If objRS("URL"
<> "" ThenResponse.Redirect objRS("URL"
Session("sesUsername"
= strUsernameElse
Response.Write objRS("HTML"
End If
End Sub
%>