Solved

C# ODBC connection to DB2

Posted on 2013-05-22
2
740 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
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…
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

825 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