Dear Sirs,
I want to access postgreSQL Database from VB2013
I installed the following
PSQLODBC.DLL - A library to talk to the PostgreSQL DBMS using ODBC.
Copyright (C) 1998 Insight Distribution Systems
Copyright (C) 1998 - 2020 The PostgreSQL Global Development Group
Multibyte support was added by Sankyo Unyu Service, (C) 2001.
Now, my following code giving error; which I can't understand what to do
************
Dim MyCon As New System.Data.Odbc.OdbcConnection
MyCon.ConnectionString = "Driver={PostgreSQL ANSI};database=database_name;server=127.0.0.1;port=5432;uid=postgres;sslmode=disable;readonly=0;protocol=7.4;User ID=postgres;password=password;"
MyCon.Open()
If mCon.State = ConnectionState.Open Then
MsgBox("Connected To PostGres", MsgBoxStyle.MsgBoxSetForeground)
End If
The above mCon giving following error
************
mCon not declared; please guide,
or any example, how to access postgre sql from vb2013 or VB
Regards
Nasir Mahmood
Lahore - Pakistan