Re: Insert Data on Oracle

Article View: borland.public.cppbuilder.database.multi-tier

Article #690

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#690

From: Jerry Bloomfield (TeamB)
Date: Thu, 26 Apr 2001 02:38

21 lines
1994 bytes

On Fri, 20 Apr 2001 13:21:50 -0500, "Nirmal Shrestha" <nirmals@flowcal.com>
wrote:

>It gives me an Oracle error, table does not exists. If I set
>Query->RequestLive = false; it prepares the SQL statement and Opens the
>table but do not lt me insert saying read only data set.
>
>It was working fine with MS Access database, and I am having problem trying
>to change it to access to Oracle database.

There are problems with the Oracle ODBC drivers (and there are also
problems with the Microsoft ODBC drivers for Oracle databases too).  Quite
often,  you can resolve your problems with the Oracle drivers by making
sure that you always use UPPERCASE in your SQL syntax,  especially when
referring to field and table names.

Jerry Bloomfield (TeamB)
-- 
http://www.teamb.com                                      JersWork@wwa.com
Please do *NOT* send private e-mail without prior permission (my anti-spam 
filters will probably just delete it anyway <g>)

Technical Details

Message-ID: <de2fetg50gpgtbme882j9i2jlvvesjqhlt@4ax.com>

Path:

arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out-sjo.usenetserver.com!newsfeed.gamma.ru!Gamma.RU!colt.net!news0.de.colt.net!blackbush.xlink.net!newsfeed01.sul.t-online.de!t-online.de!dnews

References: <3ae07d90_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,ee60ef244642fb7d
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-04-25 19:46:19 PST
From: "Jerry Bloomfield (TeamB)" <JersWork@wwa.com>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: Re: Insert Data on Oracle
Date: Wed, 25 Apr 2001 21:38:56 -0500
Organization: LSVFA - Latest Software Version Freaks Anonomous
Message-ID: <de2fetg50gpgtbme882j9i2jlvvesjqhlt@4ax.com>
References: <3ae07d90_1@dnews>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 157.238.73.57
X-Trace: dnews 988252688 157.238.73.57 (25 Apr 2001 19:38:08 -0700)
Lines: 21
X-Authenticated-User: jerswork
Path: arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out-sjo.usenetserver.com!newsfeed.gamma.ru!Gamma.RU!colt.net!news0.de.colt.net!blackbush.xlink.net!newsfeed01.sul.t-online.de!t-online.de!dnews

Reply to Parent Message