Re: interfacing ms-access with postgresql?

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(at)crosswinds(dot)net> a crit dans le message :
5(dot)1(dot)0(dot)14(dot)0(dot)20010611163236(dot)00aa85a8(at)pop(dot)crosswinds(dot)net(dot)(dot)(dot)
>
> > 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(at)postgresql(dot)org)