From: | James Herbers <james(at)herbers(dot)ca> |
---|---|
To: | C K <shreeseva(dot)it(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: MS Access and PostgreSQL |
Date: | 2006-04-07 20:00:32 |
Message-ID: | 4436C4E0.9010205@herbers.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Microsoft has a KB article here -
http://support.microsoft.com/kb/q128809/ - you may want to look at. I
found the best way to avoid this was to use pass-through queries.
J Herbers
C K wrote:
> Dear Friends,
> I am here for a problem regarding MS Access and PostgreSQL connection
> through ODBC. I have liked my PostgreSQL database tables to MS Access.
> When I am going for inserting/updating any data is just displays
> #deleted. I also use MySQL (client's choice). Same problem occurs for
> MySQL also. But when I set the 'Return matching rows' option from
> MyODBC 3.51.12 interface. the problem mostly gets solved. Other things
> required are PK (or Unique column), a timestamp etc. I have done all
> these for POstgreSQL, but it doen't work. Is there any option as
> 'Return matching rows' for PGODBC? Or How I can solve this problem?
> Please help.
> Thanks and Regards.
> CPK
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
From | Date | Subject | |
---|---|---|---|
Next Message | Evert Daman | 2006-04-07 21:31:00 | Re: database owner gone? |
Previous Message | C K | 2006-04-07 19:45:49 | MS Access and PostgreSQL |