From: | Wolfgang Fürtbauer <w(dot)fuertbauer(at)eunet(dot)at> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Problems with Visual Basic |
Date: | 2002-01-15 05:39:51 |
Message-ID: | 5.1.0.14.0.20020115062248.00a08820@pop-29.austria.eu.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
found a Problem with the following configuration; can you help please?
ODBC-Driver-Version:
7.1.007
Database-Version:
7.1.3 on Linux 2.4.4-4GB (root(at)Pentium(dot)suse(dot)de) (gcc version
2.95.3 20010315 (SuSE))
Visual Basic:
6 SP 5
Data Access Method:
DAO (.. i know; but I have/want to convert a *large* project)
The Code:
Set myWs = CreateWorkspace("FAKTODBC", "Admin", "", dbUseODBC)
Workspaces.Append myWs
Set myDB = myWs.OpenDatabase("fakt32", dbDriverNoPrompt, False,
"ODBC;dsn=PostgreSQL;uid=postgres;pwd=;")
Set gRsK = OpenRs(DYN, "Select * from " & TB_KENN)
With gRsK
.AddNew
.Update
End With
openrecordset only creates recordset's that are *not* updateable
.addnew gives an Error-Message: 3027 ... Database or object is
readonly
---------------------------------------------------------------------
Wolfgang Fürtbauer Tel: +43 7612 77620
Steinbichlstrasse 58d w(dot)fuertbauer(at)eunet(dot)at
A-4812 Pinsdorf
From | Date | Subject | |
---|---|---|---|
Next Message | cnliou | 2002-01-15 06:05:56 | Re: Error Writing/Reading Encrypted Values |
Previous Message | Hiroshi Inoue | 2002-01-15 04:34:51 | Re: Rep:Re: Error Writing/Reading Encrypted Values |