I have PSQL 6.3.2 installed and have set the following items:
/etc/rc.d/init.d/postgresql
added -I to the startup line
in the
/var/lib/pgsql
added host all 10.0.0.2 255.255.255.0 trust
I then added the user gary to the db
Logged in as gary and created a db
Created 1 table foo
Tested it and can view it.
and then rebooted and tested again, on the client side, I added the odbc
driver and set it up as a system dsn. I then used for the username gary, my
std login password and the ip address. It seems to work fine. When I load
up access 97 I link to the odbc for psql and then click ok for the default
and it does nothing. When I specify a database it gives me the error
unsupported frontend protocol (#210).
Any ideas,
Gary Smith
