DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Crashing MS OLE DB Driver for Oracle w/ MDAC 2.8 version

  1. #11
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by gandolf989
    Why don't you either user the native Oracle client or the native Oracle ODBC driver? The first option would be best.
    This is hearsay not evidence: I have been warned NOT to use the MicroSoft Oracle ODBC driver - so I never have. It's claimed to simply not work. So go with Gandolf, use the Oracle version.

  2. #12
    Join Date
    Aug 2004
    Posts
    15

    Source Code

    Below is the code that can recreate the problem (it was just a console app that I created). You will need to create a user in Oracle (just make up a quick user with DBA privileges). Contained within the #if block below is the stored proc you will have to add to the user. The problem will only show itself if a successful attempt to execute the stored proc is made. After the successful procedure execution, you will be prompted to yank the network cable. If you do that, it will most certainly crash. If the stored proc doesn't exist, and can't be executed correctly, it will not show the behaviour.

    One other thing. I am running a Oracle 9.2.0.1 database and MDAC 2.8 (which includes the MS OLE DB Driver for Oracle)
    ***************************************
    For some reason, I can't post the code here without it getting mangled. You can download the project from here though in a zip file.

    http://mywebpages.comcast.net/rwmart...rashSample.zip
    Last edited by Dr_Cogent; 08-16-2004 at 04:43 PM.
    Nothing worthwhile is ever easy.

  3. #13
    Join Date
    Aug 2004
    Posts
    15
    So I guess this thread is dead eh?

    Nothing worthwhile is ever easy.

  4. #14
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Originally posted by Dr_Cogent
    So I guess this thread is dead eh?

    I think that the thread is dead. You want to code for a condition that should not happen. You can try a different odbc driver, or you can try native drivers, if that is an option. The only other thing that you could try would be to test the connection to make sure that it is still active, everytime you try and access the database. But that seems excessive. Should Microsoft fix this bug? Yes. Will they, maybe.

  5. #15
    Join Date
    Aug 2004
    Posts
    15
    Originally posted by gandolf989
    I think that the thread is dead. You want to code for a condition that should not happen. You can try a different odbc driver, or you can try native drivers, if that is an option. The only other thing that you could try would be to test the connection to make sure that it is still active, everytime you try and access the database. But that seems excessive. Should Microsoft fix this bug? Yes. Will they, maybe.
    I have to code for this condition because it very well could happen. Sometimes apps lose their connection to the server and I have to be able to recover from that.
    Nothing worthwhile is ever easy.

Posting Permissions

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


Click Here to Expand Forum to Full Width