was able to connect to PostgreSQL DB present in sysA when it was running in the windows mode from another sysB using the VB.net connection string "DRIVER={PostgreSQL};SERVER=ipaddress;port=5432;DATABASE=dbname;UID=username;PWD=password;"
inspite of giving the computer name instead of the ipaddress... it still worked.
In the pg_hba.conf file, i had set the connection to Hostnossl . the lan ip address and enabled a trusted connection between the PostgreSQL in sysA and my VB.Net in sysB.
Now i am facing a problem when the sysA is running in the Red Hat Linux Mode. I am not able to establish a connection, an error is thrown stating the it is not able to resolve the remote socket. well. the error no is 08001
i used the same connection string, but for the SERVER value i gave the IP address of the sysA wihile running in the linux mode.
i have also done the same changes to the pg_hba.conf file. still it a'int working.
plz do help me out.
shankzi
inspite of giving the computer name instead of the ipaddress... it still worked.
In the pg_hba.conf file, i had set the connection to Hostnossl . the lan ip address and enabled a trusted connection between the PostgreSQL in sysA and my VB.Net in sysB.
Now i am facing a problem when the sysA is running in the Red Hat Linux Mode. I am not able to establish a connection, an error is thrown stating the it is not able to resolve the remote socket. well. the error no is 08001
i used the same connection string, but for the SERVER value i gave the IP address of the sysA wihile running in the linux mode.
i have also done the same changes to the pg_hba.conf file. still it a'int working.
plz do help me out.
shankzi
