Hello, I'm struggling a bit at square 1 and I'm a newbie so I'm probably doing something silly.
I have database running on my local PC via Oracle XE (a slimmed down Oracle product for running a local DB server). I can access my database fine via SQL Developer but can't get past the connection page in PHPRunner starting a new project.
In PHPRunner, I select Oracle from list of DBS and on the "Connect to Oracle" page I feed in:
Host/Service: localhost
Username: BDR
Password: proper password for BDR user
Click connect button and I get error:
Error connecting to Oracle database. Error - ORA - 12514: TNS:listener does not currently know of service requested in connect descriptor
I am able to connect fine via what SQL Developer calls "basic" connection type (hostname:localhost, Port:1521, SID:XE) as well as selecting the the TNS entry called "BDR" listed below:
BDR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
I've tried changing the HOST to both localhost and my machine name and both work fine in SQL Developer. I've also tried feeding in various other things into the PHPRunner connection string boxes such as my machine name instead of localhost.
Does anyone have an idea of something to try to get me past this?
