Error on Connection String, Visual Studio to PostgreSQL

Hi, I'm trying to send data from a Visual Studio application to a PostgreSQL database,I established the next statement to do the connection:

Dim cn As New ADODB.Connection
cn.ConnectionString = "driver = {Devart ODBC driver for PostgreSQL};server=;port=5432;database=bd_vacunas;uid=postgres;pwd=vacunas;"

The driver I'm using to establish an ODBC data source is "Devart ODBC driver for PostgreSQL", but when I run the application I get the following error:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I've already changed the parameter of driver by "PostgreSQL" and of server by "localhost" in the connection string but I get the same result. What is wrong in the connection string?


0 answers