Visual Basic&database, ODBC/VB4 Update Oracle Table

Grace Walle
#1 / 4

ODBC/VB4 Update Oracle Table

I am unable to update an Oracle table that is attached to my Jet/VB4
database via ODBC. The Oracle userid I specify owns the table and
the password is correct. I can read the table, but not update it.
I get Run-time error '3027' -- Can't update: Database or object is
read-only. Can anyone help ? Email would be appreciated.
--
Thanks,
Grace Wallen The Boeing Company
TELE: 206-234-1802 FAX: 206-234-2820

Sun, 07 Nov 1999 03:00:00 GMT

Zuehlsdo
#2 / 4

ODBC/VB4 Update Oracle Table

Make sure that the Oracle Table has an unique index.

Other ways are RDO or "Oracle Objects for OLE 2.1" ( which I use ).

Roger

http://members.aol.com/zuehldorf/index.html

Tue, 09 Nov 1999 03:00:00 GMT

Hwakyung Ki
#3 / 4

ODBC/VB4 Update Oracle Table

Hi,
I wanna access local personal oracle7 database in VB4.
But, I have no idea how to connect to local oracle7.

In my opinion, I have to access by ODBC, SQL$NET,
But, I dont know how to setup the configuration files.

Thank you.

Sun, 14 Nov 1999 03:00:00 GMT

Robert T. Bunc
#4 / 4

ODBC/VB4 Update Oracle Table

Quote:

> Hi,
> I wanna access local personal oracle7 database in VB4.
> But, I have no idea how to connect to local oracle7.

> In my opinion, I have to access by ODBC, SQL$NET,
> But, I dont know how to setup the configuration files.

> Thank you.

Look at your SQL*Net configuration -- you should have a connection
called beq-local. This connects to your local database.

Put a Data Control down, and give it these properties:

Connect = "ODBC;DSN=beq-local;UID=scott;PWD=tiger;"
RecordsetType = 1 'Dynaset
RecordSource = "select * from table_name"

Put a text field down, and give it this property:

DataSource = "Data1"
DataField = "column_name" 'colunn_name from the above query

Run it, and you should be able to navigate your way through the table...

Fri, 19 Nov 1999 03:00:00 GMT