[AccessD] Connect to DB2

That provider doesn't come with MDAC. It only comes with MS HIS Server
The Host Integration Server 2000 (was MS SNA server).  You are now 
talking in $2,500 range I think plus cost of win2003 or 2000 server
You have to differentiate between whether you are connecting via SNA or 
TCP/IP
There is a HIS Beta available and a 120 day trial
http://www.microsoft.com/hiserver/beta/default.asp

see this newsgroup  microsoft.public.snaserver.programming

 Host Integration  Server  is an integration solution for connectivity 
to a mainframe OS/390  (appears  as a cluster
controller, PU2 device), AS/400 OS/400 (appears as a  PU2.1 LEN node)

Symtrax iSeries OLE DB Driver free trial for AS400
http://www.symtrax.com/en/products/oledb/

Or you might get IBM's oledb version,  it maybe inside Free Personal DB2 
edition, haven't looked in a few years.
There is another version for dotNet.

DB2 Personal Developer's Edition (DB2 Personal Developers Edition for 
Windows (x86, 32-bit)) 500 Meg download
http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2003-09-12+10%3A53%3A49.025154R&S_TACT=TrialsAndBetas&S_CMP=&s=

Millard, Paul --- Sr. Developer Analyst ---WGO wrote:

>Yeah, I found this site yesterday and plugged in the oledb db2 connection string and Access gave me an error about cannot find a provider.  
>
>How does one get a provider for db2?
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Lawrence
>(AccessD)
>Sent: Thursday, March 18, 2004 6:07 PM
>To: Access Developers discussion and problem solving
>Subject: RE: [AccessD] Connect to DB2
>
>
>Hi Paul:
>
>Check this site out. It gives a number of DB2 connection examples depending
>on what and how you require the connection.
>
>http://www.able-consulting.com/ADO_Conn.htm
>
>HTH
>Jim
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Millard, Paul
>--- Sr. Developer Analyst ---WGO
>Sent: Thursday, March 18, 2004 2:02 PM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] Connect to DB2
>
>
>
>Folks,
>
>Can anyone help me connect to a db2 database.  I've seen multiple ways to
>connect using OLEDB Connection strings but I'm not sure what the database
>name and format should be. Below is a QMF SQL query tool .ini file used to
>connect to the database.
>
>If anyone can provide the string along with exact values based upon info
>below that would be great.
>
>Thanks,
>Paul
>
>[Server Parameters]
>Server1=HOST
>Server2=HOSTDSNB
>[HOST]
>RDBName=AFDSNP
>CollectionName=QMFWIN
>HostName=AFW1.HRO.AF.COM
>Port=446
>SymDestName=*TCP/IP*
>DefaultSchedule1=Y00000078000003840009601710000012C0000000000000000000200000
>00007FDFFFE00002710XX
>DefaultSchedule2=@
>0000000000000000
>DefaultSchedule3=2
>DefaultSchedule4=
>QueryBlockSize=32500
>DecimalDelimiter=Period
>StringDelimiter=Apostrophe
>IsolationLevel=CursorStability
>BindReplace=1
>BindKeep=1
>BindOwner=
>xSingleCCSID=37
>xMixedCCSID=0
>xDoubleCCSID=0
>xQMFCCSID=37
>[HOSTDSNB]
>RDBName=AFDSNT
>CollectionName=QMFWIN
>HostName=AFW2.HRO.AF.COM
>Port=5030
>SymDestName=*TCP/IP*
>DefaultSchedule1=Y00000078000003840009601710000012C0000000000000000000200000
>00007FDFFFE00002710XX
>DefaultSchedule2=@
>0000000000000000
>DefaultSchedule3=2
>DefaultSchedule4=
>QueryBlockSize=32500
>DecimalDelimiter=Period
>StringDelimiter=Apostrophe
>IsolationLevel=CursorStability
>BindReplace=1
>BindKeep=1
>BindOwner=
>xSingleCCSID=37
>xMixedCCSID=0
>xDoubleCCSID=0
>xQMFCCSID=37
>
>
>**********************************************************
>This message contains information that is confidential
>and proprietary to FedEx Freight or its affiliates.
>It is intended only for the recipient named and for
>the express purpose(s) described therein.
>Any other use is prohibited.
>****************************************************************
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada