Solved

C# ODBC connection to DB2

Posted on 2013-05-22
2
736 Views
Last Modified: 2013-05-27
Hello,
I am developing a c# application that reads from a number of DB2 files on an AS400 via ODBC.  The problem is that during development I don't have access to the DB2 database (ie No access to AS400) . Is there any way that I can "simulate" a DB2 environment so that when I swap over (eventually ) to a actual DB2 environment - that it will just require a change of DNS name ?

regards
Pat
0
Comment
Question by:pclarke7
2 Comments
 
LVL 45

Assisted Solution

by:Kdo
Kdo earned 250 total points
ID: 39188588
Hi Pat,

The AS/400 drivers are different than the other ODBC drivers.  Simulating an AS/400 connection will be tough, at best.

You can install DB2/LUW on a desktop and connect to it with DB2 drivers, but they're not the same as the AS/400 drivers.  I don't know if it will be much help though.  :(


Kent
0
 
LVL 37

Accepted Solution

by:
momi_sabag earned 250 total points
ID: 39188599
i believe that simple operations are done the same way across odbc drivers, otherwise, there would be no point in having a standard.
You can try to install the express edition on your machine, or even try to find odbc drivers that works on excel files / text files
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
laptop problem 21 95
New to SOAP and need some direction 10 45
access denied when running native SQL tool: SQLIOSIM 2 24
IE11 Crashing - Appears Company Wide 7 7
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now