errors on MS SQL 2000 with ADOCommand

Article View: borland.public.cppbuilder.database.ado

Article #1470

Back to borland.public.cppbuilder.database.ado Previous Next

#1470

From: James Peterson
Date: Mon, 28 Jun 2004 14:43

19 lines
1362 bytes

Project convert.exe raised exception class EOleException with message
'[Microsoft][ODBC SQL Server Driver] Optional feature not implimented'. when
i run the program using

ADOCommand1->CommandText"insert into data(fields)values(data)";
ADOCommand1->Execute();

I do have an AutoIncrementing field.
create Table Data (
[RecNumber] [int] IDENTITY(1,1),
ItemNumber Char(30),
ItemDescription Char(60)
.
.
.
Primary key(RecNumber))

I am guessing ADOCommand is crashing on the AutoInc field. how can I correct
this?

Technical Details

Message-ID: <40e02e27@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,36e0384e4110dcd8,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "James Peterson" <jpeterson@romanmealmilling.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: errors on MS SQL 2000 with ADOCommand
Date: Mon, 28 Jun 2004 09:43:30 -0500
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 64.21.236.129
Message-ID: <40e02e27@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1088433703 64.21.236.129 (28 Jun 2004 07:41:43 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail