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