Any means to stop using SQLLIB!?

Post Reply
User avatar
JC
Posts: 445
Joined: Thu Feb 21, 2008 11:58 am
Location: Brazil
Contact:

Any means to stop using SQLLIB!?

Post 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!
Peace and lighting!

Júlio César M. Ferreira

FWH 8.10 / xHB 1.1.0 / xDevStudio 0.72 / Pelles C 5.0.1 / SQLLIB 1.9
User avatar
Rick Lipkin
Posts: 2397
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

Post 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
User avatar
Adolfo
Posts: 815
Joined: Tue Oct 11, 2005 11:57 am
Location: Chile
Contact:

Post 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
;-) Ji,ji,ji... buena la cosa... "all you need is code"

http://www.xdata.cl - Desarrollo Inteligente
----------
Lenovo Legion Y520, 16GB Ram, 1 TB NVME M.2, 1 TB SSD, GTX 1050
Post Reply