VBcoders Guest



Don't have an account yet? Register
 


Forgot Password?



PostgreSQL, a mature database distribution that runs primarily on Linux/Unix distros has been porte

by Abdul Hafeel (3 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Wed 13th October 2004
Date Added: Mon 8th February 2021
Rating: (1 Votes)

PostgreSQL, a mature database distribution that runs primarily on Linux/Unix distros has been ported to Win32. The win32 port is still Beta.

API Declarations


Dim rs As ADODB.Recordset

Rate PostgreSQL, a mature database distribution that runs primarily on Linux/Unix distros has been porte



Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.CursorLocation = adUseClient
conn.ConnectionString = "Driver=PostgreSQL;Server=127.0.0.1;Port=5432;User Id=postgres;Password=pascal;Database=test;"
conn.Open
Set rs = conn.Execute("select * from testtable1")
End Function
Private Sub Command1_Click()
Call connectpgsql
Set DataGrid1.DataSource = rs
End Sub


Download this snippet    Add to My Saved Code

PostgreSQL, a mature database distribution that runs primarily on Linux/Unix distros has been porte Comments

No comments have been posted about PostgreSQL, a mature database distribution that runs primarily on Linux/Unix distros has been porte. Why not be the first to post a comment about PostgreSQL, a mature database distribution that runs primarily on Linux/Unix distros has been porte.

Post your comment

Subject:
Message:
0/1000 characters