Oracle ODBC

[nguyenchiduc]

Today, I query a statement on Oralce, find information on 800 customers of the company's data.

Initially I used HMG, the result is very slow. At first I thought maybe by ODBC. Then I use SQL Navigator (Professional software to query the Oracle), but the results are similar, it is a bit faster. Tried several times to the same result.

I think used HMG to query on Oracle is not bad when compared to other specialized software to query Oracle

[mol]

Hi guys!
I want to refresh this topic.
Has anybody working sample, how to connect to ORACLE database?

[serge_girard]

Marek, I cannot help because I have no Oracle !

Serge

[dragancesu]

I tried several times without success, I wrote here, nothing
Somebody say that the problem with the 64-bit odbc (I did not try it)
HMG works perfectly in combination with MySQL
See http://www.otc.pl may help

This would be the best
http://vrogier.github.io/ocilib/
but how?

[mol]

I need to report some data from existing ORACLE database. I wrote some years ago application working with MSSQL Server via odbc, it works perfectly, but I don't know how to connect to ORACLE.

[serge_girard]

Hi Marek,

I found this somewhere in an example:

Code: Select all

do case
      case Lower( Right( cDataBase, 4 ) ) == ".mdb"
           if ! File( cDataBase )
              oCatalog:Create( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + cDataBase )
           endif
           oConnection:Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + cDataBase )

      case Upper( cDbEngine ) == "MYSQL"
           oConnection:Open( "DRIVER={MySQL ODBC 3.51 Driver};" + ;
                             "server=" + cServer + ;
                             ";database=" + cDataBase + ;
                             ";uid=" + cUserName + ;
                             ";pwd=" + cPassword )

   endcase
   

Maybe this will you on the way.

Serge

[dragancesu]

If you wand make ad-hoc report from oracle database (or other) try https://community.jaspersoft.com/projec ... t-designer

Some thing work from harbour and don't work from hmg, like connect to oracle, with OCI or ODBC, I was try many times, several versions - some error, no compilation can be made

[luisvasquezcl]

Dear,
in the sources of adordd comes connection to oracle.
I have not used it but at least gives them the idea to do the connection and manipulation of data.
Adordd.prg is in the sources of Minigui extend.
I hope this helps you.
Best regards,
Luis Vasquez

Estimados,
en los fuentes de adordd viene conexion a oracle.
no la he usado pero por lo menos les da la idea para hacer la conexión y manipulación de datos.
Adordd.prg está en los fuentes de Minigui extend.
Espero les sea de ayuda.
Saludos cordiales,
Luis Vasquez

[mol]

Jasper is too slow.
I'll search ans try Louis solution.
Thanks guys!

[dragancesu]

http://oracledba.help/index.php/QuickStarts/Hmg