cobain nih bro..

strSQL = Driver={PostgreSQL ANSI}; Server=localhost; PORT=5432; " _ 
      & "Database=" & gstrPGDB & "; UID=user; PWD=pass"
debug.print strSQL
connPG.Open strSQL  ' <----- tambahkan break point disini dan cek nama 
databasenya, dan cek juga isi strSQL nya
...
Set rsCoba = New ADODB.Recordset 'file testing
rsCoba.Cursorlocation = adUseServer
strSQL = "SELECT * FROM public.practice"
rsCoba.Open strSQL, connPG, adOpenStatic, adLockPessimistic
debug.print "rsCoba.EOF = " & rsCoba.EOF
debug.print rsCoba.Fields!address1

semoga bisa membantu,

http://gurningsoft.org

Dian Rahmadi <[EMAIL PROTECTED]> wrote:                               ,_._,___  
                Dear VB Mania ...
 
 Mohon pencerahan nih...gimana caranya koneksi database PostgreSQL via VB.
 
 Trim's untuk bantuannya.
 
 ---------------------------------
 Bergabunglah dengan orang-orang yang berwawasan, di bidang Anda di Yahoo! 
Answers
 
 [Non-text portions of this message have been removed]
 
 
     
                               

 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]

Kirim email ke