Skip to main content

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/
Labels:

Comments

Post a Comment

Popular posts from this blog

Ephone Hunt Groups and Voice Hunt Groups Comparison

SIP phones support Voice Hunt Groups. SCCP phones support Ephone Hunt Groups, and in Cisco Unified CME 4.3 and later versions, SCCP phones also support Voice Hunt Groups.  Table 69  compares the features of Ephone Hunt Groups and Voice Hunt Groups. Table 69 Feature Comparison of Ephone Hunt Groups and Voice Hunt Groups Feature Ephone Hunt Voice Hunt Group Endpoints Supported SCCP only SIP, SCCP, PSTN, and FXS Parallel Hunt Groups (Call Blast) No (for alternative, see the  "Shared-Line Overlays" section ) Yes Hunt Statistics Support Yes No B-ACD Support Yes No Features such as present-call and login/logout Yes No Thanks & Regards Avinash Pillai URL :  http://avinashpillai.blogspot.com Email: avinashp25[AT]gmail[DOT]com
Post a Comment
Read more

Seven Personal Qualities Found In A Good Leader

Whether in fact a person is born a leader or develops skills and abilities to become a leader is open for debate. There are some clear characteristics that are found in good leaders. These qualities can be developed or may be naturally part of their personality. Let us explore them further. Seven Personal Qualities Found In A Good Leader: 1. A good leader has an exemplary character. It is of utmost importance that a leader is trustworthy to lead others. A leader needs to be trusted and be known to live their life with honestly and integrity. A good leader “walks the talk” and in doing so earns the right to have responsibility for others. True authority is born from respect for the good character and trustworthiness of the person who leads.   2.A good leader is enthusiastic about their work or cause and also about their role as leader. People will respond more openly to a person of passion and dedication. Leaders need to be able to be a source of inspiration, and b...
1 comment
Read more

Data Recovery Software- FREE

                                                                                      I have formatted my USB external storage which i was using my backup. I had 5 years of data, my kids and Family p ictures, pay statements, Visa documents and so on. I have spent several days to find a real FREE data recovery software  that i can use to recover my data from the formatted drive and at last i found one which is completely FREE and can recover data from a formatted drive, in my case my drive was a 500GB Seagate's external USB drive   All other software's are said to be FREE but once we scan the drive and it detects all formatted data it will ask you to buy their software for a complete restore. An average data recovery software wi...
Post a Comment
Read more