| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
ODBC Error on asp page |
|
From: |
Pamela Brunette |
|
Date: |
3/22/2001 1:52:47 PM |
|
IP: |
206.191.41.50 |
I keep getting the same error on my asp page every other week. Here is the error
"Microsoft ODBC Access Drivers. Cannot open database." Can some please help me figure out what is causing this error? Here is my code
<%
Dim Connection
Dim RS
Dim SQLStmt
Dim Branch, User_ID, FULL_NAME
dim MYNANE
Dim NAMELIST
Dim CALLSTR
Set Connection = Server.CreateObject ("ADODB.Connection")
Connection.Open "DSN=HRIS Access;"
SQLStmt = "SELECT Branch, User_ID, FULL_NAME"
SQLStmt = SQLStmt & " FROM TSB_Employee "
SQLStmt = SQLStmt & " WHERE Branch = 'ISAD'"
Set RS = Connection.Execute(SQLStmt)
%>
<% MYNAME = Request.ServerVariables("LOGON_USER")
Do While Not RS.EOF
NAMELIST = RS.Fields("User_ID")
NAMELIST = UCase(NAMELIST)
MYNAME = Ucase(MYNAME) %>
<%
If InStr(MYNAME, NAMELIST) <> 0 then
'call MenueEmpInf.AddItem(0,"Post Scriptum - Discussion Forums",6,6)
MENUSTR = "Post Scriptum - Discussion Forums"
CALLSTR = "call MenueEmpInf.AddItem(0,"""+MENUSTR+""",6,6)"
End if
RS.MoveNext
Loop
RS.close
%>
Thank You |
Follow Up - Re: ODBC Error on asp page - David 3/25/2001 6:05:01 AM
Follow Up - Re: ODBC Error on asp page - nitin 4/8/2001 11:48:00 AM
|
|
|
|
|
|
