Re: Using PostgreSQL and Access?
От | Kevin J. Drewiske |
---|---|
Тема | Re: Using PostgreSQL and Access? |
Дата | |
Msg-id | 01C15CDA.491A97B0.drewiskk@msoe.edu обсуждение исходный текст |
Ответ на | Using PostgreSQL and Access? ("Markus Meyer" <meyer@mesw.de>) |
Ответы |
Re: Using PostgreSQL and Access?
("Markus Meyer" <meyer@mesw.de>)
|
Список | pgsql-general |
I've been using an MS Access front-end with Postgres on Digital Unix, Redhat and Mandrake with fairly good results. We started on v6.5.3 and just upgraded to 7.1.3. I download the ODBC driver from odbc.postgresql.org and haven't had any problems. The duplicate error could possibly because Access cannot identify a unique record. A 'many' table in a one to many relationship could cause this problem if the foreign key is 'keyed' rather than a unique key (which I implement similar to Access' auto number). You may want to show the OID column (Advanced Settings). If you would like, I have prepared an 'ODBC installation manual' that I have in PDF format that contains graphics/screenshots for the individual settings. Please contact me directly if you would like to obtain this file. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Kevin Drewiske '01 CE MSOE Webmaster Team: http://www.msoe.edu/ KJDesign Website Development: http://www.drewiske.com/KJDesign/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -----Original Message----- From: Markus Meyer [SMTP:meyer@mesw.de] Sent: Wednesday, October 24, 2001 18:29 To: PostgreSQL (General) Mailing List Subject: Using PostgreSQL and Access? Since the PostgreSQL (CygWin) mailing list seems to be quite dead, I'm posting this one here. My question is: Has any one successfully used PostgreSQL with Access? I have read the Accces-FAQ, but I still have major problems: When I create a form and change / add some data in there, I always get errors, f.e. "Cannot add duplicate index" (although I did just a minor change), but also other error messages, or data conversion errors ("Cannot convert XID to int4"). The error messages change, if I try other settings in ODBC driver, but it doesn't work either. Also I get the error messages about the unique index when I add a new record as described in the ODBC FAQ, but I don't agree with the "workaround" by using a timestamp. That one is really weird, and it really should work without. Maybe PostgreSQL (or the ODBC driver) should have a "compatibility" mode to work with more forgiving frontends. I don't see, why f.e. a boolean column gives an error, if you do something like "boolean_col = 0". Access does work well with other databases over ODBC (okay, SQL Server works, but also MySQL), so why doesn't PostgreSQL? Regards Markus ---------------------------------------------------- Sign Up for NetZero Platinum Today Only $9.95 per month! http://my.netzero.net/s/signup?r=platinum&refcd=PT97
В списке pgsql-general по дате отправления: