View Single Post
  #17 (permalink)  
Old May 10th, 2012, 01:29 AM
faiza faiza is offline
Registered User
Points: 15, Level: 1
Points: 15, Level: 1 Points: 15, Level: 1 Points: 15, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default connectionstring problem

sir,
i am using database access .but when i run the browser ,it shows error like this

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Disk or network error.

my page coding

<%@ LANGUAGE="VBSCRIPT" %>
<% option explicit %>
<html>
<bod>

<%

dim objconn
set objconn = server.CreateObject("ADODB.connection")
objconn.connectionstring = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\inetpub\wwwroot\aspnet_client\widg etworld.mdb;Uid=Admin;Pwd=;"


objconn.open
dim objrs
set objrs=server.createobject("adodb.recordset" )
objrs.open "friends",objconn, , , adcmdtable
do while not objrs.eof

response.Write "<b>" & objrs("name") & "</b><br>"
response.Write objrs("streetaddress") & "<br>"
response.write objrs("city") & "," & objrs("state")
response.write "<br>" & objrs("zip") & "<br>"
response.write objrs("phoneno") & "<p><hr><p>"
objrs.movenext
loop
objrs.close
set objrs=nothing
objconn.close
set objconn=nothing
%>
</body>
</html>
plz solve my poblem as soon as possible
Reply With Quote