Re: PEAR::DB ODBC nextID() on Access

Hello Pierre-Alain, thanks for the reply. "Pierre-Alain Joye" <paj@pearfr.org> schrieb im Newsbeitrag news:20020704095001.2666f908.paj@pearfr.org... > Hello, > > On Wed, 3 Jul 2002 23:31:34 +0200 > "Sebastian Röbke" <sebastian@sebastian-r.de> wrote: > > > > I noticed that creating the table for a sequence ( implemented in nextID() ) > > using the odbc driver uses bigint as column type. > > When connecting to an Access 2000 database using PEAR::DB Version 1.2 it > > seems to have problems with this type ... > BIGINT was introduced in DAC after the release of Access 2K. Did you installed all the SP from the 1st release ( at least SR-1) ? No I haven´t yet. Will try this asap. > > Note I never use Access with php, but get this problem with SQL server 2000. I normally wouldn´t either, but currently I´m writing a database independent app and need to be sure to support as many systems as possible... > > hth It does ;-) > > pa Best regards,...Sebastian