MartyConnelly
martyconnelly at shaw.ca
Sat Mar 20 10:11:38 CST 2004
These might help too: Getting Started with DB2 V8 and ADO using Visual Basic 6 http://www-106.ibm.com/developerworks/db2/library/techarticle/0302hasin/0302hasin.html DB2 Development Add-Ins for Visual Studio 6.0 - The Next Generation AD Tooling In here is description of auto tool to generate ADO connection string called DB2 Development Add-In for Visual Basic 6.0 It will generate a string complete with sample code based on the driver used. http://www-106.ibm.com/developerworks/db2/library/techarticle/0208alazzawe/0208alazzawe.html Leverage your SQL Server 2000 Skills to Learn DB2 UDB v8 http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci947038,00.html?FromTaxonomy=%2Fpr%2F286330 Just in case you have installed DB2 incorrectly see Installing and configuring DB2 UDB V8 http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci931151,00.html?FromTaxonomy=%2Fpr%2F286330 MartyConnelly wrote: > > 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