Millard, Paul --- Sr. Developer Analyst ---WGO
Paul.Millard at freight.fedex.com
Thu Mar 18 16:01:40 CST 2004
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=Y00000078000003840009601710000012C000000000000000000020000000007FDFFFE00002710XX 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=Y00000078000003840009601710000012C000000000000000000020000000007FDFFFE00002710XX 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. ****************************************************************