Обсуждение: odbc-connect

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

Oliver,

> i have some problems, to connect to the postgre
> with a client by odbc.

This is a stab in the dark, but I vaguely remember some sort of problem
with many ODBC drivers for PostgreSQL and capitalization in passwords.
Try creating a user with no caps in the name or the password and try
again.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco