Unable to connect to Oracle DB from a Windows box, getting Oracle driver error while executing a perlscript.
Problem : Unable to connect to Oracle DB from a Windows box, getting Oracle driver error while executing a perlscript.
Resolution:
By default windows OS don’t come with Oracle ODBC drivers hence Windows OS couldn’t get an ODBC connection to the Oracle DB. Hence we need to install Oracle client on the Windows box which puts the Oracle ODBC driver and this helps to get a connection established from the Windows Server to the Oracle DB. Picture below shows the Oracle driver on Windows box after Oracle 11g clinet installed.
• You should ensure that you have the correct entries in tnsnames.ora on the Windows box for the Oracle DB.
Thanks & Regards
Avinash Pillai
http://avinashpillai.blogspot.com/
Comments