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 :)

Thursday, May 14, 2015

Forms And Reports 6i Crash When Connection with 11g XE Database !!!

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 try to connect Oracle form & Reports 6i with Oracle Database 11g XE (Express Edition), every time, it will crash and you will not able to connect. 

But it will not happen with 11gR2 Enterprise or any other Edition.

>>?? Why this happen ?

Because, Database 11g XE use,

SQL> select * from v$nls_parameters where parameter like '%CHARACTERSET%';

PARAMETER                                                        VALUE                                                                                                                                                                                                                                                                                                                                                                                                                                             
---------------------------------------------------------------- ----------------------------------------------------------------                                                                                                                                                                                                                                                                                                                                                                                  
NLS_CHARACTERSET                                                 AL32UTF8                                                                                                                                                                                                                                                                                                                                                                                                                                          
NLS_NCHAR_CHARACTERSET                                           AL16UTF16                                                                                                                                                                                                                                                                                                                                                                                                                                         
 

you  need to set the database character set as UTF8.

To do so you need to follow the bellow steps..

1. connect as sysdba using SYSTEM not SYS.

Run the following command sequencially.

SQL>CONN SYSTEM/MANAGER AS SYSDBA

2. Shutdown the database if running:
SQL>SHUTDOWN IMMEDIATE

3. Start the database in restrict mode:
SQL>STARTUP RESTRICT

4. Change the databse charcter set to UTF8 as follows:
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;

5. Shutdown the database:
SQL>SHUTDOWN IMMEDIATE

6. At last, start the database in normal mode:
SQL>STARTUP

After successfull of these steps, you can connect to the Oracle XE database through Forms 6i or Oracle Reports 6i


 Comments to share your thoughts..


End for the day....


Praise to Almighty Allah(swt).  :)


Fi amanillah