odbc-connect

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

Responses

Browse pgsql-novice by date

  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