Re: programming language for postgresql

--- Ramon Orticio <rporticio(at)yahoo(dot)com> wrote:

>
> dear friends,
>
> i am intending to do is to have a database system
> where there is a server for storage of data and a
> multiuser application distributed over a network of
> computer.
>
> i would like to have a similar system to what i did
> with microsoft access as the database and vb6 as the
> programming language that connects to access and
> creates the gui.

You can do the same thing via ODBC. I have converted
several MS Access applications to use PostgreSQL as a
backend, with great success. A few points:

* Look at a migration tool, to make your life easier.
I have had excellent results with the "database
migration wizard" that comes with PgAdminII, the
earlier version of the PgAdminIII administration tool
(unfortunately, the wizard has not been added to III
yet AFAIK). Look at http://www.pgadmin.org (which
seems to be down as I write this).

* Download the psqlodbc driver, and read the FAQs and
hints for Access and VB users that you can find on the
project page:
http://gborg.postgresql.org/project/psqlodbc

* Your application may run fine without any changes
whatever, or you may need to make some changes: there
are some issues with running MS Access in
client-server mode, which may or may not cause your
app a problem. There is an excellent coverage of
Access client-server issues in the well-known "Access
Developer's Handbook". For example, for reports, you
may need to make some of your queries into
pass-through queries, in order to make them more
efficient.

* Subscribe to the pgsql-odbc mailing list, and post
your questions there. The archives for that list will
have lots of material that will be helpful for you.

>
>
> thanks.
>
> ramon
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

__________________________________
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250