I succeeded in connecting my vb application to a postgres db , I used this
code to connect
Dim MyConn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim MySQL As String
Dim rec_count As Long
MyConn.Open "DSN=PostgreSQL", "Mondi", "1234"
Set rs = New ADODB.Recordset
rs.Open "select * from userinfo;", Myconn, adOpenDynamic
then I use the Myconn.execute to execute some sql querries
Heres the prob:
- I don't know how to navigate thru the recordset
- rs.recordcount does not work
- only rs.movenext work
- when the table is empty or when you use movenext and there are no more
entries it creates an error msg : " runtime error 3021 either bof or eof
is true or the current record is deleted requested operation requires a
current record"
* I have read the tutorial on connecting visual basic to psqlODBC but the
codes there don't work.... :(
can anyone help me .... thx