Обсуждение: version considerations
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
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