Re: Connect to IBMi DB2 using an OLE DB connection

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