Database error: Object required

Results 1 to 2 of 2

Thread: Database error: Object required

  1. #1
    Join Date
    Dec 1969
    Posts
    5

    Default Database error: Object required

    Hi,<BR>I am working on Windows NT workstation with Ms Peer Web Services.<BR>i installed asp engine. So when i create asp page using Database Region Wizard in Microsoft front page 98 with Ms Access as the database through ODBC.when i preview the asp page on Browser I am getting the error as "Database error: Object required"<BR>So I would really appreciate if any body gives solution for this problem ASAP. My email address is penumathsa@hotmail.com<BR><BR>Thank You

  2. #2
    Jason Buck Guest

    Default RE: Database error: Object required

    Try using this format for your connections. I believe from your error that you are not using all the requirements to connect to your database.<BR><BR>&#060;%<BR>strConnect = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:databasemailer.mdb"<BR><BR>dim objconn, objrec, mysql, strStatus, Mytest, strLength<BR>set objconn = server.createobject("ADODB.Connection")<BR><BR><BR >objConn.open strConnect<BR><BR><BR>mysql = "SELECT FIELDA, FIELDB FROM TABLENAME ;"<BR><BR>set rstemp=objConn.execute(mysql)<BR><BR>If not rstemp.eof then<BR><BR> Do While Not rstemp.EOF<BR>strFieldA = rstemp("FieldA")<BR>strFieldB = rstemp("FieldB")<BR><BR>response.write strFieldA & " " & strFieldB<BR><BR> rstemp.movenext<BR><BR>Loop<BR><BR>End if<BR><BR><BR> rstemp.close<BR> <BR><BR>Set rstemp = nothing<BR>objConn.close<BR>Set objConn = nothing<BR><BR>%&#062;<BR><BR>I hope this helps, if not feel free to contact me.<BR><BR>Respectfully,<BR><BR>Jason <BR>webmaster@wnj.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •