Siddharth_1
EXTREME
I am having some problem with the ASP code that i am using to connect with access DB
Here is the code:
The error i am getting is this:
Line 8 is ' objConn.Open strConn '.
PLS HELP!!
Here is the code:
Code:<html> <head> <link href="theme/iframe_style.css" rel="stylesheet" type="text/css" /> <% Dim objConn, strConn, objRS Set objConn = Server.CreateObject("ADODB.Connection") strConn = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source= db\softwares.accdb" objConn.Open strConn Set objRS = Server.CreateObject("ADODB.RecordSet") objRS.Open "softwares",objConn %> </head> <body> <table border=0> <% While NOT objRS.EOF %> <tr> <td><%=objRS("softname")%></td> <td></td> </tr> <% objRS.MoveNext Wend objRS.Close objConn.Close Set objConn=Nothing Set objRS=Nothing %> </table> </body> </html>
The error i am getting is this:
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/files/dbconnecttest.asp, line 8
Line 8 is ' objConn.Open strConn '.
PLS HELP!!