FiveDBU with ADO support

[lucasdebeltran]

Antonio,

Can you please show us how to work with MySQL?.

Thanks.

[Marc Vanzegbroeck]

Antonio,

Can you please show us how to work with MySQL?.

Thanks.

Lucas,

Here is an example for MySQL

[lucasdebeltran]

Hello,

And why not use

cStr := "Driver={MySQL ODBC 3.51 Driver};Server=dolphintest.sitasoft.net;" + ;
"Database=dolphin_man;User=test_dolphin;Password=123456;Option=3;"

oDL := FW_OpenAdoConnection( cStr )

?

Thanks.

[lucasdebeltran]

When adding a record to MySQL, I get:

Error description: (DOS Error -2147352567) WINOLE/1007 El valor de BOF o EOF es True, o el actual registro se eliminó; la operación solicitada requiere un registro actual. (0x800A0BCD): ADODB.Recordset

Stack Calls
===========
Called from: => TOLEAUTO:MOVELAST( 0 )
Called from: fivedbu.prg => RSAPPENDBLANK( 533 )
Called from: fivedbu.prg => (b)ADOOPEN( 424 )
Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:CLICK( 466 )
Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:LBUTTONUP( 657 )
Called from: .\source\classes\CONTROL.PRG => TCONTROL:HANDLEEVENT( 1719 )
Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:HANDLEEVENT( 1409 )
Called from: .\source\classes\WINDOW.PRG => _FWH( 3182 )
Called from: => WINRUN( 0 )
Called from: .\source\classes\WINDOW.PRG => TMDIFRAME:ACTIVATE( 995 )
Called from: fivedbu.prg => MAIN( 65 )



RSAPPENDBLANK( 533 )

Code: Select all  Expand view

  oRS:MoveLast()
 

The table is empty.

[Marc Vanzegbroeck]

Hello,

And why not use

cStr := "Driver={MySQL ODBC 3.51 Driver};Server=dolphintest.sitasoft.net;" + ;
"Database=dolphin_man;User=test_dolphin;Password=123456;Option=3;"

oDL := FW_OpenAdoConnection( cStr )

?

Thanks.

That was used in the previous version. I like that one also more, but Antonio changed it like this (whitch is also nice)
Maybe it would be better to have the 2 options to connect to ADO.
Like this or with a connection-string

[Antonio Linares]

Lucas,

We could use both ways. Creating an ODBC datasource from Windows and using it from FiveDBU seems a good way to avoid errors, but if you know the connection string for sure, then it is simpler than going the other way.

[Antonio Linares]

Fixed bug when editing logical values:

https://code.google.com/p/fivewin-contributions/downloads/detail?name=fivedbu_20130513.zip