× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. January 2016

RE: DB2 connect server

I'm looking specifically to use the entity framework driver to minimize the need to write SQL anymore. Was hoping someone had some experience with it. We have been using the ADO .NET driver for years, but writing SQL is a development pit we would like to try start digging ourselves out of.

We use NHibernate well with IBM I but are looking for alternatives. There are tons of options on other RDBMS, but we are finding that we have slim pickings with IBM I flavor of DB2.

Suppose we will need to contact IBM as looking at the Nuget download counters for the IBM DB2 entity framework driver seems like no many people are using it.


-----Original Message-----
From: Charles Wilt [mailto:charles.wilt@xxxxxxxxx]
Sent: Friday, January 22, 2016 10:18 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: DB2 connect server

Nope.

As I understand it, the free DB2 for i drivers don't support .NET entity framework.

You have to pay for DB2 Connect.
https://www.ibm.com/developerworks/community/forums/html/topic?id=eb239d2b-69ee-43fd-93a2-1d745b1423b0


Charles


On Fri, Jan 22, 2016 at 11:00 AM, Matt Olson <Matt.Olson@xxxxxxxx> wrote:

If I run a .NET IIS app on a windows server that is local to my
network, I wouldn't need DB2 connect right?

I can just use the DB2 entity framework driver and connect directly to
the IBM i via the DRDA ports and bypass DB2 connect altogether correct?

Matt



-----Original Message-----
From: Aaron Bartell [mailto:aaronbartell@xxxxxxxxx]
Sent: Friday, January 22, 2016 9:52 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: DB2 connect server

It's necessary for 2-tier situations. For example, if you have
Node.js on Amazon EC2 Linux and desire to connect to DB2 for i then
you'd need DB2Connect. If you run your Node.js directly on IBM i in
PASE (1-tier) then you can use the database adapter/driver IBM provides.

Aaron Bartell
litmis.com - Services for open source on IBM i


On Fri, Jan 22, 2016 at 9:48 AM, Matt Olson <Matt.Olson@xxxxxxxx> wrote:

Does anyone know what the purpose of the DB2 Connect server is? Why
add a link (single point of failure) in the chain and an extra hop
in your database access?

Matt
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.