Re: Help; if possible

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.