Thread: interfacing ms-access with postgresql?

interfacing ms-access with postgresql?

From
"dave"
Date:
Hello,
    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.
Dave.




Re: interfacing ms-access with postgresql?

From
Stefan Huber
Date:
>     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.


Re: interfacing ms-access with postgresql?

From
"Ngoc-Khoi TO"
Date:
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)