HomeFlySpeed SQL QueryHow to connect to oracle database?

How to connect to oracle database?


Can I use JDBC connection data to connect to oracle?

OR: How is the dialog for oracle to be filled?
Ulli | email
October 15 2007, 06:34 AM
Dear Ulli,

Try to use the following connection strings to get connected to your Oracle database:

1) Through the Oracle OLE DB Provider:

Provider=OraOLEDB.Oracle.1;Password=1;Persist Security Info=True;User ID=HR;Data Source=XE

2) Or through the MS OLE DB Provider for Oracle:

Provider=MSDAORA.1;Password=1;User ID=HR;Data Source=XE;Persist Security Info=True

"XE" is the Server name that should be set with your Oracle client software; "HR" is the user name; "1" is the password for the user "HR".

Sincerely
Sergey Smagin
Sergey Smagin | email
1 hour, 24 mins since original post
Thanks for the answer, but:

What is then the Parameter "Connection Type = Oracle" for?

If you choose this, you only will be ask for a database server and not for a connection string.

I already made a connection possible through ODBC, but I donīt want to use ODBC, because itīs not always everywhere available.

Regards
Ulli
Ulli | email
1 hour, 36 mins since original post
Dear Ulli,

I believe that the problem is not with understanding of the Oracle connection form, but with connecting to Oracle using this form, right?

The current version of FlySpeed SQL Query Tool uses OLE DB Provider for Oracle, and this might be a problem. We are planning to implement native access to Oracle database (no ODBC, OLE DB, etc) in the next version of the tool.

Sincerely
Sergey
Sergey Smagin | email
3 days, 20 hours since original post
Sergey,
thanks, thatīs it. The oracle entry is imaginating that there is already the native oracle driver built in.
Iīm looking forward to the next version.

PS: I like flyspeed SQL very much and please follow on with your great ideas.

Regards
Ulli
Ulli | email
3 days, 21 hours since original post
Can Flyspeed access a database remotely? It seems to work fine as long as I install it on the same computer as the database - but I'm having trouble getting it to work remotely. How do I identify the IP/port that the database resides on?

Thanks,
Mo
Mo | email
4 days, 21 hours since original post
FlySpeed DB Migrate uses ports specified by default by database server developers. If your database server has some other settings, you should ask your database administrator about them. Another possible reason of such problems is the firewall activity. Please check that you have opened all necessary ports on your database server PC and your client PC's firewall allows FlySpeed SQL Query tool to get access to network resources.

Sincerely
Sergey Smagin
Sergey Smagin | email
6 days, 19 hours since original post
Sergey,

Thanks for the quick reply. My database has an IP of ip_address. It uses port 1521. And the database instance is called orcl.

What do I need to put in the "server" text box?

I tried ip_address:1521/orcl, but that didn't work.

I'm my admin, and there are no firewalls. I'm trying to figure out how to use tool on a database of a specific ip. I can get it to work fine on the database computer itself.

Thanks for your help.

-Mo.
Mo | email
6 days, 20 hours since original post
Hi,

As far as we use ADO to connect to Oracle, you should setup your oracle client. When setting up a connection on the user's PC, you specify an name (alias) of this connection, and this will be the name you should enter to the "Server" text box.

Hope it helps.

Sergey
Sergey Smagin | email
1 week since original post
This topic is closed