Обсуждение: extremely newbie questions

Поиск
Список
Период
Сортировка

extremely newbie questions

От
Nicholas Chan
Дата:
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
Accessbe used?  (*.mdb)
 
3) i've tried creating a PostgreSQL ODBC connection with a Microsoft  Access database, but when I start pgAdmin and
connectto 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


Re: extremely newbie questions

От
"Oliver Elphick"
Дата:
Nicholas Chan wrote: >I'm using pgAdmin 7.05 and PostgreSQL ODBC driver v6.50.00.00. >I've installed the above two as
wellas MDAC v2.6 >And i'm running Windows NT Workstation with Service Pack v6a
 
 >3) i've tried creating a PostgreSQL ODBC connection with a Microsoft >   Access database, but when I start pgAdmin
andconnect to the >   source i've specified, this error message appears: > >Error Details >************* >Error Number:
-2147467259>Error Description: Could not connect to the server;
 
Is the server listening for TCP/IP connections -- that is, has the
postmaster been started with the -i option?

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
========================================   "If anyone has material possessions and sees his     brother in need but has
nopity on him, how can the     love of God be in him?"                                   I John 3:17