Skip site navigation (1) Skip section navigation (2)


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 (view raw, whole thread or download thread mbox)
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 Data Source]
vshop = VShop sample Database

Servername = localhost
Database   = vshop
Username   = VSHOP
Password   = VSHOP
Driver     = /usr/local/pgsql/lib/

my ipAddr is
in ths pg_hba.conf i added the line:
host    all    trust

after i try connect with the client i get following errormsg in

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

maybe anybody can help me



pgsql-novice by date

Next:From: Andrew BellDate: 2001-12-10 18:10:41
Subject: Re: Can anybody help me with SQL?
Previous:From: RasputinDate: 2001-12-10 09:48:32
Subject: securing Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group