On 17/11/2020 12:29 p.m., Nasir Mahmood wrote:
P {margin-top:0;margin-bottom:0;} 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
You've declared MyCon...
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
but it looks like you used mCon.State, not MyCon.State.
George
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
--
Cleartag Software, Inc.
972 McMillan Avenue
Winnipeg, MB
R3M 0V7
(204) 284-9839 phone/cell
(204) 284-9838 fax
gweaver@cleartagsoftware.com
Fast. Accurate. Easy.