[AccessD] Connect to DB2

Millard, Paul --- Sr. Developer Analyst ---WGO Paul.Millard at freight.fedex.com
Fri Mar 19 11:11:52 CST 2004


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

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list