
September 5th, 2000, 11:22 AM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,578
  
Time spent in forums: < 1 sec
Reputation Power: 22
|
|
|
ASP Error for Provider?
<i><b>Originally posted by : CJ Langbecker (cjldesigns@hotmail.com)</b></i><br />I keep getting this error:<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified <br /><br />Any Help Anyone? <br />The code for this part is:<br /><br /><% strConn="Driver=Microsoft Access Driver(*.mdb); Provider=Microsoft.Jet.OLEDB.3.51; Data Source=C:Inetpubwwwrootcustomer.mdb" %><br /><% <br />Dim objConn<br />Dim objRec<br />Set objConn=Server.CreateObject ("ADODB.Connection")<br />Set objRec=Server.CreateObject ("ADODB.Recordset")<br />objConn.Open strConn<br />objRec.Open "customer", objConn, adOpenForwardOnly, adLockReadOnly,adCmdTable<br />While Not objRec.EOF<br /> Response.Write objRec("FirstName") & " " & objRec("LastName") & "<br>"<br /> objRec.MoveNext<br />Wend<br />objRec.Close<br />objConn.Close<br />%><br /><br /><br /><br /><br />
|