Any means to stop using SQLLIB!?

Any means to stop using SQLLIB!?

Postby JC » Sat May 17, 2008 5:48 pm

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
JC
 
Posts: 445
Joined: Thu Feb 21, 2008 11:58 am
Location: Brazil

Postby Rick Lipkin » Sat May 17, 2008 6:08 pm

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
Rick Lipkin
 
Posts: 2665
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

Postby Adolfo » Sun May 18, 2008 12:13 am

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
----------
Asus TUF F15, 32GB Ram, 2 * 1 TB NVME M.2, GTX 1650
User avatar
Adolfo
 
Posts: 860
Joined: Tue Oct 11, 2005 11:57 am
Location: Chile


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 98 guests