How to test an ODBC Connection to the embedded H2 Docs Database

Pulse Pulse Questions
1

Hello ,
We managed to connect to the embedded H2 docs base using the following url [http://localhost:8090] into the local server .

We want to use this connection on a PA process via the ODBC connection below

image
image593×575 22 KB

Oddly we have the errors below when we test this odbc connection on Architect :

"Echec de l’instruction SQL "
Do you have an idea how we can test this ODBC connection?

Did we make an error in the ODBC configuration?

Kind Regards

2

Hi @yamen.loukil ,

You are not using the correct type of the database, it should look like this:

image
image731×599 86.3 KB

I can see from your screenshot that you are using SQListe3 but you should be using PostgreSQL.

Please follow the steps explained in this article:

Cheers,

Vincent

3

Thank You Vincent , it’s all OK now :slight_smile:
Kind regards.
Yamen