Fivewin and ADO

[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

[Jimmy]

hi,

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"

[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:

Code: Select all  Expand view

  XBROWSER GetExcelRange() FASTEDIT
 

[Jimmy]

hi,

sorry i have not write that Error had to do with

Code: Select all  Expand view

  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

[Jimmy]

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

[nageswaragunupudi]

psqlODBC is free

[Jimmy]

hi,

psqlODBC is free

ok, that is the other Way