MartyConnelly
martyconnelly at shaw.ca
Thu Mar 18 17:24:58 CST 2004
Have a look through this site http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForDB2 Then check here since things like the rdbname change depending on whether you are going to VM, MVS, MVE or AS400 http://support.microsoft.com/default.aspx?scid=kb;EN-US;218590 I would try to create a blank .udl file in Notepad, save it , then open via explorer and select oledb for DB2, fill in the blanks test the connection when it works get the connection string out of the saved udl file. Millard, Paul --- Sr. Developer Analyst ---WGO wrote: >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. >**************************************************************** > > > -- Marty Connelly Victoria, B.C. Canada