Where to get the iSeries ADO.NET data provider
The iSeries .NET data provider is the native data provider that allows you to access iSeries data and programs using .NET in a managed way.
This is a .dll (IBM.Data.DB2.iSeries.dll ) that you add in as a reference when creating .Net apps to connect to the iSeries
Once added in you have access to all the classes and methods that simplify writing applications in .Net to leverage iSeries data in the db2 database
The dll is part of iSerices Access for windows which you can download for free (when you select the technology preview). Make sure you check 'Selective Setup' and include the Data and Programmer's toolkit so you get all the data access drivers, help and tools.
- Download iSeries Access from http://www-03.ibm.com/systems/i/software/access/windows/downloads.html
Select the technology preview version. You'll have do the register rigmarole.
If the link doesn't work, google 'iSeries Access windows' to find the latest location. - Install iSeries Access making sure that you select 'custom install' to include the programmers toolkit (it comes in handy as it has examples etc.) . Once you have installed iSeries Access you will find the dll in C:\Program Files\IBM\Client Access\IBM.Data.DB2.iSeries.dll
- In Visual Studio, open up your project. Click on the Solution Explorer, then references. Right click references and select 'Add Reference'. A dialog box appears. Click 'Browse'. Add in the dll from the location above.
- Add the namespace '
using IBM.Data.DB2.iSeries;' to your code - Start using the iSeries classes! The iDB2Command is what you use to run queries, IDB2Connection to create a connection string to your iSeries db, iDB2DataAdapter gives you a cache to both connect, retrieve and update a set of data.
With the native .NET provider you have support for:
- SQL (INSERT, UPDATE, DELETE, SELECT)
- Stored procedure support
- Commitment control
- Connection pooling
- SQL naming,Unicode, Threads and multiple databases (IASPs)
To call iSeries programs use a stored procedure.
Labels: .net, .net data provider, C#, db2, iseries, iseries access, iSeries Access for Windows
31 Comments:
Good stuff, Colm. I've been using the iSeries .NET provider for a while, now I need to use it to call an iSeries procedure... haven't had luck yet.
What problems are you having with calling a procedure?
Do you mean a stored procedure or an RPG procedure?
C
Hi Colm,
I am unable to find the Technology Preview version you say, and in the IBM web page is all a lot confusiong and i can´t find the direct link to download the System i Access for Windows...
By the way ¿can i use this software with windows mobile and .net compact framework?
thank you very much
Dear Sir
Thanks for your article. It was helpful
dataqueues not supported
It is an amazing post.Very useful to me.I liked it .Take a look to my blog Professional Dot Net Training in Chennai
Excellent blog and it’s totally loaded with valid posts on Java and .Net technology. Consider including RSS feed in your blog, so aspirants like me can follow your blog easily. .Net Training in Chennai|Best DOT NET Training institute in Chennai|DOT NET Training Chennai
I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.
Best Python training Institute in chennai
nice. dot net training in Chennai
Nice Article. I impressed a lot..
.NET Training in Chennai
A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article. I am learning a lot from you.
Devops Training in Chennai
Devops Training in Bangalore
The site was so nice, I found out about a lot of great things. I like the way you make your blog posts. Keep up the good work and may you gain success in the long run.
Blueprism training in tambaram
Blueprism training in annanagar
Blueprism training in velachery
I appreciate your efforts because it conveys the message of what you are trying to say. It's a great skill to make even the person who doesn't know about the subject could able to understand the subject . Your blogs are understandable and also elaborately described. I hope to read more and more interesting articles from your blog. All the best.
Data Science training in kalyan nagar | Data Science training in OMR
Data Science training in chennai | Data science training in velachery
Data science online training
Appreciating the persistence you put into your blog and detailed information you provide
angularjs Training in chennai
angularjs-Training in pune
angularjs-Training in chennai
angularjs Training in chennai
angularjs-Training in tambaram
Thank you for benefiting from time to focus on this kind of, I feel firmly about it and also really like comprehending far more with this particular subject matter. In case doable, when you get know-how, is it possible to thoughts modernizing your site together with far more details? It’s extremely useful to me.
python training in rajajinagar | Python training in bangalore | Python training in usa
This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
Java training in Chennai | Java training institute in Chennai | Java course in Chennai
Java training in USA
Java training in Bangalore | Java training in Indira nagar
Java training in Bangalore | Java training in Rajaji nagar
Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us
Data Science Training in Chennai | Data Science Training institute in Chennai
Data Science course in anna nagar
Data Science course in chennai | Data Science Training institute in Chennai | Best Data Science Training in Chennai
Data science course in Bangalore | Data Science Training institute in Bangalore | Best Data Science Training in Bangalore
Data Science course in marathahalli | Data Science training in Bangalore
I really appreciate this post. I’ve been looking all over for this! Thank goodness I found it on Bing. You’ve made my day! Thx again!
aws Training in indira nagar
selenium Training in indira nagar
python Training in indira nagar
datascience Training in indira nagar
devops Training in indira nagar
Great Post!....Keep Sharing more like this
Python Training in Chennai
Selenium Training in Chennai
Data Science Training in Chennai
AWS Training in Chennai
FSD Training in Chennai
MEAN Stack Training in Chennai
You have posted a worthy blog keep sharing. Nice article I was really impressed by seeing this article, it was very interesting and it is very useful for me.
Best IELTS Classes in Mulund
IELTS Centres in Mulund East
IELTS Coaching Classes in Mulund
IELTS Training in Mulund
IELTS Coaching Centres in Mulund
Best IELTS Course in Mulund West
IELTS Training Institute near me
Thanks for giving great kind of information. So useful and practical for me. Thanks for your excellent blog, nice work keep it up thanks for sharing the knowledge.
Devops Training in Chennai | Devops Training Institute in Chennai
Thanks for giving great kind of information. So useful and practical for me. Thanks for your excellent blog, nice work keep it up thanks for sharing the knowledge.
Devops Training in Chennai | Devops Training Institute in Chennai
NICE......
Free Inplant Training Course For ECE Students
INTERNSHIP
INTERNSHIP FOR AERONAUTICAL ENGINERING STUDENTS IN INDIA
INTERNSHIP FOR CSE 3RD YEAR STUDENTS
Free Inplant Training Course for Mechanical Students
INTERNSHIP FOR ECE STUDENTS
INPLANT TRAINING FOR CIVIL
INTERNSHIP AT BSNL
INTERNSHIP FOR 2ND YEAR ECE STUDENTS
INTERNSHIP FOR AERONAUTICAL STUDENTS
this is most informative post..
COMPANY INTERVIEW QUESTIONS AND ANSWERS
HACK FLIPKART WALLET
DATA STRUCTURE
TYPE SCRIPT GETTING ERROR
APTITUDE NUMBERS
APACHE PIG COUNT FUNCTION
APTITUDE PROFIT AND LOSS
SUBMIT IS NOT A FUNCTION ERROR IN JAVASCRIPT
THE CP OF 15 BOOK IS EQUAL TO THE SP
WHAT NUMBER IS TO BE SUBTRACTED
very informative post..
Inplant Training in Chennai
Iot Internship
Internship in Chennai for CSE
Internship in Chennai
Python Internship in Chennai
Implant Training in Chennai
Android Training in Chennai
R Programming Training in Chennai
Python Internship
Internship in chennai for EEE
nice post...
Crome://Flags
Python Programming Questions and Answers PDF
Qdxm Sfyn Uioz
How To Hack Whatsapp Account Ethical Hacking
Power Bi Resume
Whatsapp Unblock Software
Tp Link Password Hack
The Simple Interest Earned On a Certain Amount Is Double
A Certain Sum Amounts To RS. 7000 in 2 years and to RS. 8000 in 3 Years. Find The Sum.
Zensoft Aptitude Questions
very nice....
inplant training in chennai
inplant training in chennai
inplant training in chennai for it
namibia web hosting
norway web hosting
rwanda web hosting
spain hosting
turkey web hosting
venezuela hosting
vietnam shared web hosting
nice...
internship in chennai for ece students
internships in chennai for cse students 2019
Inplant training in chennai
internship for eee students
free internship in chennai
eee internship in chennai
internship for ece students in chennai
inplant training in bangalore for cse
inplant training in bangalore
ccna training in chennai
Pleasantful blog.Keep going.
Java training in Chennai
Java training in Bangalore
Java training in Hyderabad
Java Training in Coimbatore
Java Online Training
Thanks for sharing a very nice information & it’s really very helpful for us. oracle training in chennai
Great post. keep sharing such a worthy information.
Blue Prism Training in Chennai
Blue Prism Online Training
Post a Comment
Subscribe to Post Comments [Atom]
<< Home