Skip site navigation (1) Skip section navigation (2)

Problems with Visual Basic

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 (view raw or flat)
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                         


Responses

pgsql-odbc by date

Next:From: cnliouDate: 2002-01-15 06:05:56
Subject: Re: Error Writing/Reading Encrypted Values
Previous:From: Hiroshi InoueDate: 2002-01-15 04:34:51
Subject: Re: Rep:Re: Error Writing/Reading Encrypted Values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group