FiveTech Software tech support forums

... more powerful than ADO and (1) can do more than what is possible with even ADO (2) lot more easier to write code and (3) no need to install mysql ODBC connectors on each client.

... web. Easier to handle - for small databases DBF is faster. More flexible (DBU vs myPHPAdmin ). No need for SQL server - also if it is free. Maybe ODBC or winsock is an option. Do you know if I can upload a dbf file with http in silent mode. FTP would be enough for my purpose. But FTP needs to ...

... Nuevo: DATA nBarHeight --> Permite modificar la altura de de las carpetas en la clase TTabs. * Mejora: Se ha añadido soporte al nuevo conector ODBC versión 8.0 de MySql en la función FW_OpenAdoConnection(...). * Nuevo: Soporte nativo para mostrar e imprimir códigos de barras sin usar librerías ...

... GetLastError() is used. * New: DATA nBarHeight --> allow modify height of folders CLASS TTabs * Enhancement: Added support for the new MySql ODBC Connector version 8.0 in function FW_OpenAdoConnection(...) * New: NATIVE SUPPORT FOR DISPLAY AND PRINTING OF BARCODES, without 3rd party libs ...

Yes.
First, you need to install either ODBC connector or preferably OLEDB provider for PostgreSQL.

Then
oCn := FW_OpenAdoConnection( cConnectionString, .t. )

Please refer to the documentation of www.connectionstrings.com to determine the correct connection string to be used.

Good morning Philippe !!!

Perhaps with TRY / CATCH / END

Best regards

Hi, I use ODBC to communicate with a filemaker database . When i sent a wrong SQL instruction (oDbc:Query() , fivewin give an error dialog box . If i hit enter, the program continue . In place of the dialog box, i 'd like to write ...

... al file e dovresti avere il db. a questo punto da management studio puoi fare le query. Dopo questo puoi collegarti al database da harbour usando odbc.

Boa tarde meu amigo, HDO daqui umas semanas terá suporte a ODBC e voce podera conectar a qualquer banco de dados. HDO é uma lib fantastica com suporte nativo a MySQL e SQLite que agora tera uma opcao de usar ODBC tambem com o mesmo codigo. Se for algo ...

For working with ADO, you need to download and install MySql ODBC connector. That is the reason for the error you are getting. Because you are using FWH 18.01, it is a lot easier to connect to and work with MySql tables using the inbuilt functionality ...

... incluira la funcionalidad para modificar y eliminación registros // Requiere eagle1.lib , tambien se puede utilizar Otro gestor de base de datos u Odbc */ #include "FiveWin.ch" STATIC oServer,oDb,bSqlDate,cTypeBD FUNCTION MAIN() LOCAL cIp :="localhost" LOCAL cLogin:="root" ...

Silvio,

This file can be downloaded from the xHarbour homepage.

xhb10242_src.zip

included :

cgi
codepage
common
compiler
ct
debug
lang
macro
odbc
pp
rdd
rtl
tip
vm

regards
Uwe

Jose, i'm using latest FWH release: 1805. And i need native support for SQL SERVER, not for "MySQL". I access to my database SQL via ODBC regularly, but today the best way is to access via ADO. But how? I need just an example of native connection to SQL SERVER database, avoiding to ...

I'd like to know more about FiveODBC classes. Opening the file help file of FiveWin Classes i find the class TdbOdbc, TOdbc, ecc. but the manual suggest "Please consult FiveODBC Documentation". Where i can find it? I search online ...

Armando, muchas gracias por tu respuesta, si me puedes mandar un ejemplo de como lo haces con ODBC te lo agradecería mucho.