This topic is locked
[SOLVED]

 Can not connect to Oracle using a different port

1/8/2015 2:56:01 PM
PHPRunner General questions
R
rlee6087 author

Greetings, I'm trying to connect to an Oracle db using port number 1522 instead of 1521, the wizard will not allow me to even connect. What file and where is it located can I edit to make this happen? I'm using phprunner 8.0. Thank you.

Sergey Kornilov admin 1/9/2015

You can probably create an ODBC DSN for this connection and connect to your database using this DSN.

R
rlee6087 author 1/28/2015

ODBC is not an option as it is not allowed at this particular client.

Sergey Kornilov admin 1/29/2015

You can specify the following format in Host field:

host:port/instance


More info:

http://docs.oracle.com/cd/B19306_01/network.102/b14212/naming.htm#i498306

R
rlee6087 author 2/11/2015

I have since installed the Oracle client, and all other applications using Oracle as the db work great, now Phprunner just locks up when I select Oracle as the db.

Sergey Kornilov admin 2/11/2015

Make sure that version of PHPRunner (32bit vs 64bit) matches the version of Oracle client. Not sure what else it might be.

R
rlee6087 author 3/11/2015

Thank you for your input, however I have since reinstalled phprunner and Oracle client. All of my Oracle apps work fine, sqldeveloper, net config etc. Everything but phprunner both 6.2 and 8.0. It now says you nee to install the oracle client for this to work. I k now the client is installed and working. Hope that helps.

Sergey Kornilov admin 3/11/2015

Just in case make sure that version of Oracle client matches the version of PHPRunner installed (32bit vs 64bit). Not sure what else we can do without having access to that machine.

R
rlee6087 author 3/16/2015

I completely removed all instances of Oracle and reinstalled the client, and it appears to be working. thank you for your input.