Accessing Oracle 10g Express with the SqlDbx IDE
936058May 9 2012 — edited May 9 2012Hi, I downloaded Oracle Express a few weeks back.
I finally got round to doing something with it.
I also installed a free IDE called SqlDbx that I was recommended.
When I start up SqlDbx it prmpts me for DBMS Type - I select Oracle Server from a drop down.
Then for the Server I select XE.
There are then 3 boxes for Schema, User, Password.
I dont remember setting anything up when I installed Oracle XE so leave these blank.
I then click OK to connect but get an error logon denied.
Do you know what the default schema, user and password is when you install XE or do you need to do something else to setup them up, if so what?
Is there a better way/tool(free) I could use instead of SqlDbx to connect to the database server?
I checked the service was running in the Windows task manager and it is so that proably isnt the problem.
thanks.