Re: version considerations

From: Chris Gamache <cgg007(at)yahoo(dot)com>
To: George E Braddy <ed(dot)braddy(at)uta(dot)edu>, "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: version considerations
Date: 2003-06-19 20:09:53
Message-ID: 20030619200953.16828.qmail@web13804.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

There are no issues that I know of! Is this a problem with just MS Access? Can
you create a .UDL file, configure it and make a test connection? If not here
are some troubleshooting steps:

First, be certain that the postmaster was started with -i for internet access.
Make note of the port that it is listening on. Next, check your pg_hba.conf to
be certain that your windows machine has privleges to connect to your server,
specific database, and the authentication scheme is configured properly for
connections from the ODBC driver (MD5 passwords have been a hot issue recently
on the listserv). Last, verify that the user has access to the tables within
the database (although that wouldn't preclude connecting to the database, just
accessing data once connected.)

Questions about pg_hba.conf should probably be directed to
pgsql-admin(at)postgresql(dot)org (after reading about them in the docs.... :)

Specific error messages you receive would be good.

These are very simple suggestions. If you're beyond this, give us something
more to chew on...

HTH,

CG

--- George E Braddy <ed(dot)braddy(at)uta(dot)edu> wrote:
> Hello all,
>
>
> I would like to know if using the most current psqlODBC driver as of June
> 15th 2003 on windows XP machine would prevent me from connecting to a red
> hat Linux 9.0 machine using a postgres 7.3.2 database? I just want to move
> my access database information to my current red hat database. I seem to be
> able to connect to postgresql databases version 7.2.3 on Linux 7.3 machines
> correctly.
>
> G. Edward Braddy II
> Computer User Services Specialist
> Univerity of Texas at Arlington
> Engineering Technical Services - IT Group
> DEAN of Engineering Department
>
>

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Giuliano Gavazzi 2003-06-20 21:08:34 Re: OS X driver
Previous Message Dave Page 2003-06-19 16:11:13 Re: Bug in ODBC driver doing UPDATES and DELETES (fwd)