Thanks to everyone who provided a possible solution. I appreciate the comments.
Happy holidays!
/b;
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard Schoen
Sent: Monday, December 17, 2012 6:20 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Alternatives to ODBC Connections
These would only monopolize CPU usage if you have a lot of HEAVY sql going on. Otherwise they may sit open as connections if you haven't closed the. Should look into the OLEDB or iSeries Access .Net drivers. Make sure to install V6R1 or V7R1 versions.
Also it looks like you're using some old style connection objects, May want to consider ODBCConnection and ODBCReaders.
Another option would be to try the open source XMLSERVICE program from the Yips site or JT400.jar converted to .Net, but they will all still use DB connections of some sort.
Another cool option is to write a little RPG CGI program to provide resultsets from the iSeries in XML or JSON that an ASP.Net app can consume.
Lots of options.
Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site:
http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
----------------------------------------------------------------------
message: 1
date: Mon, 17 Dec 2012 15:08:51 -0500
from: Brian Piotrowski <bpiotrowski@xxxxxxxxxxxxxxx>
subject: Alternatives to ODBC Connections
Hi All,
Does anyone know if there are any alternatives to an ODBC connection through ASP code or a dot.net program? We're noticing an increased problem with our programs and the dreaded QZDASOINIT job (many of them!) monopolizing the CPU usage quite often.
Right now most of the programs use code similar to this:
Set adoCon400 = Server.CreateObject("ADODB.Connection")
adoCon.Open "Provider=IBMDA400.DataSource.1;Persist Security Info=False;User ID=<Ourid>;Password=<ourpassword>;Data Source=<ourAS400>"
Set recordset = Server.CreateObject("ADODB.Recordset")
strSQL = "<our SQL statement>"
recordset.open strSQL, adoCon400
....do something with the results....
Recordset.close
Set recordset = nothing
That might have been fine and dandy when we didn't have many web applications, but now we have a lot more web applications running through IIS (Server 2008R2 64bit) and it appears to impact the system's performance.
Any helpful ideas or advice would be most appreciated.
Thankee-sai!
/b;
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Brian Piotrowski
Manager - I.T.
Simcoe Parts Service, Inc.
Ph: 705-435-7814 x343
Fx: 705-435-5029
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
http://www.simcoeparts.com<
http://www.simcoeparts.com/>
Please consider the environment. Don't print this e-mail unless you really need to.
The information contained in this communication is confidential and intended only for the use of those to whom it is addressed. If you have received this communication in error, please notify me by telephone (collect if necessary) and delete or destroy any copies of it. Thank you!
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
