MSSQL & Delphi & ADO

Article View: borland.public.delphi.database

Article #239

Back to borland.public.delphi.database Previous Next

#239

From: Valentin Lisetsky
Date: Mon, 17 Jun 2002 06:06

23 lines
2143 bytes

Hi.
I'm using Delphi 6 & MSSQL2K, and i have  problem with executing
stored procedure app_ins_mat.
Parameters:
@PID  UNIQUEIDENTIFIER, @Param_1 varchar (100), @Param_2 nvarchar (100),
@Param_3 nvarchar (100), @Param_4 nvarchar (100),
@Param_5 varchar (256), @Param_6 text, @Param_7 ntext, @Param_8 ntext,
@Param_9 ntext

In Delphi i'm using TADODataset:

 DM.ADOMatIns.Parameters.ParamByName('@Param_1').Value:='f';
 DM.ADOMatIns.Parameters.ParamByName('@Param_2').Value:='f';
 .........
 DM.ADOMatIns.Parameters.ParamByName('@Param_9').Value:='f';

DM - Datamodule, ADOMatIns - TADODataSet.
When i'm calling DM.ADOMatIns.active:=true; i'm always getting an error:
Project blablabla.exe raised exception class EOleException with message 'OLE
Error 80040E14'. Process stoped.Use Step Or Run to continue. I think that
here can be problem with NText parameter because i never get such errors
before. (When i'm running thisz stored procedure from Query Analyzer
everything is going ok). Can anyone help me?

Technical Details

Message-ID: <aejuvn$2218$1@bn.utel.com.ua>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!yellow.newsread.com!netaxs.com!newsread.com!priapus.visi.com!news-out.visi.com!hermes.visi.com!news.tele.dk!small.news.tele.dk!212.74.64.35!colt.net!newspeer.clara.net!news.clara.net!image.surnet.ru!surnet.ru!carrier.kiev.ua!bn.utel.com.ua!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115d96,77345eb77cfa42b4,start
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2002-06-16 23:18:33 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!yellow.newsread.com!netaxs.com!newsread.com!priapus.visi.com!news-out.visi.com!hermes.visi.com!news.tele.dk!small.news.tele.dk!212.74.64.35!colt.net!newspeer.clara.net!news.clara.net!image.surnet.ru!surnet.ru!carrier.kiev.ua!bn.utel.com.ua!not-for-mail
From: "Valentin Lisetsky" <vlis@pronetswiss.com>
Newsgroups: borland.public.delphi.database
Subject: MSSQL & Delphi & ADO
Date: Mon, 17 Jun 2002 09:06:04 +0300
Organization: Utel
Lines: 25
Message-ID: <aejuvn$2218$1@bn.utel.com.ua>
NNTP-Posting-Host: dialer1-126.utel.net.ua
X-Trace: bn.utel.com.ua 1024294711 67624 212.113.38.126 (17 Jun 2002 06:18:31 GMT)
X-Complaints-To: postmaster@utel.net.ua
NNTP-Posting-Date: 17 Jun 2002 06:18:31 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2462.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2462.0000