Results 1 to 9 of 9
  1. #1
    Join Date
    May 2002
    Location
    Italy
    Posts
    36

    Unanswered: Visual Basic and PostgreSql

    How can i attain the lists off database in my PostgreSql Server from Visual Basic programm.

    Thanks, Dblinux

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    visual basic

    I don't know exactly the VB connection params but maybe you go to

    pgadmin

    this tool is written in VB and there you can look into the source code
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    May 2002
    Posts
    1
    There is a project port of postgresql to native windows binary files. In this page:

    http://hp.vector.co.jp/authors/VA023...stgreSQLe.html

    there is a link called libpgvb. It seems to be a vb library that allows access to postgresql from visual basic. Unfortunatelly, I think this link is to one page in japanese.

    Excuseme for my poor English, I hope help you.

  4. #4
    Join Date
    Jul 2001
    Location
    NC
    Posts
    102
    The following reference shows how to connect VB via ODBC/ADO

    http://archives.postgresql.org/pgsql...5/msg00013.php

  5. #5
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    For a DSN-less connection (my preference) ref

    http://www.xtremevbtalk.com/showpost...1&postcount=17

    Then, you would want to query the pg_tables view in the pg_catalog schema.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  6. #6
    Join Date
    Sep 2007
    Posts
    5
    ahm...im new with postgresql...
    may i ask if you have any tutorials upon connecting VB language to postgresql???
    if possible a step by step tutorial...
    thanks...this is really a big help for me...

  7. #7
    Join Date
    May 2005
    Location
    San Antonio, Texas
    Posts
    134
    For .NET there is NpgSQL.

    http://npgsql.projects.postgresql.or...UserManual.htm

    Good luck.

  8. #8
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Use ADO with VB6.

    Ref this ADO tutorial at a sister-site. It will help you get connected to the database, and to become more familiar with ADO.

    After you're connected, you can issue queries against the Information_Schema in PostgreSQL to list the databases, tables, views, columns, and other database objects. Take a look at the postgresql FAQ at the top of this forum.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  9. #9
    Join Date
    Sep 2007
    Posts
    5
    yes...
    thank you...
    i know now how to connect...
    using a windows based postgreSQL...
    very much thank you...
    thank you all...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •