Results 1 to 5 of 5

Thread: ADO + open

  1. Feb 14th, 2003, 10:47 AM #1
    vbgladiator
    vbgladiator is offline

    Thread Starter
    Frenzied Member vbgladiator's Avatar
    Join Date
    May 2001
    Posts
    1,950

    ADO + open

    Hi,

    I have an application which runs at 2 sites.
    1 site is perfect.
    On the second one:
    Inside the application I open a previously saved recordset as so:
    rs.open "FileName", Nothing, adLockReadOnly, adOpenStatic

    It works fine sometimes and sometimes gives me error 3709 -
    The connection cannot be used to perform this opeartion. It is either closed or invalid in this context.

    Remember, it works most of the times.

    Any ideas?
    Don't anthropomorphize computers -- they hate it
    Reply With Quote Reply With Quote
  2. Feb 14th, 2003, 10:57 AM #2
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    You say on a previosly saved recordset.

    I think the connection is closed sometimes.

    If it isn't u get no errors else you do.
    Where you have Nothing in the open statement of the rs you should place a opened connection.
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    Reply With Quote Reply With Quote
  3. Feb 14th, 2003, 11:11 AM #3
    vbgladiator
    vbgladiator is offline

    Thread Starter
    Frenzied Member vbgladiator's Avatar
    Join Date
    May 2001
    Posts
    1,950
    You can't open a saved recordset to a file with a valid connection because it then expects a sql statement.
    Don't anthropomorphize computers -- they hate it
    Reply With Quote Reply With Quote
  4. Feb 17th, 2003, 04:26 AM #4
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    What is your goal with this recordset.
    What is it used for ?
    Does it has to be saved to the Db or is it for temporary use ?
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    Reply With Quote Reply With Quote
  6. Feb 17th, 2003, 11:44 AM #5
    vbgladiator
    vbgladiator is offline

    Thread Starter
    Frenzied Member vbgladiator's Avatar
    Join Date
    May 2001
    Posts
    1,950
    The use of this recordset is irrelevant.
    The issue is that I occasionally get a 3709 error on only 1 machine while trying to open it with a Nothing or Blank as a connection.

    Any ideas?
    Don't anthropomorphize computers -- they hate it
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width