Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0O49E033218 for ; Tue, 23 Jan 2001 23:09:14 -0500 (EST) (envelope-from pgsql-interfaces-owner@postgresql.org) Received: from relay2.jaring.my (relay2.jaring.my [192.228.128.12]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0M2NM071560 for ; Sun, 21 Jan 2001 21:23:22 -0500 (EST) (envelope-from yumin@pl.jaring.my) Received: from pl.jaring.my (j55.jhb59.jaring.my [161.142.214.129]) by relay2.jaring.my (8.9.3/8.9.3) with ESMTP id KAA12440 for ; Mon, 22 Jan 2001 10:23:17 +0800 (MYT) Message-ID: <3A6B9ABB.B385BCF1@pl.jaring.my> Date: Mon, 22 Jan 2001 10:28:11 +0800 From: Nicholas Chan X-Mailer: Mozilla 4.71 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: Postgresql Interfaces Subject: extremely newbie questions Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/269 X-Sequence-Number: 887 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 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? 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) 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: Error Details ************* Error Number: -2147467259 Error Description: Could not connect to the server; Could not connect to remote socket. Error Source: Microsoft OLE DB Provider for ODBC Drivers Subroutine of Function: frmODBCLogon, cmdOK_Click Any help would be very much appreciated. I can't even seem to open the main pgAdmin program! And thanks in advance. Warmest regards, Nicholas Chan