Can OCI LIB C Driver for Oracle include in HMG ?

[shridhar]

I found the OCI driver for Oracle written in ANSI C. It is extramly stable and easy to use. Currently this is being used by large banks and commercial institutions.

Roberto (Master).. Could you please include this Dirver into our HMG ?

http://orclib.sourceforge.net/

[luisvasquezcl]

Hi ,
you can connect with oracle across ado.
This is the connection string:
Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
this link you can find an example with ADO connection to database ... just change the connection string
Regards,
Luis Vasquez.

[shridhar]

Hi Luis Vasquez.

Thanks..! I had tried but I found some bugs in ADO RDD one of the bug that I had that data type interpretation problem. The TYPE() function of harbour is not properly identify data type of the table column defined in MS Access. See our HMG examples in ADORDD folder. Create a table with date column in MS Access and browse the same table with all columns in HMG program, you will get an error. I believe that we can not rely on ADORDD it needs to more testing. As ADO interaction with ODBC layer and ODBC layer interaction with Oracle's OCI layer so ADO is too slow than Direct calling OCI's functions and OCI LIB is portable to any OS is the main advantge.

Regards
Shridhar

[luisvasquezcl]

Hi Shridhar
AdoRdd you may have problems but it was not exactly my proposicion.
The example indicates that use ADO directly and not through adordd.
good luck.
Luis Vasquez

[shridhar]

Hi Luis Vasquez,

Thanks ..! Could you please post here some examples of ADO ?

Regards
Shridhar

[luisvasquezcl]

Hi,
you can see this link viewtopic.php?f=9&t=449.
If you have any questions attached to this manual might be useful.
Regards,
Luis Vasquez.

[shridhar]

Hi Luis Vasquez,

Thanks a lot ..! I will test it and let you know if any problem will occur.

Regards
Shridhar