| Error while trying to retrieve text for error ORA-01019 [message #302770] |
Wed, 27 February 2008 00:18  |
AndrewG1976 Messages: 7 Registered: June 2005 |
Junior Member |
|
|
I am getting the following error when trying to connect (using ODBCTest) to an Oracle 10g (Release 10.2.0.2.0) database using the Microsoft ODBC Driver for Oracle on a Windows 2000 Server machine:
[Microsoft][ODBC driver for Oracle][Oracle]Error while trying to retrieve text for error ORA-01019'
I have installed the Oracle XE Client Release 10.2.0.1.0 and have created the SQL*Net connection to the database and can connect it it through SQL*Plus.
The ODBC driver details are:
Name: Microsoft ODBC driver for Oracle
Version: 2.575.1064.00
Date: 12/12/2006
The description of the Oracle error is:
ORA-01019: unable to allocate memory in the user side
Cause: The user side memory allocator returned error.
Action: Increase the processes heap size or switch to the old set of calls
How do I "increase the processes heap size" or "switch to the old set of calls"?
Thanks
[Updated on: Wed, 27 February 2008 00:22]
|
|
|
| Re: Error while trying to retrieve text for error ORA-01019 [message #302818 is a reply to message #302770 ] |
Wed, 27 February 2008 01:44   |
Michel Cadot Messages: 17653 Registered: March 2007 Location: Nanterre, France, http://... |
Senior Member |
|
|
I advice you to use Oracle driver.
Regards
Michel
|
|
|
| Re: Error while trying to retrieve text for error ORA-01019 [message #303060 is a reply to message #302818 ] |
Wed, 27 February 2008 19:15  |
AndrewG1976 Messages: 7 Registered: June 2005 |
Junior Member |
|
|
|
The Oracle XE Driver gave me the error "Cannot load resource file sqresus.dll", so I removed the Oracle XE Client and installed the normal Oracle 10.2.0.1 client and it works now.
[Updated on: Wed, 27 February 2008 19:16]
|
|
|