Writing Code
 Crystal Reports Forum : Crystal Reports .NET 2003 : Writing Code
Message Icon Topic: ?? Sample ASP.NET to maintain a small DB2 table Post Reply Post New Topic
Author Message
peter
Groupie
Groupie


Joined: 08 Apr 2007
Location: United States
Online Status: Offline
Posts: 51
Quote peter Replybullet Topic: ?? Sample ASP.NET to maintain a small DB2 table
    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.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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.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>
IP IP Logged
peter
Groupie
Groupie


Joined: 08 Apr 2007
Location: United States
Online Status: Offline
Posts: 51
Quote peter Replybullet 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.
 
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.