[Gambas-user] ODBC - unable to fetch row

[Karl Reinl]

Am Samstag, den 30.01.2021, 17:01 +0000 schrieb KKing:
> Hi Charlie
> 
> > and easysoft have an Access ODBC Driver:
> > https://www.easysoft.com/products/data_access/odbc-access-driver/getting-started.html
> 
> I have odbc connection to mdb's working fine with unixODBC and
> mdbtools 
> ... it's just using that with gb.db.odbc that currently flails..
> 
> plus Easysoft don't list Access 97 which is the version of these and
> at a price of 899 GBP ... I do not think so !
> 
> > But I have tested this in meantime: even with freeTDS, I get an
> > rs.count.
> > 
> > Prewar photo of Ala Gertner. Bedzin, Poland, 1930s.
> > 
> > After being deported to Auschwitz, Ala Gertner took fate into her
> > own hands. Upon arrival, she was assigned to forced labor at a
> > nearby armaments factory.  After learning that they were going to
> > be killed, Gertner, along with fellow female prisoners, began
> > smuggling gunpowder and explosives from the factory with plans to
> > destroy one of the crematoriums. 
> > 
> > During the uprising in October 1944, the prisoners killed three
> > guards. They also set fire to Crematorium 4, making it inoperable
> > 
> > The guards crushed the revolt and killed almost all of the
> > prisoners involved in the rebellion. The Jewish women, including
> > Gertner, who had smuggled the explosives into the camp were
> > publicly hanged in early January 1945.
> > 
> > So it seems to be the SQL server and not the Odbc drivers.
> 
> but that is with MS SQL ... not what I'm looking at
> 

Salut,

my proposed Linked Server dont' work with a SQLserver on Linux, thers
no driver for Access.

But I found that : ODBTP from 2006 but as you deal with Access 97, that
could help. (didn't inspect or try)
https://sourceforge.net/projects/odbtp/

-- 
Amicalement
Charlie