From: | "Oliver Walter" <owalter(at)intradat(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | odbc-connect |
Date: | 2001-12-10 16:37:30 |
Message-ID: | 001f01c18198$f6456680$0e08000a@pcowalter |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Bell | 2001-12-10 18:10:41 | Re: Can anybody help me with SQL? |
Previous Message | Rasputin | 2001-12-10 09:48:32 | securing Postgres |