Maybe this will help:
I am looking at an MS Access database I created years past which transferred
data from Access to some files on an IBM i.
I used the IBM OLE DB data access driver, and created a ADODB.Connection object
to support the data transfers.
The connection object used the IBM i "network name", which I got from our network
team. So I think you should be able to use MS ADODB from Visual Studio in a similar
fashion.
I used an MC Press book by Chris Peters and Brian Singleton named
"i5/OS and Microsoft Office" and an IBM manual on OLE DB and ActiveX, but you
should be able to find more current/relevant info for Visual Studio.
iProDeveloper would certainly be a good source of info.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Crystal Reports
Sent: Monday, June 03, 2013 7:08 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Connection to DB2
Specifically, How do I determine the server name. and the database name. Is the database name the Library name?
------------------------------
message: 3
date: Sun, 2 Jun 2013 18:46:48 -0700 (PDT)
from: Crystal Reports <crystalcleardecisions@xxxxxxxxx>
subject: Connecting to DB2 from Visual Studio Crystal report
HI I am happy to report the stored proc is done on the AS400. I wish to call this SP from the Visual Studio, connections strings or other way, Have you coded this in the past and can provide any sample codes or guidlelines. On the VS end there is DB2 tables and fields which the user chooses from to custom their own report.
------------------------------
--
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.
midrange.com
