IBM Support

Executing a stored procedure through a WebServer

Troubleshooting


Problem

Executing a stored procedure through ASP

Resolving The Problem


INTRODUCTION

This document tells you how to run a stored procedure on IBM Informix Dynamic Server using ASP.


BEFORE YOU BEGIN

  • The web server has to be running and support ASP files.
  • Create the stored procedure and tables needed for this test.

1. Use the dbaccessdemo7 script in the Informix Server installation to create the stores_demo database.

2. Copy and rename proc.sql.txt to proc.sql; placing in working directory on your computer where the Informix Server resides.


proc.sql.txt

3. Run dbaccess choosing the above SQL file from Query Language to create the stored procedure within the stores_demo database.


STEPS

1. Copy procedure.asp.txt, rename to procedure.asp.

procedure.asp.txt

2. Create an ODBC system data source to connect to the stores_demo database.

3. You will need to change the ODBC data source entry <REPLACE_ME> in the ASP file to the name of your ODBC system data source.

4. Use a web browser to run the ASP page.

[{"Product":{"code":"SSVT2J","label":"Informix Tools"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Informix Client Software Development Kit (CSDK)","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2.6;2.7;2.8;2.9","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 January 2022

UID

swg21137696