| 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: | Whole Thread | Raw Message | 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 |