connecting to postgres database

William Hoffmann <[email protected]> Wed, 9 Jan 2019 16:54:03 +0000

Newsgroups	gmane.comp.db.postgresql.odbc
Message-ID	<BYAPR13MB255056A0837FD440CAE24567FF8B0@BYAPR13MB2550.namprd13.prod.outlook.com>

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