Page 1 of 1

Any means to stop using SQLLIB!?

Posted: Sat May 17, 2008 5:48 pm
by JC
Hi Linares and friends!


Currently we work with the lib SQLLIB to carry out the "conversation" with the MySQL database and PostgreSQL database too.

Is there any way, native, to do the same process?

It would be basically a command or class which has the property to do the following: Run any ANSI SQL statement in the database server, return errors and realize backups.


I have updated my fivewin to version 8.05, but I am depending on the update of SQLLIB to use it. This is not good enough.

There is any way? Please!
Thanks to everybody for all!

Posted: Sat May 17, 2008 6:08 pm
by Rick Lipkin
JC

I know of no better solution then Win32ole .. better known as ADO .. lots of samples on the native xHarbour class .. just do a search in this forum for ADO ..

I think you will find what you are looking for.

Rick Lipkin
SC Dept of Health, USA

Posted: Sun May 18, 2008 12:13 am
by Adolfo
JC..

As Rick says... there's A SOLUTION... ADO...

I've done some tests with the same code but different connection strings to access MYSQL, Postgress, MS Sql, Oracle (XE Version ) with no problems at all.

You can use it by pure code, you can use ADORDD, you can use my class ADOBASE ( although is a work in progress ) or you can create your own solution.

Theres lot of info on ADO in the web, you can contact me if you can't find them.

A new and more complete version of my class will be posted this monday.
You can look the earlier version here...
http://200.72.140.34/privado
adobase.rar

From Chile
Adolfo