FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexActive topicsAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour Fivewin and ADO
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM

Re: Fivewin and ADO

Posted: Sat Jun 10, 2023 06:32 PM
on 32 Bit OS i use ADO 32 Bit and BCC7 32 Bit and XBNROWSE "refresh" fine after "edit"
on 64 Bit OS i use ADO 64 Bit and MSVC 64 Bit and XBNROWSE do NOT "refresh" after "edit"
Now a days all Windows OS is 64 bits
Regards



G. N. Rao.

Hyderabad, India
Jimmy
Posts: 1772
Joined: Thu Sep 05, 2019 05:32 AM

Re: Fivewin and ADO

Posted: Sat Jun 10, 2023 08:45 PM
hi,
nageswaragunupudi wrote:Now a days all Windows OS is 64 bits
can you confirm that my Sample does NOT "refresh" XBROWSE, using MSVC 64 Bit under 64 Bit OS, when all Column are Type "C" :?:
greeting,

Jimmy
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM

Re: Fivewin and ADO

Posted: Tue Jun 13, 2023 05:53 AM
the *.XLSx was about 17000 x 11
My sample with 100,000 rows and 21 columns ( A to U ) is working.
I opened the Worksheet in excel and then executed this one line code:
Code (fw): Select all Collapse
   XBROWSER GetExcelRange() FASTEDIT
Regards



G. N. Rao.

Hyderabad, India
Jimmy
Posts: 1772
Joined: Thu Sep 05, 2019 05:32 AM

Re: Fivewin and ADO

Posted: Tue Jun 13, 2023 05:21 PM
hi,

sorry i have not write that Error had to do with
Code (fw): Select all Collapse
   objRS:ActiveConnection:Close()
which i had NOT before.
i had "open" it as 2nd File but Connection of 1st File was still "active" so i got the Error

now i have no Problem any more to "open" *.XLSx :D
greeting,

Jimmy
Jimmy
Posts: 1772
Joined: Thu Sep 05, 2019 05:32 AM

Re: Fivewin and ADO

Posted: Sun Jun 25, 2023 08:25 PM
hi,

i have try to download PostgreSQL OLEDB, but it seem there have something change with PostgreSQL
https://www.postgresql.org/download/products/2-drivers-and-interfaces/
so it is NOT free any more ...

---

i found a Version of PgOleDb.DLL at sourceforge
https://sourceforge.net/projects/pmpostgresqlole/
does somebody use it :?:
greeting,

Jimmy
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM

Re: Fivewin and ADO

Posted: Sun Jun 25, 2023 11:25 PM

psqlODBC is free

Regards



G. N. Rao.

Hyderabad, India
Jimmy
Posts: 1772
Joined: Thu Sep 05, 2019 05:32 AM

Re: Fivewin and ADO

Posted: Mon Jun 26, 2023 12:28 AM
hi,
nageswaragunupudi wrote:psqlODBC is free
ok, that is the other Way
greeting,

Jimmy

Continue the discussion

Static archive · New replies & topics via GitHub Discussions