Re: Connect to IBMi DB2 using an OLE DB connection

[Charles Wilt <charles.wilt@xxxxxxxxx>]

I've never had to specify a port...

Also be aware there are three different OLE DB drivers
*Database Provider* *Framework* *Consideration*
*IBMDA400* OLE DB Provider Existing applications; applications that want
the most flexible OLE DB support, including support for SQL, RLA, Data
Queues, and Commands.
*IBMDASQL* OLE DB Provider SQL-only support; SQL commitment control and
MTS; (Note: IBMDA400 does not support SQL commitment control or MTS)
*IBMDARLA* OLE DB Provider RLA-only support; Forward-only cursors and block
fetches with RLA; (Note: IBMDA400 does not support forward-only cursors or
block fetches with RLA)
*IBM.Data.DB2.iSeries* .NET Provider Offers the best performance when using
the .NET framework.


To be honest, it seems a bit strange to be wanting to use OLEDB now-a-days.

I'd expect them to want a .NET driver.

FYI: .NET Core driver is only available with Db2 Connect. :/

Charles


On Thu, Jun 24, 2021 at 7:39 AM Dean Eshleman <Dean.Eshleman@xxxxxxxxxxxx>
wrote:

> Hi,
>
> We have some consultants that want to connect to our IBM I using the OLE
> DB provider.  Does anyone know what server needs to running to accept that
> connection?  I would assume it is the same one that handles ODBC, but I
> could be wrong.  Also, what port would it try to connect on?  Thanks.
>
> Dean Eshleman
> Software Development Architect
> Everence
>
> 1110 North Main Street
> PO Box 483
> Goshen, IN 46527
> (800) 348-7468 ext. 3528
> (574) 533-9515 ext. 3528
> [Join our Talent Network]<http://www.everence.com/careers>
>
> Confidentiality Notice: This information is intended only for the
> individual or entity named. If you are not the intended recipient, do not
> use or disclose this information.  If you received this e-mail in error,
> please delete or otherwise destroy it and contact us at (800) 348-7468 so
> we can take steps to avoid such transmission errors in the future. Thank
> you.
> --
> 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