Hire me on UpWork

Friday, May 15, 2015

Microsoft ODBC error when connecting with Oracle Database 11gR2

As salamualikum (islamic greetings), brothers and sisters. :)

 Hope you are fine.. 

Not very useful for everybody but it's a solution if you need.

If you connection with Access with Microsoft ODBC  communication with HS file configuration (may look at How to Connect Oracle Database with Microsoft Access Database? )

using oracle Database 11g or above, you must specify Operation System (OS) User Name and Password.

Otherwise you will get error like.
Exiting hgolgon, rc=28513 at 2015/05/13-18:40:37 with error ptr FILE:hgolgon.c LINE:739 ID:Memory allocate

 So, simple solution is appropriate configuration.


Example:

CREATE PUBLIC DATABASE LINK “TESTDB”    
CONNECT TO "Administrator"      --- OS user name
IDENTIFIED BY "admin123"           --- OS password
USING 'TESTDB';

 Hope this works.. Hamid :)

No comments:

Post a Comment