How to connect to PostgreSQL from Visual Basic 6

Posted on 2009-02-12
Last Modified: 2012-05-06
How can i connect to PostgreSQL from Visual Basic 6?   I mean other way than ODBC.
Question by:Cristi_E
    1 Comment
    LVL 3

    Accepted Solution

    Have you tried OLE DB?
    Heres a string and a couple threads with some good VB6 info.

    Wish I still had VB6 to test it for ya(.net FTW).
    Const strPG As String = "Provider=PostgreSQL OLE DB Provider;Password=YourPassword;User ID=UserName;Data Source=localhost;Location=DefaultDatabaseName"

    Open in new window


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Introduction In a recent article ( for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
    I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now