Hi

I found the error. The pgBouncer config file is case sensitive and I used "Host=" instead of "host=". Once I changed the value to lower case everything worked just fine.

Simon

>I'm not sure if this can be of any help, but to me it looks like you somehow need to explicitly specify the start DB for your connection (e.g. start researching from how to specify the default DB for the connection).
>
>>Hi
>>
>>Has anyone used pgBouncer with VFP9? I have been using Postgres for a few years now and everything works fine with VFP9. Today I thought I would try pgBouncer for connection pooling. However, no matter what I do using the SQLStringConnect() with pgBouncer it always tells me no such database. Yet the database does exist and is named correctly in the pgBouncer.ini file. So I wondering what is causing the error.
>>This is what I see in the pgBouncer log.
>>
>>

2020-07-13 15:30:09.551 Eastern Standard Time [9768] LOG process up: PgBouncer 1.12.0, libevent 2.0.21-stable (win32), adns: evdns2, tls: OpenSSL 1.1.1d  10 Sep 2019
>>2020-07-13 15:30:15.561 Eastern Standard Time [9768] LOG C-016D9FF0: (nodb)/(nouser)@127.0.0.1:55972 closing because: no such database: FusionPro (age=0s)
>>2020-07-13 15:30:15.562 Eastern Standard Time [9768] WARNING C-016D9FF0: (nodb)/(nouser)@127.0.0.1:55972 pooler error: no such database: FusionPro
>>2020-07-13 15:30:15.562 Eastern Standard Time [9768] LOG C-016D9FF0: (nodb)/(nouser)@127.0.0.1:55972 login failed: db=FusionPro user=yorkregion
>>2020-07-13 15:30:23.361 Eastern Standard Time [9768] LOG C-016D9FF0: (nodb)/(nouser)@127.0.0.1:55974 closing because: no such database: FusionPro (age=0s)
>>2020-07-13 15:30:23.364 Eastern Standard Time [9768] WARNING C-016D9FF0: (nodb)/(nouser)@127.0.0.1:55974 pooler error: no such database: FusionPro
>>2020-07-13 15:30:23.366 Eastern Standard Time [9768] LOG C-016D9FF0: (nodb)/(nouser)@127.0.0.1:55974 login failed: db=FusionPro user=yorkregion
>>2020-07-13 15:30:31.023 Eastern Standard Time [9768] LOG C-016D9FF0: (nodb)/(nouser)@127.0.0.1:55975 closing because: no such database: postgres (age=0s)
>>2020-07-13 15:30:31.024 Eastern Standard Time [9768] WARNING C-016D9FF0: (nodb)/(nouser)@127.0.0.1:55975 pooler error: no such database: postgres
>>2020-07-13 15:30:31.024 Eastern Standard Time [9768] LOG C-016D9FF0: (nodb)/(nouser)@127.0.0.1:55975 login failed: db=postgres user=posgtres

>>
>>Thanks,
>>Simon