473,326 Members | 2,023 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Library of V5R2M0 iseries access for windows

Hi,

I'm using the V5R2M0 iseries access for windows version. I'm coding in c#.NET. But I can't find the library file for using the connection(), command(), etc methods.

Can anyone help me with this??

Thank's in advance,
Francisco Neto
Mar 3 '08 #1
3 2767
sakumar9
127 Expert 100+
Integration of DB2 and .Net framework ::::

Developing IBM Data Server Provider for .NET Applications
The IBM Data Server Provider for .NET provides functionality for connecting to a database, executing commands, and retrieving results. Those results can be processed directly, or placed in an ADO.NET DataSet for further processing while in a disconnected state. While in the DataSet, data can be exposed to the user, combined with other data from multiple sources, or passed remotely between tiers. Any processing performed on the data while in the DataSet can then be reconciled to the database.

To use the IBM Data Server Provider for .NET, you must add an imports or using statement for the IBM.Data.DB2 namespace to your application .DLL. For example:

[Visual Basic]
Imports IBM.Data.DB2
[C#]
using IBM.Data.DB2;You also must include a reference to IBM.Data.DB2.dll in your appication's project. In Visual Studio you can do this either from the References section for your project in the Solution Explorer, or from the Project > Add Reference menu option. If you are compiling a program from the command line for Framework 2.0 or 3.0, your csc or vbc commands should include the following option:

/r:"%DB2PATH%"\bin\netf20\IBM.Data.DB2.dllIf you are compiling a program from the command line for Framework 1.1, your csc or vbc commands should include the following option:

/r:"%DB2PATH%"\bin\netf11\IBM.Data.DB2.dll


Please ensure that your PATH is set to one of the dll(as per requirement) in DIR: C:\Program Files\IBM\SQLLIB\BIN\netf20
Before executing any command for interaction between IBM database and .Net

You could also install the Add-ons for VS.net shipped with DB2(Not sure if with all versions of DB2).

Commands for interaction between DB2 and .Net do have specific names- Please refer
https://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp
---search for IBM.Data.DB2.Namespace
--> Which has all commands/syntax supported by DB2 for .net applications

Could find the same with MSDN library.


Regards
-- Sanjay
Mar 4 '08 #2
sakumar9
127 Expert 100+
If you need any help on coding c# applications, then I would suggest you to check the samples present in SQLLIB/samples/.Net/cs.

Regards
-- Sanjay
Mar 4 '08 #3
Thank you for the very complete answer.

Thought, the main question resides on where could I find that file.
The problem in fact, is:

I have DB2 v6 installed. And I may connect through ODBC iseries access for windows V5R2M0. This is running and working.

Now, I would like to start developing some applications in c# .NET.

In this particular case, what would be the best solution?

Thank you for any kind of help you can give me,
Best Regards
Mar 5 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Thad Rizzi | last post by:
My webserver is an iSeries and I want to run some PHP scripts on it using SQL to access data on the iSeries. Does anyone have any exapmles or resources on the most effective way to do this? I...
1
by: Yanik Reid | last post by:
When I run the following vb.net code, I'm not able to acces the my database AMFLIB. I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries Access but now I want to use the...
0
by: Twan Kennis | last post by:
Hello! I do have the following problem: I've developed a Windows application which communicates with a DB2-database on the iSeries platform using an ODBC-connection string. This...
6
by: Lou | last post by:
Does anyone know how to use and OS/400 library list with a DAD to indirectly reference the "collection", a.k.a. "database", a.k.a "library"? All of the examples I see have the library name hard...
3
by: Laurence | last post by:
Hi there, Does somebody know the efficent way to connect DB2/400? Through iSeries Access ODBC/OLEDB driver or DB2 Connect? Which will more fast and efficent? In addition, does DB2 Connect use...
2
by: Charles Wilt | last post by:
I have a IBM iSeries (aka AS-400) running v5r3 of OS/400 that I access via a linked server from SQL Server 2000. The following select works fine: select * from...
2
by: Fred | last post by:
I am trying to write an app in vfp 8.0 using cursoradapters connecting to an as400 db2 database. My goal is to set up a test data library (called FRED) on the iseries identical to the production...
1
by: Chevylover54 | last post by:
We have been using ODBC connections that are in the registry of the computer. However these connections aren't in by default so when a new user uses the Access program or when a current user goes to...
6
by: Al G | last post by:
Can someone tell me what I need to get connected to our AS400? I am trying to write an app in VS2005(Data source, Gridview) that requires data from files on our AS400. I've downloaded DB2, and...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.