Re: usage of ODBC
Date: Thu, 24 Mar 1994 10:24:00
Message-ID: <dil.admin.475.000A66BE_at_mhs.unc.edu>
>Chip Charnley (ccharnle_at_ef0424.efhd.ford.com) wrote:
>>> T:{IP address}/1525:oracle:1024
>Hey thanks guys! I've been trying to connect to Oracle with ODBC/Visual
>Basic
>for several days with no luck. I added /1525 after the IP address and
>BAM!, I'm
>in there! One problem: I can't write (insert, update) to the Oracle
>database
>from VB, just read. I tried connecting with Access - same result.
>Hmmmm...
>Ok, let me try to write a record with SQL*Plus - it works! Same account,
>same
>machine. What gives? Don't tell me I only have read access to Oracle
>tables
>from VB or Access. This would truly S*ck. Anyone have a clue?
>Thanks in advance.
>-Scott Feldman
Tru using DB_SQLPASSTHROUGH option and pass the Oracle update commadn to the
Oracle server. This works fine with Sybase. Also you might consider sotring a
static query on the server as a stored procedure and call it with
DB_SQLPASSTHROUGH and pass query parameters into stored procedure. This is
much faster than straight ODBC.
Thx Dave L Received on Thu Mar 24 1994 - 10:24:00 CET