Has anyone accessed postgresql in linux from VB code???
I have added the following code..
Dim MyDB As New ADODB.Connection
Dim Rc As New ADODB.Recordset
Private Sub Command1_Click()
MyDB.Provider = "PostgreSQL"
MyDB.CursorLocation = adUseClient
'MyDB.Open "Data Source=10.1.2.86;Location=trainneedcorp;'db_admin','admin'"
MyDB.Open "DRIVER={postgresql};DATABASE=trainneedcorp;Data
Source=10.1.2.86;PORT=5432;UID=db_admin;PWD=admin;"
End Sub
I am getting the error
"No postgresql username specified in startup package"
Minal