Provider error ' 80004005'

Results 1 to 2 of 2

Thread: Provider error ' 80004005'

  1. #1
    Join Date
    Dec 1969
    Posts
    29

    Default Provider error ' 80004005'

    Im using an acces database:<BR> set rs=Server.CreateObject("adodb.Recordset")<BR> connectme="DSN=Vote"<BR> sqlstmt = "SELECT name from question where qid=(select qid from curquestion)"<BR> rs.open sqlstmt, connectme<BR><BR><BR>it complains on the rs.open line, why?<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    538

    Default RE: Provider error ' 80004005'

    u need to use this to i think =)<BR><BR>Set cn = Server.Createobject("ADODB.Connection")<BR>cn.open connectme<BR><BR>then make rs.open line look like this<BR><BR>rs.open sqlstmt, cn<BR><BR>Should do it (im just a newbie myself so i might be wrong,<BR>but thats what i think)<BR>Happy Programmin<BR>

Posting Permissions

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