SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Wizard PHPycho's Avatar
    Join Date
    Dec 2005
    Posts
    1,201
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Remote Oracle Connection using PHP (Windows)

    Hi,
    I want to connect Oracle Db using oci_* functions.
    I tried to enable the Oracle extension by uncommenting: extension=php_oci8.dll line from php.ini
    and restarting Apache server. But that didn't work.
    Looking at Apache Server Log file 'error.log' gave me the following errors:
    "PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\php\\ext\\php_oci8.dll' - The specified module could not be found.\r\n in Unknown on line 0"
    But php_oci8.dll file is there is the mentioned dir.

    Can anyone guide me where did i go wrong? or
    How to enable Oracle extension in localhost (Windows)?

    Thanks in advance for any help.
    PHPycho - Magento Freelancer
    Free Modules: jQuery LightBoxes | Frontend Links Manager & more...
    Commercial Modules: Custom Login Redirect Pro | Store Restrction Pro & more...

    Follow me on Twitter @ magepsycho

  2. #2
    Hosting Team Leader silver trophybronze trophy
    cpradio's Avatar
    Join Date
    Jun 2002
    Location
    Ohio
    Posts
    5,069
    Mentioned
    152 Post(s)
    Tagged
    0 Thread(s)
    I'd start at http://www.oracle-base.com/articles/...on-windows.php

    If those steps don't do it, let me know and I'll see if I can dig up any more resources.
    Be sure to congratulate Patche on earning July's Member of the Month
    Go ahead and blame me, I still won't lose any sleep over it
    My Blog | My Technical Notes

  3. #3
    SitePoint Wizard PHPycho's Avatar
    Join Date
    Dec 2005
    Posts
    1,201
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by cpradio View Post
    I'd start at http://www.oracle-base.com/articles/...on-windows.php

    If those steps don't do it, let me know and I'll see if I can dig up any more resources.
    Hi cpardio,

    Thanks for your willingness to help but unfortunately that didn't work for me.
    Actually i did the same thing previously. Not sure if we need to install some Oracle client kind of software in windows?

    Thanks
    PHPycho - Magento Freelancer
    Free Modules: jQuery LightBoxes | Frontend Links Manager & more...
    Commercial Modules: Custom Login Redirect Pro | Store Restrction Pro & more...

    Follow me on Twitter @ magepsycho

  4. #4
    Hosting Team Leader silver trophybronze trophy
    cpradio's Avatar
    Join Date
    Jun 2002
    Location
    Ohio
    Posts
    5,069
    Mentioned
    152 Post(s)
    Tagged
    0 Thread(s)
    Assuming your Oracle DB is located on a remote server (or not locally), it seems you need the Instant Client.
    http://www.oracle.com/technetwork/ar...nt-084410.html
    Be sure to congratulate Patche on earning July's Member of the Month
    Go ahead and blame me, I still won't lose any sleep over it
    My Blog | My Technical Notes

  5. #5
    SitePoint Member
    Join Date
    Nov 2012
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    I installed php , apache ,oracle and Instant Client Package in windows 7 as its provided in this link -- http://www.oracle.com/technetwork/ar...nt-084410.html .
    its working fine in localhost .
    m trying to connect to remote database and getting this error ( oci_connect(): ORA-12546: TNS permission denied ) help me .

  6. #6
    . shoooo... silver trophy logic_earth's Avatar
    Join Date
    Oct 2005
    Location
    CA
    Posts
    9,013
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)
    To connect to any database server remotely, it must be configured to allow remote connections.
    Logic without the fatal effects.
    All code snippets are licensed under WTFPL.



Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •