D7 ADStoredproc and Win200
From: Gunnar Liknes (gliknesATglobalDASHsatcomDOTcom)
Date: 01/27/05
- Next message: Jerry: "Connection String for MySQL"
- Previous message: Dott. Cosimo De Michele: "Re: MSAccess Database protected with password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 27 Jan 2005 11:41:11 +0100
Hello,
I have a problem with running an ADOStoredProc on win2000
(it works fine on winXP). The Win2000 PC has MDAC 2.8.
The source code is:
(...)
SP:=TADOStoredProc.Create(self);
SP.AutoCalcFields:=false;
SP.CacheSize:=20;
SP.CommandTimeout:=120;
SP.Connection:=Mainform.ADOConnection1;
SP.CursorType:=ctStatic;
SP.ExecuteOptions:=SP.ExecuteOptions and eoAsyncFetchNonBlocking;}
SP.ProcedureName:='blSearchReservasjon;1';
SP.Parameters.CreateParameter('@ArrID', ftInteger, pdInput, 4,
Mainform.ArrID);
SP.Parameters.CreateParameter('@EID', ftInteger, pdInput, 4, EID);
SP.Parameters.CreateParameter('@TID', ftInteger, pdInput, 4, TID);
SP.Parameters.CreateParameter('@Before', ftDateTime, pdInput, 8,
Trunc(DateTimePicker2.Date) + 1);
SP.Parameters.CreateParameter('@After', ftDateTime, pdInput, 8,
Trunc(DateTimePicker1.Date));
SP.Parameters.CreateParameter('@SKR', ftInteger, pdInput, 4,
StrToInt(Edit3.Text));
SP.Parameters.CreateParameter('@RR', ftInteger, pdInput, 4,
StrToInt(ReservasjonEdit.Text));
SP.Parameters.CreateParameter('@BID', ftInteger, pdInput, 4,
StrToInt(Edit2.Text));
SP.Parameters.CreateParameter('@KundeID', ftInteger, pdInput, 4,
StrToInt(Edit1.Text));
SP.Parameters.CreateParameter('@Navn', ftString, pdInput, 35,
NoSpace(Edit5.Text));
SP.Parameters.CreateParameter('@Telefon', ftString, pdInput, 15,
NoSpace(Edit4.Text));
SP.Parameters.CreateParameter('@Email', ftString, pdInput, 50, '*');
if not Mainform.ADOConnection1.Connected then Mainform.ADOConnection1.Open;
SP.Open;
(...)
The Stored procedure parameters on the SQL server are int, datetime and
nvarchar.
It fails with a message saying "Bad Parameter Type" I do not have Delhpi
installed on
theWin2000 PC so I cant step through the code, thus I do not know exactly
where
it fails, but I suspect it is when setting the parameters.
I Hope someone has a good idea:-)
Thx
Gunnar
- Next message: Jerry: "Connection String for MySQL"
- Previous message: Dott. Cosimo De Michele: "Re: MSAccess Database protected with password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
