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

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 (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group