From: | "DanPerlman" <dan(at)dpci(dot)us> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | ODBC in VB6 |
Date: | 2003-09-06 15:00:44 |
Message-ID: | 000a01c37487$a661cc60$0100005a@server |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
I have never used ODBC in a VB6 program before.
I am trying to write some simple code to append data from an access 2k table to a postgres table.
My DSN works with access.
I am getting a "type mismatch" error when trying to open the postgres db.
Thanks,
Dan
Private Sub CommandStart_Click()
Dim Pricebooks As Database
Dim Bonneville As Database
Dim WrkSpc As Workspace
Dim Apb As Recordset
Dim Bpb As Recordset
Dim i As Integer
'Open Access table.
Set Pricebooks = OpenDatabase(App.Path & "\Pricebooks.mdb")
Set Apb = Pricebooks.OpenRecordset("pricebook", dbOpenTable)
'Open Postgres table
Set Bonneville = OpenDatabase(Bonneville, False, "ODBC;DSN=PostgresSQL30;UID=postgres;PWD=postgres;")
Set Bpb = Bonneville.OpenRecordset(public_papricebook, dbOpenDynamic)
TextID.Text = Apb("pricebookid") & ""
TextID.Refresh
End Sub
From | Date | Subject | |
---|---|---|---|
Next Message | Rafi Einstein | 2003-09-08 16:36:33 | PostgreSQL ODBC modification request |
Previous Message | Brian Furey | 2003-09-06 14:08:49 | Date Formats |