RE: [SQL] Little Help is needed.

> Hi all, this is my first message on this list and I'm trying to see if
> it's
> possible te get some help from you guys.It's usually pretty easy to get help from use guys (and gals).  You
have several question here all of which belong on different list from the
one to which this is posted so I'll note the appropriate list in my answers.

> I'm interested in using postgresql to connect from windows using VB 5.0.
> with  ADO and I'm not sure what  I need to do this but I think I need the
> following:
> 
>     a) A driver to install under NT or W98, where can I get it?Yes, you will need the ODBC driver at
http://www.insightdist.com/psqlodbc(best suited to the pgsql-interfaces list)

>     b) The settings on the client side and also what do I need on the
> LINUX
> server ( daemon, service,?????).You need to start the postmaster with the -i option and set up your
pg_hba.conf file, which should be in your data directory, to the appropriate
authentication.(best suited to the pgsql-admin list)

>     c) How reliable is this database?
>     d) How scalable it is?I've never had an unsolvable problem with PostgreSQL and each new
version seems to be light-year leaps ahead.PostgreSQL is as reliable as any other database I have ever used.
There are some scalability issues, but only when compared to Oracle or MS
SQL 7.0 (but I don't think it will be that way a year from now); these are
in the area of distributed databases and replication.(best suited to the pgsql-general list)

>     e) How many users this database supports?If there's a user limit I haven't found it (but hey I haven't
looked).  I think I did hear about a limit in the database but you could
change it in the config.h file if I'm not mistaken.(best suited to the pgsql-admin list)

> I've heard a lot of good thinks about LINUX and POSTGRESQL and I'm willing
> to give it a shot to see if I can replace some databases that I have here
> on
> my college. Thanks.
> What are you currently using?  PostgreSQL should server most of your
needs effectively.
Hope this helps,    DEJ