I see on the internet some tools for FiveWin with Harbour and am using Sql with some questions, wanted to know what you guys have used for this? 
Matheus,
ADO is a great choice. There are many examples in these forums and also FWH provides great functions to manage it
Function SqlQuery( cSql, lRecordSet,lExecute, lCompact )
&& exemplo -> aresp:=SqlQuery([SELECT CODIPRO FROM PRODUTOS WHERE NOMEPRO LIKE '%B%'])
local uRet := {} // Retorno com Registros
local oRs, nAt , oCn // Objetos de controle para o ODBC e o Registro
Local cArquivo := &(Alias())->( DbInfo( DBI_FULLPATH ) )
Local cDiretorio:= iif ( Empty( cFilePath(cArquivo)) , Curdrive()+':\'+curdir()+'\',cFilePath(cArquivo) )
DEFAULT lCompact := .t.
DEFAULT lRecordSet := .f.
cSql := Upper( alltrim(cSql) )
oCn := FW_OpenAdoConnection( [Provider=Microsoft.Jet.OLEDB.4.0;Data Source=]+cDiretorio+[ ;Extended Properties=dBASE IV;User ID=Admin;Password=] ,.t.)
DEFAULT lExecute := !( LEFT( cSql, 7 ) == 'SELECT ' )
if oCn != nil
if lExecute
TRY
uRet := oCn:Execute( cSql )
CATCH
END
return uRet
else
oRs := FW_OpenRecordSet( oCn, cSql )
if lRecordSet
uRet := oRs
else
if oRs != nil
if oRs:RecordCount() > 0
uRet := oRs:GetRows()
oRs:MoveFirst()
endif
oRs:Close()
if lCompact
if Len( uRet ) == 1
uRet := uRet[ 1 ]
if Len( uRet ) == 1
uRet := uRet[ 1 ]
endif
endif
endif
endif
endif
endif
endif
return uRetMatheus,
If you are going to use MySQL and not other database engine, then you can use Daniel's TDolphin and this way ADO is not required.
Regarding ADO performance with remote database engines, I let other users comment about their experiences. I have just used ADO locally.
Antonio Linares wrote:Regarding ADO performance with remote database engines, I let other users comment about their experiences. I have just used ADO locally.
Antonio Linares wrote:
Regarding ADO performance with remote database engines, I let other users comment about their experiences. I have just used ADO locally.
Friends:
My five cents, as all of you said, I have an App since 2007 with MySql and ADO, and not
problems at all.
I advise you, ADO + MySql + FW, and nothing else
Regards
I used ADO for many years with Oracle, MSSql, MySql (recently) on remote and local. This is the best option.
When we deal with huge tables, we need to change our habits to open full tables like in xBase. We should learn to fall in line with the rest of the world to limit reading only to the required part of the table.
Well folks,
I installed the drive in my machine mysql to use with ado, someone would have some basic examples of connection and processing of such data to provide? 
MFarias wrote:Well folks,
I installed the drive in my machine mysql to use with ado, someone would have some basic examples of connection and processing of such data to provide?
Dear All,
I'm trying to move to SQL via ADO now.
What does it mean "remote database engines" ?
Is it the same as program access via internet IP to database server directly? or
Is the program access database on Web Hosting via IP or URL?
What is the different?
Regards,
dutch wrote:What does it mean "remote database engines" ?
