Re: Help; if possible

On 17/11/2020 12:29 p.m., Nasir Mahmood wrote:
> 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(at)cleartagsoftware(dot)com

Fast. Accurate. Easy.