From: | Jonathan Byrd <jonathan(dot)d(dot)byrd(at)live(dot)com> |
---|---|
To: | William Hoffmann <william(dot)hoffmann(at)insighteng(dot)net>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: connecting to postgres database |
Date: | 2019-01-09 20:46:02 |
Message-ID: | MWHPR11MB1982DBD797B2930264BD7CDAD38B0@MWHPR11MB1982.namprd11.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
looks good, you’re missing username/password but i don’t think that’s it. Have you tried going into the Windows ODBC Manager and creating a DSN and testing the DB connection?
Sent with Outlook<https://aka.ms/qtex0l> for iOS
________________________________
From: William Hoffmann <william(dot)hoffmann(at)insighteng(dot)net>
Sent: Wednesday, January 9, 2019 15:34
To: pgsql-odbc(at)postgresql(dot)org
Subject: connecting to postgres database
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kaleb Akalework | 2019-01-14 15:24:50 | Is psqlodbc_11_00_0000-x64 supported against PostgreSQL 10.06 |
Previous Message | William Hoffmann | 2019-01-09 16:54:03 | connecting to postgres database |