flexpipe
asked on
Microsoft VBScript runtime error '800a01fb'
asp classic code generates Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'Execute'
<%Dim Conn, RS, SQL
set Conn = Server.CreateObject("ADODB .Connectio n")
set RS = Server.CreateObject("ADODB .Recordset ")
Conn.Open "Provider=Microsoft.Jet.OL EDB.4.0; Data Source=c:\inetpub\wwwroot\ gal.mdb"
RS.ActiveConnection = Conn
SQL="SELECT GAL.* FROM GAL"
Set RS=Conn.Execute(SQL)
Conn.Close
Set RS=Nothing
Set Conn=Nothing%>
The access database links to exchange gal. Security = Integrated Windows Authentication, Domain Users have full control to .mdb file.
An exception occurred: 'Execute'
<%Dim Conn, RS, SQL
set Conn = Server.CreateObject("ADODB
set RS = Server.CreateObject("ADODB
Conn.Open "Provider=Microsoft.Jet.OL
RS.ActiveConnection = Conn
SQL="SELECT GAL.* FROM GAL"
Set RS=Conn.Execute(SQL)
Conn.Close
Set RS=Nothing
Set Conn=Nothing%>
The access database links to exchange gal. Security = Integrated Windows Authentication, Domain Users have full control to .mdb file.
ASKER
Line 7 on Conn.Execute. Query runs fine in Access.
Try like the sample given below.
<%
set conn=Server.CreateObject(" ADODB.Conn ection")
conn.Provider="Microsoft.J et.OLEDB.4 .0"
conn.Open "c:/webdata/northwind.mdb" set rs=Server.CreateObject("AD ODB.record set")
rs.Open "Select * from Customers", conn
%>
<%
set conn=Server.CreateObject("
conn.Provider="Microsoft.J
conn.Open "c:/webdata/northwind.mdb"
rs.Open "Select * from Customers", conn
%>
sorry, like this
<%
set conn=Server.CreateObject(" ADODB.Conn ection")
conn.Provider="Microsoft.J et.OLEDB.4 .0"
conn.Open "c:/webdata/northwind.mdb"
set rs=Server.CreateObject("AD ODB.record set")
rs.Open "Select * from Customers", conn
%>
<%
set conn=Server.CreateObject("
conn.Provider="Microsoft.J
conn.Open "c:/webdata/northwind.mdb"
set rs=Server.CreateObject("AD
rs.Open "Select * from Customers", conn
%>
ASKER
Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'Open'
/plist.asp, line 6
<%Dim Conn, RS, SQL
set conn=Server.CreateObject(" ADODB.Conn ection")
conn.Provider="Microsoft.J et.OLEDB.4 .0"
conn.Open "c:/inetpub/wwwroot/gal.md b"
set rs=Server.CreateObject("AD ODB.record set")
rs.Open "Select * from GAL", conn
Conn.Close
Set RS=Nothing
Set Conn=Nothing%>
An exception occurred: 'Open'
/plist.asp, line 6
<%Dim Conn, RS, SQL
set conn=Server.CreateObject("
conn.Provider="Microsoft.J
conn.Open "c:/inetpub/wwwroot/gal.md
set rs=Server.CreateObject("AD
rs.Open "Select * from GAL", conn
Conn.Close
Set RS=Nothing
Set Conn=Nothing%>
try putting the security on mdb to full access to everyone just for testing. and then re-try.
ASKER
Done. No effect.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
Can you tell me the exact line you are getting error?
regards
Chandru