Re: interfacing ms-access with postgresql? - Mailing list pgsql-admin

From Ngoc-Khoi TO
Subject Re: interfacing ms-access with postgresql?
Date
Msg-id 9gpjni$2u6v$1@news.tht.net
Whole thread Raw
In response to Re: interfacing ms-access with postgresql?  (Stefan Huber <schweinsaug@crosswinds.net>)
List pgsql-admin
Is these the small probleme with postgresql odbc drivers. The buffer of data
row is limiter about 8K if you have a big row data you need to change some
liter declaration and compile it.

If you have this probleme email me.

Best regard,
Ngoc-Khoi TO.


Stefan Huber <schweinsaug@crosswinds.net> a �crit dans le message :
5.1.0.14.0.20010611163236.00aa85a8@pop.crosswinds.net...
>
> >     I'd like to interface ms-access 2000 with postgresql 7.1.1. What my
> >objective is is to create a database in access, then upload it on to a
web
> >server, and via an interactive form and postgresql have various data
> >returned, or to enter new data from the web site. Is this possible?
> >Thanks.
>
>
> Get the latest ODBC driver for Windows (should be on your local mirror in
> ~/pub/odbc/versions, for example
> ftp://gd.tuwien.ac.at/db/www.postgresql.org/pub/odbc/versions/ , which is
> my closest one )
> The create a connection to your "webdatabase" using a system DSN and
stream
> your data through it by connecting to the tables in Access and creating
> updatequeries.
> Of course, you must be able to connect to the PostgreSQL Port on the
remote
> machie, otherwise, it might become quite tricky.
>
> HTH,
> Stefan
>
> --
> I don't have a solution but I admire the problem.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



pgsql-admin by date:

Previous
From: Felipe Carasso
Date:
Subject: Full backup
Next
From: "W. van den Akker"
Date:
Subject: Re: User rights