Print Page | Close Window

?? Sample ASP.NET to maintain a small DB2 table

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Writing Code
Forum Discription: .NET 2003 programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=583
Printed Date: 03 May 2024 at 12:50pm


Topic: ?? Sample ASP.NET to maintain a small DB2 table
Posted By: peter
Subject: ?? Sample ASP.NET to maintain a small DB2 table
Date Posted: 25 Apr 2007 at 3:26pm
Hi,
Any one has sample ASP.NET application to maintain a small DB2 table such as Insert,Delete,Update.


Replies:
Posted By: BrianBischof
Date Posted: 25 Apr 2007 at 6:33pm
Sorry, I don't know anything about DB2. Here are a couple links though.

http://www.devx.com/ibm/Article/21127 - http://www.devx.com/ibm/Article/21127
http://www.carlprothman.net/Default.aspx?tabid=81 - http://www.carlprothman.net/Default.aspx?tabid=81



-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: peter
Date Posted: 25 Apr 2007 at 8:49pm
Brian,
Thank you for taking time to help me out. I'll look into those links.
For now, I have an urgent issue to resolve: I got this error:
"Query Engine error[IBM][IBM Driver] CLI0125E Function sequence error HY010" when I tried to connect to then same Data Soure for two tables in different schema.
It is lke this:
1) Write a new CR 10 report using the Designer Wizard.
2) Connect to  predefined data soure named "National_Cust" which connects to a DB2 database using ODBC to connect to table SchemaX.Customer thru a Stored Proc SP100. Insert fields to the report, preview and data displayed fine.
3) Connect to this same data source "National_Cust"  to connect to a table SchemaY.EMP. It is fine after connecting.
4) Insert a field from 2nd table onto the report.
5 Press Preview ---> got the error !!!!
 
Note: The connection to the data source is logged on using SchemaX (Id/Pw) for both tables.
 
Hope you can help me on this one.
 
 


Print Page | Close Window