I try to connect from windows to linux postgresql using pgOLEDB using this 'Provider=PostgreSQL OLE DB Provider;Location=posdbv2005;Data Source=10.10.10.27;UserID=postgres;Password=dlink5 17',
but this error prompt out " Could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "10.10.10.27" and accepting TCP/IP connections on port 5432?"
I understand that pgOLEDB ver 188.8.131.52 could not listen to other port except 5432 as default for time being, i try to start the database in port 5432 and another error message prompt as this "
LOG: could not create IPv6 socket: Address family not supported by protocol
FATAL: Lock file "/usr/local/pgsql/data/postmaster.pid" always exists
HINT: Is another postmaster (PID 3248) running in data directory "/usr/local/pgsql/data"? "
i need to connect to the database at port 5433 using pgOLEDB, can anyone help me?
Haven't tried it but you might try:
'Provider=PostgreSQL OLE DB Provider;Location=posdbv2005;Data Source=10.10.10.27,5433;UserID=postgres;Password=d link5 17'
That's the syntax I've found that works for other providers.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Have you configured PostgreSQL to accept client connections?
Look at "Client Authentication" in the PostgreSQL documentation (pp 297 in v8.0x documentation.) Essentially, you need to configure pg_hba.conf on the server to allow remote computers to communicate to the server.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert