From: | Scott Shealy <sshealy(at)asgnet(dot)psc(dot)sc(dot)edu> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org''" <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: ODBC failure |
Date: | 2001-01-05 18:54:22 |
Message-ID: | 5773B442597BD2118B9800105A1901EE1B4D06@asgnet2.psc.sc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sorry guys.... I figured out what was wrong.... in my postgressql startup
script I was passing the -i option to the backend instead of the postmaster.
My fault....
Scott Shealy
-----Original Message-----
From: Scott Shealy [mailto:sshealy(at)asgnet(dot)psc(dot)sc(dot)edu]
Sent: Friday, January 05, 2001 11:31 AM
To: 'pgsql-general(at)postgresql(dot)org''
Subject: ODBC failure
> Hey there... I am new to postgres... I have a V 7.02 db on linux up and
> running an populated. I am trying to get ODBC to run against it from a
> windows NT box and am having trouble.
>
> On the server side I have added the -i command to the postmaster command
> Editted the pg_hba.conf file to allow my client by adding the line.
>
> host all xxx.xxx.xxx.0 255.255.255.0 trust
>
> (xxx is ip address) wanted to allow whole subnet to access db
>
> Restarted the server.
>
> On the client I installed the 6.5 driver from the exe file.
>
> Set up a System DSN connecting to the server using port 5432.
>
> Tried testing it in Access by linking a table in access and get the error
>
> Unable to open sockect(#101)...
>
> Any help here is greatly appreciated. My only thought up to this point is
> ... can a V7 db talk with a 6.5 ODBC driver?
>
>
> Scott Shealy
> E811 Inc
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joel Burton | 2001-01-05 18:55:41 | Re: RE: Using Postgres with Access 2000 |
Previous Message | Alex Pilosov | 2001-01-05 18:53:55 | DBD::Pg and NOTIFY (was Re: Synchronous LISTEN/NOTIFY?) |