Forums
This topic is locked
Microsoft OLE DB Provider for ODBC Drivers (0x8004
Posted 10 Aug 2006 12:47:42
1
has voted
10 Aug 2006 12:47:42 jayson villamor posted:
i use ms acces 2003 and i got this error Microsoft OLE DB Provider for ODBC Drivers (0x80040E4E)im using IIS here is my asp code
<html>
<body>
<%
dim DB
Dim RS
set db = Server.CreateObject("adodb.Connection"
set RS = Server.CreateObject("adodb.Recordset"
db.connectionstring = "Driver={Microsoft Access Driver (*.mdb)}"
db.open dsn
RS.ActiveConnection=DB
RS.CursorLocation=3
RS.Locktype=2
RS.CursorType=3
RS Source ="Select*from friends"
RS Open
lastname=RS("name"
%>
</body>
</html>
please help im new to asp programming
Replies
Replied 10 Aug 2006 19:15:33
10 Aug 2006 19:15:33 Charles Harford replied:
Try here:
www.connectionstrings.com/
Looks like you forgot to tell it what database file to get your data from.
Charlie
www.connectionstrings.com/
Looks like you forgot to tell it what database file to get your data from.
Charlie
Replied 12 Aug 2006 12:11:49
12 Aug 2006 12:11:49 meenu susi replied:
hi..
try this..
set con=server.createobject("adodb.connection"
set rs=server.createobject("adodb.recordset"
filepath=server.mappath("database.mdb"
con.open "Driver = Microsoft Access Driver(*.mdb);dbq="&filepath
regards
meenu
try this..
set con=server.createobject("adodb.connection"
set rs=server.createobject("adodb.recordset"
filepath=server.mappath("database.mdb"
con.open "Driver = Microsoft Access Driver(*.mdb);dbq="&filepath
regards
meenu