[coolminded]

hi,
i'm using vb6 as a front end and postgresql 8.0.0 as a backend. i just configured the pg_hba.conf file. i changed the method to "md5" and in the database, i gave the name of database. but when i connect with my application, it shows runtime error -3146 , odbc--call failed.

my pg_hba.conf file is as

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
#host all all 127.0.0.1/32 md5
host db_test postgres 127.0.0.1/32 md5

# IPv6 local connections:
#host all all ::1/128 md5

in my application, i put the password 'postgres@132' that i used while installing the postgres.

my connection string is

Public Sub getconnect()
Set ws = CreateWorkspace("", "cdef", "", dbUseODBC)
Set dbaccount = ws.OpenDatabase("", , False, "ODBC;dsn=PostgreSQL30;uid=postgres;pwd='postgres@ 132'")
End Sub

when i use trust instead of md5 in method in pg_hba.conf, it runs well.

can anybody suggest ?
with regards

[rski]

Originally Posted by coolminded

hi,
i'm using vb6 as a front end and postgresql 8.0.0 as a backend. i just configured the pg_hba.conf file. i changed the method to "md5" and in the database, i gave the name of database. but when i connect with my application, it shows runtime error -3146 , odbc--call failed.

my pg_hba.conf file is as

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
#host all all 127.0.0.1/32 md5
host db_test postgres 127.0.0.1/32 md5

# IPv6 local connections:
#host all all ::1/128 md5

in my application, i put the password 'postgres@132' that i used while installing the postgres.

my connection string is

Public Sub getconnect()
Set ws = CreateWorkspace("", "cdef", "", dbUseODBC)
Set dbaccount = ws.OpenDatabase("", , False, "ODBC;dsn=PostgreSQL30;uid=postgres;pwd='postgres@ 132'")
End Sub

when i use trust instead of md5 in method in pg_hba.conf, it runs well.

can anybody suggest ?
with regards

Can you connect to postgres via command line

Expand|Select|Wrap|Line Numbers

1. psql -h 127.0.0.1 -U postgres db_test
2.  

what is the error message if not? Are you sure the postgres has set a password, you can check it in pg_user view.

[coolminded]

Originally Posted by rski

Can you connect to postgres via command line

Expand|Select|Wrap|Line Numbers

1. psql -h 127.0.0.1 -U postgres db_test
2.  

what is the error message if not? Are you sure the postgres has set a password, you can check it in pg_user view.

it asks for the password and when supplied ,it connects to the database db_test from the command line and it also shows the password in the pg_user.

[rski]

i'm not a vb6 specialist but is it right wrtting ' ' here

Expand|Select|Wrap|Line Numbers

1. pwd='postgres@1 32' 
2.  

(space in password value you wrote by mistake i suppose).
Is postgres loggin something when connect failed (did you configue detailed logs?)

[coolminded]

Originally Posted by rski

i'm not a vb6 specialist but is it right wrtting ' ' here

Expand|Select|Wrap|Line Numbers

1. pwd='postgres@1 32' 
2.  

(space in password value you wrote by mistake i suppose).
Is postgres loggin something when connect failed (did you configue detailed logs?)

hi rski,
actually, the password is "postgres@132", it's not "postgres@1 32".
it asks password while connecting to server in postgres and after the correct password is provided, it allows to connect
but it doesn't allow me to connect through vb6.

with regards,
coolminded

[rski]

Originally Posted by coolminded

hi rski,
actually, the password is "postgres@132", it's not "postgres@1 32".
it asks password while connecting to server in postgres and after the correct password is provided, it allows to connect
but it doesn't allow me to connect through vb6.

with regards,
coolminded

to be clear password is postgres@132 or 'postgres@132' ?

[coolminded]

Originally Posted by rski

to be clear password is postgres@132 or 'postgres@132' ?

the password is just

pwd = postgres@132

[rski]

Originally Posted by coolminded

the password is just

pwd = postgres@132

So why you write here

Expand|Select|Wrap|Line Numbers

1. Public Sub getconnect()
2. Set ws = CreateWorkspace("", "cdef", "", dbUseODBC)
3. Set dbaccount = ws.OpenDatabase("", , False, "ODBC;dsn=PostgreSQL30;uid=postgres;pwd='postgres@1 32'")
4. End Sub
5.  

pwd='postgres@132' ?
shouldn't it be
pwd=postgres@132 (without apos)?

If VB needs that syntax sorry for my lack of knolwdge.

[coolminded]

Originally Posted by rski

So why you write here

Expand|Select|Wrap|Line Numbers

1. Public Sub getconnect()
2. Set ws = CreateWorkspace("", "cdef", "", dbUseODBC)
3. Set dbaccount = ws.OpenDatabase("", , False, "ODBC;dsn=PostgreSQL30;uid=postgres;pwd='postgres@1 32'")
4. End Sub
5.  

pwd='postgres@132' ?
shouldn't it be
pwd=postgres@132 (without apos)?

If VB needs that syntax sorry for my lack of knolwdge.

thanx for the reply. mistakely i put extra ( ' ' ) apostrophy in the pwd field.
thanx once again to correct my mistake
with regards
coolminded.