Thread: psqlODBC 09.00.0310 Released
We are pleased to announce the release of psqlODBC 09.00.0310. Changes and updates in the new release include: 1.) Let SC_forget_unnamed() clear the result in case the statement is not executed yet. It would fix the bug reported by Silvio Brandani. 2.) Fix the bug that strings are copied to a null pointer. 3.) Don't clear the parsed plan in SC_recycle_statement(). 4.) Now SQLDescribeCol() can detect the changes of column type or size. 5.) Handle *with or without oids* correctly. 6.) Take the environment variable into account. 7.) Use SOCK_get_next_n_bytes() instead of SOCK_get_next_byte(). 8.) Add some driver specific options for SQLSetConnectAttr(). 9.) Fix compilation errors in case ODBC 2.5. 10.) Fix compilation error on different ODBCVER. 11.) Correct the behavior of SQLSetConnectAttr() for the driver specific options. psqlODBC may be downloaded from http://www.postgresql.org/ftp/odbc/versions/ in source, Windows Installer, merge module, and basic zip file formats. Please post any bug reports to the pgsql-odbc@postgresql.org mailing list. I'd like to take this opportunity to thank all those involved with the development, testing and bug fixing of the updated driver. -- psqlODBC team.
On Friday 08 July 2011 21:08:21 Hiroshi Saito wrote: > Changes and updates in the new release include: > 5.) Handle *with or without oids* correctly. Thank you very much. However, the behaviour is still no exactly what I expected: I have a legacy excel 97 database, poorly designed, with about 100 tables, 1000 queries, complex forms... You get the picture. I used a recent mdbtools snapshot from git to convert the database to postgres (index, default values, constaints, this rocks!). However, I had a lot of tables without a primary keys. What I did is adding oids for these tables, and created a primary key (on oid). Now, I still have some legacy code from access I'd like to use. I changed the access tables to psql linked tables, and I'm opening the connection with that: ODBC;CA=r;A6=;A7=100;A8=4096;B0=255;B1=8190;B9=0;BI=0;C2=dd_;CX=1b102bb;A1=8.4;DSN=india;SERVER=10.10.10.146;DATABASE=india;PORT=5432;UID=jvourger;PASSWORD=xxxxxxxx (This is CX with BIT_SHOWOIDCOLUMN) But when open these tables with a primary key on oid, I don't see the oid column and I can't append data. I also tried CX=1d102bb (BIT_FAKEOIDINDEX). Same results. Does anyone has any idea about what is going on? Is that an excel problem? Or is there some change I could make in psqlodc to have these linked tables work with legacy accessmodules? -- - - Nirgal Vourgère ☮ GP France ☮ tel:+33.180969724 - xmpp:nirgal@nirgal.com ☮ gpg 0x4760b41db292ab13 ☮ skype:nirgal_v nirgal.com:qotd ☮ Be the change you want to see in the world -- Gandhi
Attachment
Hi Nirgal-san. Sorry very late reaction. Umm, I can't explore your problem.... Office 97 is very old which does not reach it for me. although I use 2003, I don't look at a problem. For example, http://winpg.jp/~saito/psqlODBC/check/FakeIndex.png Regards, Hiroshi Saito (2011/07/12 18:26), Nirgal Vourgère wrote: > On Friday 08 July 2011 21:08:21 Hiroshi Saito wrote: >> Changes and updates in the new release include: >> 5.) Handle *with or without oids* correctly. > > Thank you very much. > However, the behaviour is still no exactly what I expected: > > I have a legacy excel 97 database, poorly designed, with about 100 tables, 1000 queries, complex forms... You get the picture. > I used a recent mdbtools snapshot from git to convert the database to postgres (index, default values, constaints, thisrocks!). > However, I had a lot of tables without a primary keys. > What I did is adding oids for these tables, and created a primary key (on oid). > > Now, I still have some legacy code from access I'd like to use. > I changed the access tables to psql linked tables, and I'm opening the connection with that: > ODBC;CA=r;A6=;A7=100;A8=4096;B0=255;B1=8190;B9=0;BI=0;C2=dd_;CX=1b102bb;A1=8.4;DSN=india;SERVER=10.10.10.146;DATABASE=india;PORT=5432;UID=jvourger;PASSWORD=xxxxxxxx > (This is CX with BIT_SHOWOIDCOLUMN) > But when open these tables with a primary key on oid, I don't see the oid column and I can't append data. > > I also tried CX=1d102bb (BIT_FAKEOIDINDEX). Same results. > > Does anyone has any idea about what is going on? > Is that an excel problem? Or is there some change I could make in psqlodc to have these linked tables work with legacyaccess modules? >