The .NET Core drivers are actually very nice, it's a simple nuget package you install in your application and nothing else is needed. The only thing needed if interacting with DB2 on the IBMi is to push the DB2 Connect server license key to the IBMi and that's it.
In full framework versions of DB2 Connect you were always tied to the version of DB2 connect that you install on your local machine, with .NET Core it's become so much easier as there is nothing to install other then a nuget package.
We have been transitioning a lot of our applications to Entity Framework Core against DB2 (we've also found many of the big bugs in the .NET Core driver that have been patched over the last couple years).
Matt
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of John Yeung
Sent: Thursday, June 24, 2021 9:38 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Connect to IBMi DB2 using an OLE DB connection
CAUTION: This email originated from outside of the ARRT. Do not click links or open attachments unless you recognize the sender and know the content is safe.
On Thu, Jun 24, 2021 at 9:56 AM Charles Wilt <charles.wilt@xxxxxxxxx> wrote:
To be honest, it seems a bit strange to be wanting to use OLEDB now-a-days.
I imagine that even consultants have some old-school practitioners in their ranks. Or at least old-school tools.
I'd expect them to want a .NET driver.
FYI: .NET Core driver is only available with Db2 Connect. :/
Well, now that .NET "Framework" and .NET Core have been unified, I wonder if the new .NET-to-rule-them-all has a driver independent of
Db2 Connect. (I would hope so, but I don't follow that space closely.
Maybe Richard Schoen knows.)
I guess at worst, folks using the latest .NET could connect via ODBC.
John Y.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
