PDA

View Full Version : Visual Basic and PostgreSql

dblinux
05-06-02, 09:45
How can i attain the lists off database in my PostgreSql Server from Visual Basic programm.

Thanks, Dblinux
eperich
05-06-02, 11:18
I don't know exactly the VB connection params but maybe you go to

pgadmin (http://pgadmin.postgresql.org)

this tool is written in VB and there you can look into the source code
lander
05-18-02, 16:22
There is a project port of postgresql to native windows binary files. In this page:

http://hp.vector.co.jp/authors/VA023283/PostgreSQLe.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.
vududoc
05-21-02, 20:24
The following reference shows how to connect VB via ODBC/ADO

http://archives.postgresql.org/pgsql-odbc/2001-05/msg00013.php
loquin
01-10-06, 19:41
For a DSN-less connection (my preference) ref

http://www.xtremevbtalk.com/showpost.php?p=947221&postcount=17

Then, you would want to query the pg_tables view in the pg_catalog schema.
postgreg
09-29-07, 08:42
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...
amthomas
10-01-07, 11:59
For .NET there is NpgSQL.

http://npgsql.projects.postgresql.org/docs/manual/UserManual.htm

Good luck.
loquin
10-01-07, 18:14
Use ADO with VB6.

Ref this ADO tutorial (http://www.xtremevbtalk.com/showthread.php?t=66994) 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.
postgreg
10-01-07, 20:54
yes...
thank you...
i know now how to connect...
using a windows based postgreSQL...
very much thank you...
thank you all...