hi list,
i have some problems, to connect to the postgre
with a client by odbc.
1. i compiled with libpsqlodbc
2. run createdb vshop
3. created user: CREATE USER VSHOP with PASSWORD 'VSHOP';
odbc.ini:
[ODBC Data Source]
vshop = VShop sample Database
[vshop]
Servername = localhost
Database = vshop
Username = VSHOP
Password = VSHOP
Driver = /usr/local/pgsql/lib/libpsqlodbc.so
my ipAddr is 10.0.8.16
in ths pg_hba.conf i added the line:
host all 10.0.8.16 255.255.255.255 trust
after i try connect with the client i get following errormsg in
/tmp/psqlodbc_root1234.log:
ERROR from backend during send_query: 'FATAL1: user "VSHOP" does not exist'
CONN ERROR: func=SQLConnect, desc='Error on CConnect', errnum=105,
errmsg='The database does not exist on the server or user authentication
failed.'
maybe anybody can help me
oliver