Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421

    Unanswered: More ODBC Nightmares and Migranes

    I have a nice application running for a while now... which does an awfull lot of ODBC calls to an Oracle database... All is fine and well...

    Lets set the scene...

    I am connecting using something like:
    Code:
        Set wrkODBC = CreateWorkspace("myODBC", User, PW, dbUseODBC)
        Set con = wrkODBC.OpenConnection("Connection1", , , _
            "ODBC;DSN=" & DSNT & _
                ";UID=" & UserT & _
                ";PWD=" & PW & _
                ";SERVER=" & Server & _
                ";")
    Then building the query i want to run on the connection
    set qry = con4T.CreateQueryDef("", mySQL)

    Then loading the query into a recordset...
    Set rst = qry.OpenRecordset

    and then handling it ... no problems to mention off

    Anyway, now i would love to store the information for additional use into my db. Opening another recordset and adding the data to the table. Except now after about 30 or so records the ODBC Connection plonks out,
    for no appearent reason, timeout is set to 0, query is 100% OK

    If i restart from the point i left off the application continues, but after another 30 or so it crashes again.... When i kill the saving of the ODBC data it works fine... I have checked, double checked and triple checked.... and am now finaly at a loss...

    Could it be a problem with opening and closing to many recordsets?? I am thinking as i am writing this... anybody know??

    Anybody have any other ideas?

    BR & TIA

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Just trying to recall this to everyones attention, cause i am still experiencing problems...

    Regards

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by namliam
    Just trying to recall this to everyones attention, cause i am still experiencing problems...

    Regards
    I'm not seeing a CursorLocation ... The default is Serverside ... Could that be mucking you up?
    Back to Access ... ADO is not the way to go for speed ...

  4. #4
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Cursor location?

    Call me stupid, but i dont know.... Please explain...

    Regards

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by namliam
    Cursor location?

    Call me stupid, but i dont know.... Please explain...

    Regards
    You could be still having a timeout issue on your recordset because of where the recordset is collating the data at ... Either the Clientside or Serverside ... Example:

    Dim TrgRecSet As ADODB.Recordset

    Set TrgRecSet = New ADODB.Recordset

    TrgRecSet.CursorType = adOpenDynamic
    TrgRecSet.LockType = adLockOptimistic
    TrgRecSet.CursorLocation = adUseClient ' <---------- Here.
    Back to Access ... ADO is not the way to go for speed ...

  6. #6
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    I am using DAO, not appearent from my original post sorry, since i am (or my employer) still stuck in A97...

    Planing/hoping to maybe i think possibly *crossing my fingers* to migrate to ... XP *sigh* possibly this year...

    Regards

Posting Permissions

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