ASP and ADABAS D [Archive]

renniebeach

02-05-04, 21:27

I am trying to call a Stored proc using Microsoft ADO and the ADABAS ODBC driver.

But any call to any stored proc always returns the same
"Microsoft OLE DB Provider for ODBC Drivers" Error.

"[SOFTWARE AG][SQLOD32 DLL][ADABAS]Insert value list does not match column list;-1200 TOO FEW VALUES."

The Stored Proc is a simple test

---------------------------------------------
DBPROC ASP.maxentity (
OUT retVal FIXED(9));
/*
SQL (SELECT MAX(entity) into :retVal from "DBASYS"."ENTITY" );
-------------------------------------------------------------------------------

Any ideas on what is going on, or how to get around this would be greatly appreciated

rnealejr

02-08-04, 08:09

Post your code.

renniebeach

02-08-04, 18:58

Originally posted by rnealejr
Post your code.

Set Conn = CreateObject("ADODB.Connection")
Set cmd = CreateObject("ADODB.Command")

Conn.Open "FILE Name=" & Server.MapPath(Application("VirtRoot") & "dbconfig/adabas.udl")

With cmd
.ActiveConnection = Conn
.CommandType = &H0001 'adCmdText
.CommandText = "PROC DBASYS.ASP.maxentity"
.Execute
End With

NOTE: the Error occurs on the Execute Call