Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: ASP and ADABAS D

    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

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Post your code.
    If you do not have SQL Server Books Online (BOL) installed - please do so. The majority of questions asked in the SQL Server forum could be eliminated if people had access to bol. BOL

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •