Solved

C# ODBC connection to DB2

Posted on 2013-05-22
2
750 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:Kent Olsen
Kent Olsen 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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

713 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