FiveTech Software tech support forums

I open the first connection (DB2): pgm1.prg Connessione := "Provider=IBMDA400; Data Source=192.168.1.1; User Id=userid; Password=password; Default Collection=Library;"oCn := FW_OpenAdoConnection( Connessione, .t.)  DB2 ...

Hi,
Can I to have two adodb connections at the same time on different databases?

I have two servers and I'd like to open one connection tu DB2 and another to SQL Server.

thank you

Damiano.

hi Rick, thank you. My program has about 100 menu items and about 50 users are in the lan that use my progr .exe each item open connection to DB2 and close connection when exit. main()...MENU oMenu    MENUITEM o_Menu[01][01] PROMPT "Ufficio Acquisti"    MENU  ...

Hi, this run ok in php.............but how I do in fw $resulta1 = mysqli_query($conexion, " SELECT * FROM $tabla_db2 WHERE subcta = $cue "); $consulta1 = mysqli_fetch_array($resulta1); $claveve = $consulta1['clave']; $nombre = $consulta1['subnom']; $cuentaoriginal = $consulta1['cta']; $tip...

Amigos, sigo insistendo porque no me sale. esto funciona en php.............quisiera hacer lo mismo desde fw $resulta1 = mysqli_query($conexion, " SELECT * FROM $tabla_db2 WHERE subcta = $cue "); $consulta1 = mysqli_fetch_array($resulta1); $claveve = $consulta1['clave']; $nombre = $consult...

hi Mr Rao
column date comes from a ado object.
it read a Db2 table from as400.
in the sql select column date is a date field
SELECT code, description, date...

code and description are varchar and date is date field.

thank you.

xmanuel wrote:HDO también funciona en 32 y 64, además funciona con SQLite, Access, MS Server, DB2 etc, etc

Saludos Manu, como estas?

Te he escrito varias veces a tu email pero no hay respuesta

HDO también funciona en 32 y 64, además funciona con SQLite, Access, MS Server, DB2 etc, etc

hi, I'm converting my .prg from FHW(17.09) + xHarbour to FWH 64 for Harbour 19.06 (MSVC++) Jun. 2019 this code (Ado fo DB2 AS400): #include "FiveWin.ch"//----------------------------------------------------------------------------//function main()local oCnLOCAL Connessione ...

db2 progrramers use RPG III language (like me), when we write a record we can write all fields of record or just some fileds. i.e.: Tabld MYTABLE record name MYREK with 3 fields: A CAHR(10)B CHAR(10)C DECIMAL(3, ...

... is not recognising this oRs as a valid recordset. The problem is not in FW_OpenRecordSet() The problem is (1) either in the Oledb Provider for DB2 which is unable to handle this table correctly or (2) The data in this table is corrupted. Next best option now is to read selected fields: SELECT ...

Can you please test
? oRs:State

This is surprising.
I have no experience with DB2, but when tested with mysql,msssql,oracle, etc. we never had any problem with fields containing null values. Anyway we will again test with null values.

Hi, I have this problem. I use a my function to read tables in DB2 database into XBROWSE: cSelect = "Select * from MyTable "  oRs := FW_OpenRecordSet( oConnnection, cSelect, 1 )......@ 40,10 XBROWSE oBrw SIZE -10,-50 PIXEL CELL AUTOSORT ...

Mr. Rao:

I mean with DB2 data base there are problems.

Regards

Hi , I have my exe installed on about 10 pc (Windows 10, Windows seven,...) with this String connection for DB2 connection: local Connessionelocal oCnConnessione := "Provider=IBMDA400; Data Source=192.168.1.200; User Id=THISISID; Password=THISIPSW; Default Collection=LIBRARY;"oCn ...