Обсуждение: Access Autonumber fields not detected in 9.0.0200
Hi all ! We are linking PostgreSQL tables (server version 8.4) into Access 2000. I tried upgrading our psqlodbc driver from 8.03.0400 to 9.00.0200, but the autonumber fields (converted from serial fields) are not detected anymore. The connection string is the same (i.e. there is still the "0x2" extra option to detect serial as autonumber). I have pasted the debug log of the psqlodbc 9.00.0200 driver trying to link the table (and failing to detect autonumber) here : http://pastebin.com/aVRWFyJd If you need any other information, I can do some testing. Thanks a lot for your help ! Regards, Arnaud Lesauvage
Hi Arnaud, (2011/03/03 20:16), Arnaud Lesauvage wrote: > Hi all ! > > We are linking PostgreSQL tables (server version 8.4) into Access 2000. > I tried upgrading our psqlodbc driver from 8.03.0400 to 9.00.0200, but > the autonumber fields (converted from serial fields) are not detected Didn't you drop the *not null* attribute from the fields? regards, Hiroshi Inoue > anymore. > The connection string is the same (i.e. there is still the "0x2" extra > option to detect serial as autonumber). > > I have pasted the debug log of the psqlodbc 9.00.0200 driver trying to > link the table (and failing to detect autonumber) here : > http://pastebin.com/aVRWFyJd > > If you need any other information, I can do some testing. > > Thanks a lot for your help ! > > Regards, > Arnaud Lesauvage
Hi Hiroshi Le 4/03/2011 9:49, Hiroshi Inoue a écrit : >> > We are linking PostgreSQL tables (server version 8.4) into Access 2000. >> > I tried upgrading our psqlodbc driver from 8.03.0400 to 9.00.0200, but >> > the autonumber fields (converted from serial fields) are not detected > Didn't you drop the *not null* attribute from the fields? No, it's still there. We didn't change anything but the psqlODBC driver. I tried to switch back and force from 8.03.0200 to 9.00.0200, and the field is linked as autonumer in v8 and numeric in v9. Here is part of the create table : CREATE TABLE codata.prestations ( gid integer NOT NULL DEFAULT nextval('prestations_gid_seq'::regclass), [..., ] CONSTRAINT prestations_pkey PRIMARY KEY (gid) ) Regards, Arnaud Lesauvage
Hi Arnaud, Could you please try the drivers on testing for 9.0.0202 at http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/ ? regards, Hiroshi Inoue (2011/03/04 18:18), Arnaud Lesauvage wrote: > Hi Hiroshi > > Le 4/03/2011 9:49, Hiroshi Inoue a écrit : >>> > We are linking PostgreSQL tables (server version 8.4) into Access >>> 2000. >>> > I tried upgrading our psqlodbc driver from 8.03.0400 to 9.00.0200, but >>> > the autonumber fields (converted from serial fields) are not detected >> Didn't you drop the *not null* attribute from the fields? > > > No, it's still there. We didn't change anything but the psqlODBC driver. > I tried to switch back and force from 8.03.0200 to 9.00.0200, and the > field is linked as autonumer in v8 and numeric in v9. > > Here is part of the create table : > > CREATE TABLE codata.prestations > ( > gid integer NOT NULL DEFAULT nextval('prestations_gid_seq'::regclass), > [..., ] > CONSTRAINT prestations_pkey PRIMARY KEY (gid) > ) > > Regards, > Arnaud Lesauvage
Le 4/03/2011 16:35, Hiroshi Inoue a écrit : > Could you please try the drivers on testing for 9.0.0202 at > http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/ I made a very quick test, and it looks very good ! I'll do some more testing next week. Thanks a lot ! Regards, Arnaud Lesauvage
Le 4/03/2011 16:35, Hiroshi Inoue a écrit : > Could you please try the drivers on testing for 9.0.0202 at > http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/ Hi Hiroshi I can now confirm that this version works fine ! Do you have a release date for an MSI version of this driver ? Thanks a lot ! Arnaud