connecting to postgres database

From: William Hoffmann <william(dot)hoffmann(at)insighteng(dot)net>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: connecting to postgres database
Date: 2019-01-09 16:54:03
Message-ID: BYAPR13MB255056A0837FD440CAE24567FF8B0@BYAPR13MB2550.namprd13.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Sir,ma'am,

I am writing an application in vb2010 Visual basic express and am having issue with the data base connection for Postgres. I have installed the driver but haven't been able to get the connection to work. Please advise.

Imports System.Data.Odbc

Dim MyCon As New Odbc.OdbcConnection
MyCon.ConnectionString = "Driver={PostgreSQL ANSI};database=fgsms_performance;server=127.0.0.1;port=5432;"
MyCon.Open()

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

Respectfully,
William Hoffmann
2604336018

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Jonathan Byrd 2019-01-09 20:46:02 Re: connecting to postgres database
Previous Message Vikram Rakhe 2019-01-03 06:44:45 Performance Issue with bulk Insert of Rows to Temp Table