RE: extremely newbie questions

> -----Original Message-----
> From: Nicholas Chan [mailto:yumin(at)pl(dot)jaring(dot)my]
> Sent: 22 January 2001 02:53
> To: Postgresql Interfaces
> Subject: [INTERFACES] extremely newbie questions
>
>
>
> I'm very new when it comes to databases, and I'd like to try out
> pgAdmin on my Windows NT to create, configure and manage some
> databases on a remote linux server.
>
> I'm using pgAdmin 7.05 and PostgreSQL ODBC driver v6.50.00.00.
> I've installed the above two as well as MDAC v2.6
> And i'm running Windows NT Workstation with Service Pack v6a

You will also need to install the PostgreSQL ODBC driver which can be
obtained from ftp.postgresql.org

> 1) I want to test out PostgreSQL on a windows platform, so is there
> anything else I have to install other than the software
> I have mentioned above? I assume that pgAdmin is something like
> MSSQL server, or am I wrong? is it just a frontend?

pgAdmin is more like SQL's Enterprise Manager (in function, not design) - it
is not the dbms itself.

> 2) where can I find a sample database which can be used for pgAdmin?
> Can any regular database created by Microsoft Access be used?
> (*.mdb)

No, you you can't use mdb's (though pgAdmin can migrate them for you). You
need to install PostgreSQL on your linux box - you can get this from
ftp.postgresql.org, or some distros such as Suse and Redhat come with rpms.

> 3) i've tried creating a PostgreSQL ODBC connection with a Microsoft
> Access database, but when I start pgAdmin and connect to the
> source i've specified, this error message appears:

Yes, that will happen because pgAdmin is expecting to be connected to
PostgreSQL.

Regards,

Dave.