Recently i got the chance to work with IBM AS400-iSeries-System database i.e mainframe database. Process is very much similar to ado.net approach.
Firstly you have to install drive i.e IBM i Access for Windows
Then add the IBM.Data.DB2.iSeries dll in your application.
Now you can write the code like this.
Public Class Form1
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim con As New iDB2Connection("Data source=000.100.00.11;User Id=Test;Password=Test")
Dim cmd As New iDB2Command()
cmd = con.CreateCommand()
cmd.CommandText = "trs.Test"
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters("@ErrorMsgId").Direction = ParameterDirection.Output
cmd.Parameters("@ErrorMsg").Direction = ParameterDirection.Output
Dim da As New iDB2DataAdapter(cmd)
Dim dt As New DataTable()
Dim msg As String = cmd.Parameters("@ErrorMsgId").Value
Dim msg1 As String = cmd.Parameters("@ErrorMsg").Value
It will fetch the data from database.
Corflags is the inbuilt tool of Visual Studio which is used to find out the type of .dll i.e 32 bit, 64 bit or any CPU. This tool is available in Visual studio 2005 onward. i.e. VS 2005/2008/2010/2013
These are the following steps to check in Visual Studio
Step1 : Go to visual Studio command prompt like this
Step 2: Make Sure that Corflags is working in your system
Type the Corflags in Command Prompt like this
Note: if this syntax is not working then there is some problem in Environment Variable of the System
You can fix this issue like this post
How to Fix “not recognized as an internal or external command” in Windows
Step 3: Go to the file Location of DLL and type the syntax like this in below image
This is the short summary to determine the type of dll
Any CPU: PE = PE32 and 32BIT = 0
x86 bit: PE = PE32 and 32BIT = 1
64-bit: PE = PE32+ and 32BIT = 0
I hope this will help to some body.
If you are connecting with oracle database then there is not mandatory to install oracle server in each machine. We can install the oracle client, then we can connect with database. But for install of oracle client we can do like this.
Step 1: Make ensure that software is for 64 bit.
Step 2: Click on Setup
Step 3: Select “RunTime” then click on Next
Step 4: Go to the path of install oracle client 64 bit software like this path
And change the tnsnames like this
(PROTOCOL = TCP)
(HOST = 10.10.201.14)
(PORT = 1521)
(SID = db1)
Now using this TESTDB tns name we can connect with database.