Has anyone accessed postgresql in linux from VB code

From: Minal <minalac(at)yes2etl(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Has anyone accessed postgresql in linux from VB code
Date: 2005-07-15 06:18:29
Message-ID: 42D75535.6010403@yes2etl.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Anoop Kumar 2005-07-15 09:48:58 Fix for the 'null value' bug
Previous Message Marko Ristola 2005-07-14 21:29:20 Re: Libpq driver: thread problem