RE: Connect to IBMi DB2 using an OLE DB connection

You are correct. Same ports as ODBC.

I have started reverting back to the ODBC driver since that driver works on all platforms so you can have agnostic code. And ODBC is what .Net Core can use as well, which should be the direction for new apps if possible.

However I think the OLEDB and ADO.Net drivers should also work fine if you're using classic .Net stuff.

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

------------------------------

message: 2
date: Thu, 24 Jun 2021 13:39:04 +0000
from: Dean Eshleman <Dean.Eshleman@xxxxxxxxxxxx>
subject: Connect to IBMi DB2 using an OLE DB connection

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.


------------------------------

message: 3
date: Thu, 24 Jun 2021 13:49:27 +0000
from: Rob Berendt <rob@xxxxxxxxx>
subject: RE: Connect to IBMi DB2 using an OLE DB connection

https://www.ibm.com/docs/en/i/7.4?topic=connection-connect-i-linux-mac-windows-clients
https://www.ibm.com/docs/en/i/7.4?topic=programming-ole-db-provider

HTH

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com