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@postgresql.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.braddy@uta.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