Support Oracle databeses

[expired user #8613]'s profile image [expired user #8613] posted 9 years ago in General Permalink
This program seems a beauty, but also i have the need to control an Oracle database. This planning on supporting databases Oracle?

Thanks.
ansgar's profile image ansgar posted 9 years ago Permalink
I had planned Oracle in the past. But to be honest, I think HeidiSQL cannot compete with commercial Oracle clients, could it?
[expired user #8613]'s profile image [expired user #8613] posted 9 years ago Permalink
Are you crazy. Pardon the expression, but I think HeidiSQL now is better than many Commercial options.

The only outstanding of the commercial and more popular GUI for Oracle is that you can see at once their relationship to another table and navigate directly to that another table by placing the mouse cursor over the name of that table as it is shown as a link.

I think if HeidiSQL supports Oracle, would be one of the best free options.

Hopefully it will be free forever since it is becoming in favorite databases administrator among developers.

I mention this in a tutorial I wrote for Dolibarr in OpenShift, in which I emphasize the SSH connection HeidiSQL.

http://wiki.dolibarr.org/index.php/Cloud_with_Redhat_OpenShift_Flex

Thanks...
ansgar's profile image ansgar posted 9 years ago Permalink
Thanks for your words. I appreciate that.

Is there some C API .dll supporting Oracle on Windows, similar to libmysql.dll for MySQL?
ansgar's profile image ansgar posted 9 years ago Permalink
As I just read here, that would need these files from Oracle's instand client:
* oci.dll
* oraocci11.dll
* oraociei11.dll
* orasql11.dll
All in x86 and x64 versions. But that documentation is for Delphi's internal database wrapper, which I am not going to use in HeidiSQL. I would have to implement my own wrapper, like I did for MySQL, MSSQL and PostgreSQL. I will definitely need some documentation for that oci.dll .
[expired user #5818]'s profile image [expired user #5818] posted 9 years ago Permalink
Hi, I'd just like to second this thread. I've used a myriad of different MySQL management programs over the years, including several paid ones like SQLYog. But once I discovered HeidiSQL, I've never looked back. It is the best I've found and it's free-ninety-free, which is my favorite price.

Lately I've had the pleasure (sarcasm) of using Toad and SQLDeveloper to manage Oracle databases stuff. The only thing I think while I'm using them is how much I miss HeidiSQL. I check back here regularly to see if there's support for Oracle in the hopes that there will be one day.

I mean this as a sincere compliment; You have done such a great job on HeidiSQL. I do hope to see one day, that support for Oracle databases happens.

-Rick
[expired user #9153]'s profile image [expired user #9153] posted 9 years ago Permalink
Hi ansgar, I found some documentation from oracle help center, maybe it can help you.

Call Interface Programmer's Guide - Appendix D

Regards

As I just read here, that would need these files from Oracle's instand client:
* oci.dll
* oraocci11.dll
* oraociei11.dll
* orasql11.dll
All in x86 and x64 versions. But that documentation is for Delphi's internal database wrapper, which I am not going to use in HeidiSQL. I would have to implement my own wrapper, like I did for MySQL, MSSQL and PostgreSQL. I will definitely need some documentation for that oci.dll .

[expired user #10246]'s profile image [expired user #10246] posted 7 years ago Permalink

Is Oracle support still in consideration or just in progress or dropped?

LuisitoCard's profile image LuisitoCard posted 2 years ago Permalink

Quiero hacerles uan consulta, como puedo conectar ORACLE en heidiSQL

Please login to leave a reply, or register at first.