Hi,
I am new to PosGreSql and have problem connecting to PostGreSql from a
machine with pslodbc driver. I don't know what is wrong but in my
simple code to connect to the database using ODBCConnection from the
server machine, it does not send out error message when I specify the
server as 'localhost' but when I set the server as 'Dbsvr' in the
connection string then it sent out ODBC error that it could not connect
to data source, could not connect ot remote socket. I would appreciate
if anyone can enlighten me. My postgresql.conf is below:
"
#---------------------------------------------------------------------------
# FILE LOCATIONS
#---------------------------------------------------------------------------
# The default values of these variables are driven from the -D command
line
# switch or PGDATA environment variable, represented here as ConfigDir.
# data_directory = 'ConfigDir' # use data in another directory
# hba_file = 'ConfigDir/pg_hba.conf' # the host-based authentication
file
# ident_file = 'ConfigDir/pg_ident.conf' # the IDENT configuration
file
# If external_pid_file is not explicitly set, no extra pid file is
written.
# external_pid_file = '(none)' # write an extra pid file
#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------
# - Connection Settings -
#listen_addresses = '*' # what IP interface(s) to listen on;
# defaults to localhost, '*' = any
port = 5432
max_connections = 100
# note: increasing max_connections costs about 500 bytes of
shared
# memory per connection slot, in addition to costs from
shared_buffers
# and max_locks_per_transaction.
#superuser_reserved_connections = 2
#unix_socket_directory = 'software-labs.net'
#unix_socket_group = 'software-labs.net'
#unix_socket_permissions = 0777 # octal
#rendezvous_name = '' # defaults to the computer name
#tcpip_socket = true
# - Security & Authentication -
#authentication_timeout = 60 # 1-600, in seconds
#ssl = false
#password_encryption = true
#krb_server_keyfile = ''
#db_user_namespace = false
"
Thank you in advance,
Sunny