Page 3 of 3
Re: Fivewin and ADO
Posted: Sat Jun 10, 2023 6:32 pm
by nageswaragunupudi
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
Re: Fivewin and ADO
Posted: Sat Jun 10, 2023 8:45 pm
by Jimmy
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"
Re: Fivewin and ADO
Posted: Tue Jun 13, 2023 5:53 am
by nageswaragunupudi
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:
Re: Fivewin and ADO
Posted: Tue Jun 13, 2023 5:21 pm
by Jimmy
hi,
sorry i have not write that Error had to do with
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
Re: Fivewin and ADO
Posted: Sun Jun 25, 2023 8:25 pm
by Jimmy
hi,
i have try to download PostgreSQL OLEDB, but it seem there have something change with PostgreSQL
https://www.postgresql.org/download/pro ... nterfaces/
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
Re: Fivewin and ADO
Posted: Sun Jun 25, 2023 11:25 pm
by nageswaragunupudi
psqlODBC is free
Re: Fivewin and ADO
Posted: Mon Jun 26, 2023 12:28 am
by Jimmy
hi,
nageswaragunupudi wrote:psqlODBC is free
ok, that is the other Way