RE: C#.Net connection to DB2

You will first need to install IBM i Access ODBC Drivers. There are no standalones for the IBM I ODBC drivers.

Connectionstrings.com is your friend for connections:
https://www.connectionstrings.com/as-400/

DSNless Connection:
Driver={IBM i Access ODBC Driver};System=1.1.1.1;Uid=myUser;Pwd=myPassword;

Now you can C# to your hearts content and use all the ODBC items like ODBCConnection, ODBCDataAdapter, etc.

Here's a small connection sample I did for a Mono on IBM i class in 2019.
https://github.com/richardschoen/MonoOniSamples/tree/master/MonoOdbcConnect

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
------------------------------

message: 2
date: Thu, 23 Jul 2020 19:49:12 -0400
from: smith5646midrange@xxxxxxxxx
subject: C#.Net connection to DB2

If this is not the right list for this, let me know the correct list and I will repost.



I am playing with a concept and I need to connect to and IBM i database with a C#.Net desktop program. Pretty much everything I have found via Google is either 10 years old or involves configuration on the PC (something about db2cli writecfg). Other databases such as MySQL have a .dll that allows connection without any PC config. Does such a thing exist for the IBM i and I just haven't hit the right web page? What is the preferred method of connecting from a C#.Net program?