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?
thank a lot
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
Thanks Mirtheil for reply, but when i try to use this syntax to connect, it comes out another error message as below
"could not translate host name "10.10.10.27,5433" to address: Unknown host."
Do anyone have any idea to solve this? Please help ...