HELP!! Getting ORA-01019 error when connecting to oracle


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 7 of 7

Thread: HELP!! Getting ORA-01019 error when connecting to oracle

  1. #1
    Join Date
    Jan 2004
    Posts
    96

    HELP!! Getting ORA-01019 error when connecting to oracle

    I receive the error ORA-01019 when trying to make a connection to oracle through VB. I can work fine with Oracle outside of VB, so VB must be the problem. I have uninstalled VB and reinstalled, I have installed different drivers and also followed oracle help by deleting the oracle client from my machine and reinstalling making sure I erase everything from the registry and nothing works. has anyone else run into this problem? if so...HELP!!!

  2. #2
    Join Date
    Jan 2004
    Location
    Alexandria, VA
    Posts
    145

    Post

    This is what the Oracle documentation recommends for this type of error. Hope it helps.

    "ORA-01019 unable to allocate memory in the user side

    Cause: The user side memory allocator returned an error.

    Action: Increase the size of the process heap or switch to the old set of calls."

    [Oracle7 Server Messages]

    What are you using to connect to Oracle? OCI, ODBC, OLE, Oracle Objects for OLE, ADO, DAO, RDO, etc?

  3. #3
    Join Date
    Jan 2004
    Location
    Alexandria, VA
    Posts
    145
    Also, before you conclude that VB is the problem and continue re-isntalling, have you tried to create DB connections otherwise and outside Oracle products which may use OCI, TNS or other mechanisms for connecting?

    For example, try to create an ODBC data source from Control Panel connecting to the database. You can use the Oracle ODBC divers from MS or Oracle. Then try connecting from some other tool like MS Access, MS Query, or Excel. This way, you test ODBC itself and the ability to connect using it. I believe in the process of creating a DSN you also test it when you retrieve table descriptions. This is all assuming you are using ODBC.

  4. #4
    Join Date
    Dec 2003
    Posts
    2,750
    What version of the Oracle client are you using?
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  5. #5
    Join Date
    Jan 2004
    Posts
    96
    We are using Oracle 9i. Everything outside of VB connects to oracle fine, we have tried reallocating memory, upgrading memory you name it. The problem only occurs when trying to connect to oracle through VB. We have uninstalled and reinstalled VB 2 or 3 times. Still nothing works. Any help or ideas would be of great value.

    Thanks.

  6. #6
    Join Date
    Dec 2003
    Posts
    2,750
    Could you post your connection string code?
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  7. #7
    Join Date
    Jan 2004
    Posts
    96
    thanks for everyone's help, we missed a couple of drivers in the oracle install. once we installed them the connection string worked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center