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=10.24.0.218;port=5432;database=bd_vacunas;uid=postgres;pwd=vacunas;"
cn.Open()

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?

Thanks

0
edit delete
are you sure?
asked Rober Dantes

0 answers

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions