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@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)