Oracle DB support - Githubissues

HeidiSQL / HeidiSQL

A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird, written in Delphi

https://www.heidisql.com/

GNU General Public License v2.0

4.75k stars 447 forks source link

Oracle DB support #120

Open ipkpjersi opened 6 years ago

ipkpjersi commented 6 years ago

Any plans for Oracle DB support? It would be really nice to see support for Oracle, seeing as Oracle is the most popular DB according to: https://db-engines.com/en/ranking and this is my favorite SQL client.

ipkpjersi commented 6 years ago

@ansgarbecker Can you possibly comment if this is something you would consider doing, if you have plans for it, etc or if it's just not going to happen ever? It would be so cool if this program had Oracle DB support.

ansgarbecker commented 6 years ago

I had plans to add some support, as you can read in the forum. But as you can see, that plan hasn't been worked out :)

To be honest, with PostgreSQL and MSSQL I already have 2 RDBMs with only basic support in HeidiSQL.

ipkpjersi commented 6 years ago

I am glad to hear there are plans for it even if it may take a while. I wish I could help but I just don't know Delphi sadly. Thanks.

CTimmerman commented 5 years ago

https://github.com/dbeaver/dbeaver can use a driver jar from Oracle (e.g. ojdbc6-12.1.0.2.jar which IntelliJ IDEA Ultimate 2019.1 downloads and uses without online registration hassle), which should also be possible in Delphi.

ansgarbecker commented 4 years ago

For those liking experiments:

update to the next build by
create a dword32 registry value called AllProviders in HKEY_CURRENT_USER\Software\HeidiSQL, with a value of "1"
restart HeidiSQL, and create a new MS SQL connection.

This way you can disable the restriction of ADODB providers for MS SQL connections. This may reveal some Oracle driver on your system (not for me though):

grafik