Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 776
  • Last Modified:

C# ODBC connection to DB2

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
pclarke7
Asked:
pclarke7
2 Solutions
 
Kent OlsenData Warehouse Architect / DBACommented:
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
 
momi_sabagCommented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now