PDA

View Full Version : Error: 12305 when using "Send SQLSetArgument"



Visual Systems AB \(Martin Arvidsson\)
15-Mar-2006, 09:11 AM
Hi!

I'm getting an error 12305 when using the Send SQLSetArgument procedure.
Everything works just fine, until i set the parameters. I use Odbc version
2.2.
The MAX_ACTIVE_STATEMENTS is set to 0 (Zero)

My Stored proecedure is very simple, see below...

What could be wrong?

Regards
Martin

Code...

CREATE STORED PROCEDURE ChangeCustomerID (IN :NewCust INT, IN :OldCust INT);
Begin
Update Customers
Set Customers.ID = :NewCust
Where Customers.ID = :OldCust;
End;


Procedure OnClick
Handle hoSQLManager hdbc hstmt
Handle hoConnected

Object oSQLManager is a cSQLHandleManager
Move Self to hoSQLManager
end_object

Send SQLSetConnect of hoSQLManager "ODBC_DRV" "DSN=MarkBric10"
Get SQLConnect of hoSQLManager "" "" to hoConnected

// We have connection
if (hoConnected <> 0) begin
get SQLOpen of hoConnected to hstmt

// Connection to database was successfull
if (hstmt <> 0) begin
Send SQLSetProcedureName of hstmt "ChangeCustomerID"
Send SQLSetArgument of hstmt 1 "5" // New customer id
Send SQLSetArgument of hstmt 2 "3" // Old Customer ID

Send SQLCall of hstmt
send stop_box "We have lift off"

end
end
End_Procedure // OnClick

Ben Weijers
16-Mar-2006, 02:51 PM
What database are you using?

BTW, what is the reason you use 2.2 why not use a more recent version?

Regards,

Ben Weijers
Data Access Worldwide

Visual Systems AB \(Martin Arvidsson\)
17-Mar-2006, 04:13 AM
I am using P.SQL 8.5 and the reason is that i use 2.2 is because i hade the
understanding that the newer version is not supported for vdf 6.2 and also,
we have to upgrade 250 customers.

/Regards
Martin

"Ben Weijers" <Ben.Weijers@dataaccess.nl> skrev i meddelandet
news:lbXM%23LTSGHA.540@dacmail.dataaccess.com...
> What database are you using?
>
> BTW, what is the reason you use 2.2 why not use a more recent version?
>
> Regards,
>
> Ben Weijers
> Data Access Worldwide
>

Ben Weijers
17-Mar-2006, 02:25 PM
Nonsense!!!! Even our 4.x CK's can be used by every driver capable version
no matter how old. So you could use the newset CK with a VDF 4.0c.

It is just that VDF6 is no longer supported so we have never tested the new
CK's with it, OTOH 2.2 is not supported either so its in good company.

Regards,

Ben Weijers
Data Access Worldwide

Visual Systems AB \(Martin Arvidsson\)
20-Mar-2006, 04:24 AM
Ok then, my bad. But in the readme file it says that it only runs with VDF
8.x and higher.

But i will try it anyhow.

/Martin

"Ben Weijers" <Ben.Weijers@dataaccess.nl> skrev i meddelandet
news:R5inkifSGHA.1276@dacmail.dataaccess.com...
> Nonsense!!!! Even our 4.x CK's can be used by every driver capable version
> no matter how old. So you could use the newset CK with a VDF 4.0c.
>
> It is just that VDF6 is no longer supported so we have never tested the
> new CK's with it, OTOH 2.2 is not supported either so its in good company.
>
> Regards,
>
> Ben Weijers
> Data Access Worldwide
>

Ben Weijers
20-Mar-2006, 09:59 AM
The latest CK's are only supported with8.x and higher, there is a difference
between supported and "will not run". When an environment or combination of
products is not supported we do not test that particular
environment/combination of products. That does not mean it will not run!

Regards,

Ben Weijers
Data Access Worldwide

Holger W.
17-Aug-2006, 05:08 AM
Any Solution ?
Same with CK 4.

regards
Holger