postgresql - vb6如何连接到postgresql数据库？

Question

如何将VB6连接到Postgresql数据库？有没有人可以帮我解决这个问题？请帮忙。非常感谢。

Answer 1

引用 ADO 2.8:

Dim cn As ADODB.Connection 
Set cn = New ADODB.Connection 
cn.ConnectionString = "DRIVER={PostgreSQL Unicode};SERVER=ServerName;port=5432;DATABASE=Database;UID=userID;PWD=password"
'// You'll have to substitute "ServerName", "Database", "userID", and "password" 
cn.ConnectionTimeout = 10 
cn.Open