database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
ㆍPostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
PostgreSQL Files 3507 게시물 읽기
 News | Q&A | Columns | Tutorials | Devel | Files | Links
No. 3507
Visual Basic 에서 PostgreSQL 로 접근하기 위한 DLL
작성자
정재익(advance)
작성일
2001-10-15 23:08
조회수
4,910
첨부파일: libpgvbdll.zip (58,503bytes)

일본에서 만들어진 라이브러리 입니다. 원본의 Readme 파일을 첨부합니다. 참고하시기 바랍니다.

 

원본 출처 : http%3A%2F%2Fwww.vector.co.jp%2Fsoft%2Fwinnt%2Fprog%2Fse201375.html

 

hanmir 등등의 일한 번역 프로그램을 이용하여 보시면 편리하겠죠.

 

====================================================================

PostgreSQL Easy Access Tool Visual Basic Interface 1.0.1R

( ibpgvb.dll )

SOGA Project Group

http://hp.vector.co.jp/authors/VA023283/

mailto:sogapj@fb.freeserve.ne.jp

====================================================================

[Outline]

 

It is DLL which did PostgreSQL so that it could access it directly

and simply with VB, VBA from Windows, the client.

It can be used easily without using ODBC.

Complicated operation is a result because a target was narrowed

to the fundamental way of using it and made.

Instead of not here, it thinks that it can be programmed easily.

 

[Environment]

 

Movement with WindowsNT4, Windows2000 is confirmed.

Development environment is Windows-NT4-SP6a.

Office97, Office2000 or VisualBasic must be installed separately.

PostgreSQL Version is 7.1.3.

 

[Precaution]

 

Put this DLL on the place where path passed.

It doesn't care even about the place of EXE to move when it is

being used only with VB.갃

It doesn't care even under Program Files\Microsoft Ofiice\Office

when it is being used only with the Office tool.

The bottom of Winnt\System32 is probably the best when it wants

to use it without being conscious.

 

[How to use it]

 

<Interface> VB, VBA commonness

*Refer to sample coding for the details.

(VisualBasic Source Code =PGtest.vbp , Excel Macro Source Code =PGDBget.xls)

 

1.Login

VBPGlogin(ByVal Palam As String) As Long

[Return value] 0:Normality 9:Wrong point

It is given to it like "host=xxx user=xxx password=xxx" in the textbook.

*It is based on the interface of PGconnect.

 

2.SQL practice

VBPGexec(ByVal Palam As String, ByVal Rtn As String) As Long

[Return value] 0:Normality 9:Wrong point

A SQL command is delivered in the textbook.

Be careful of the result because 81920 bytes become MAXs.

 

3.Cursor practice

VBPGcursor(ByVal Palam As String) As Long

[Return value] 0:Normality 9:Wrong point

A SQL command is delivered in the textbook.

 

4.Fetch Next

VBPGfetch(ByVal Rtn As String) As Long

[Return value] 0:Normality 1:EOF 9:Wrong point

Be careful of the result because 81920 bytes become MAXs.

 

5.The list of the field name toward

the SQL extraction right before the front is acquired.

VBPGfnames(ByVal Rtn As String) As Long

[Return value] 0:Normality 9:Wrong point

The stop of the field name is TAB (0x09).The final is CRLF (0x0d0a).

 

6.A designated position field name toward

the SQL extraction right before the front is acquired.

VBPGfname(ByVal Palam As Long, ByVal Rtn As String) As Long

[Return value] 0:Normality 9:Wrong point

 

7.The value of the designated position toward

the SQL extraction right before the front is acquired.

VBPGvalue(ByVal Palam As Long, ByVal Rtn As String) As Long

[Return value] 0:Normality 9:Wrong point

 

8.The acquisition of the error message of

the SQL practice right before the front is done.

VBPGmsgget(ByVal Rtn As String) As Long

[Return value] 0:Normality

 

9.Close of the connection is done.

VBPGclose() As Long

[Return value] 0:Normality

 

10.The status of the SQL command right before the front

is acquired.

VBPGstatus() As Long

[Return value] Status value

 

11.Field stop character is set up. a (change)

VBPGdlim(ByVal Palam As Byte) As Long

[Return value] 0:Normality 9:Wrong point

 

[Revision personal history]

 

2001.07.09 The first edition (1.0.0) release

2001.07.11 The explanation of VBPGdlim() is added.

2001.08.20 Version 7.1.3 released.

 

[Others]

Server (postgres) for the Windows-Native development

is introduced to the public, too.

Use it for this opportunity by all means.

http://hp.vector.co.jp/authors/VA023283/

 

====================================================================

Copyright(C) 1999-2001 SOGA Telecom Project Group

H.saito(sogapj@fb.freeserve.ne.jp)

I.Fukuhara(ichiro@ichiro.org)

[Top]
No.
제목
작성자
작성일
조회
3512PostgreSQL 7.1.3 for M$ Windows
정재익
2001-10-15
4544
3511win32 pgsql module for PHP 4.0.6 for windows
정재익
2001-10-15
3862
3510Delphi 에서 PostgreSQL 로 접근하기 위한 Component
정재익
2001-10-15
4167
3507Visual Basic 에서 PostgreSQL 로 접근하기 위한 DLL
정재익
2001-10-15
4910
3488psqlodbc-07_01_0007
송정훈
2001-10-11
3929
3425성준이의 MySQL2Pgsql Converter 0.1(Beta)
조성준
2001-09-21
3986
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2022 DSN, All rights reserved.
작업시간: 0.035초, 이곳 서비스는
	PostgreSQL v13.3으로 자료를 관리합니다