Technical documentation BabelBank
Technical environment
Development language: Visual Basic
Reportingtool: Active Report from Data Dynamics
Database for BabelBank setup: MS Access
XML-parser: MSXML4 from Microsoft
Requirements for productionenvironment
It is difficult to determine exact requirements for the hardware which will be used. These requirements are dependent upon transactionquantity, complexity in matching and responsetime for queries to the accountingsystems database.
The requirements are based on a maximum number of incoming payments of 100 000 a day, and a normal level of complexity during matching.
Other aspects, like operatingsystem, active processes, type of processor, etc. must also be taken under consideration.
Available diskspace: ca. 100 Mb
Available memory: ca. 2 Gb
Processor, ex. Pentium 4: ca. 1 GHz
Windows 98 or higher.
Database
BabelBank is using Microsoft Access to store setupdata. This database is also used for storing incoming payments when this functionality is required. There is NO need for Access to be installed on the computer or server. BabelBank uses MDAC to access the database.
The files needed for MDAC are installed with the BabelBank installset.
(Please find a list on the next pages of installed files)
Files installed with BabelBank installationset
Notation:
The different directories in use are:
[appdir] Directory for BabelBank’s files (selected by user)
[windir] Windows directory, f.ex. c:\windows
[sysdir] Windows systemdirectory, f.ex. c:\windows\system
\[programfiles]\[commonfiles] Directory for programinstallations and common files, f.ex. c:\programfiler\fellesfiler
Files copied permanently into the programdirectory [appdir]:
BabelBank.exe [appdir]
BabelBank809.dll [appdir]
BabelBank414.dll [appdir]
bbSetup.dll [appdir]
Setup809.dll [appdir]
Setup414.dll [appdir]
vbbabel.dll [appdir]
vbBabel809.dll [appdir]
vbBabel414.dll [appdir]
vbCommon809.dll [appdir]
vbCommon414.dll [appdir]
EDI2XML.dll [appdir]
EDI2XML809.dll [appdir]
EDI2XML414.dll [appdir]
VbLog.dll [appdir]
diCryptoSys.dll [appdir]
Actrpt2.dll [appdir]
Arview2.ocx [appdir]
DoorExi1.ico [appdir]
Background.JPG [appdir]
dollar.jpg [appdir]
BabelBank_doc_no.cnt [appdir]
BABELBANK_NO.HLP [appdir]
Pdfexpt.dll [appdir]
Rtfexpt.dll [appdir]
Textexpt.dll [appdir]
IntegratorXMLSchema.xsd [appdir]
Div. .XML-filer [appdir]
fpSpr30.ocx [appdir]
SPR32X30.ocx [appdir]
Files copied permanently into programdirectory\db_ins [appdir\db_ins]:
Init_Profile.mdb [appdir\db_ins]
Babel.lic [appdir\db_ins]
Files copied permanently into programdirectory\db_ins [appdir\ClientInstall]:
BabelBank.Cab [appdir\ClientInstall]
Setup.Exe [appdir\ClientInstall]
Setup.Lst [appdir\ClientInstall]
Files copied into Windows Systemdirectory ([sysdir]):
msadox.dll [sysdir]
COMCAT.DLL [sysdir]
STDOLE2.TLB [sysdir]
ASYCFILT.DLL [sysdir]
OLEAUT32.DLL [sysdir]
OLEPRO32.DLL [sysdir]
MSVBVM60.DLL [sysdir]
MFC42.DLL [sysdir]
MSVCRT.DLL [sysdir]
MSCOMCTL.OCX [sysdir]
MSCOMCT2.OCX [sysdir]
RICHED32.DLL [sysdir]
MSSTDFMT.DLL [sysdir]
MSWINSCK.OCX [sysdir]
COMDLG32.OCX [sysdir]
MSMAPI32.OCX [sysdir]
msadox.dll [sysdir]
msbind.dll [sysdir]
scrrun.dll [sysdir]
VB6STKIT.DLL [sysdir]
Msxml4.dll [sysdir]
Msxml4a.dll [sysdir]
Msxml4r.dll [sysdir]
RICHTX32.OCX [sysdir]
MSDART32.DLL [sysdir]
MSADO25.TLB [sysdir]
Filer copy temporarily into the programdirectory, used at installationtime, and later removed:
MDAC_TYP.EXE
The file mdac_typ.exe is an installationprogram, which installs Microsofts ADO-components for databaseaccess.
The following files are installed by mdac_typ.exe:
ADO
MDAC21RD.txt \[programfiles]\[commonfiles]\System\ADO
adoapt15.reg \[programfiles]\[commonfiles]\System\ADO
adofre15.reg \[programfiles]\[commonfiles]\System\ADO
adojavas.inc \[programfiles]\[commonfiles]\System\ADO
adoreadm.txt \[programfiles]\[commonfiles]\System\ADO
adovbs.inc \[programfiles]\[commonfiles]\System\ADO
makapt15.bat \[programfiles]\[commonfiles]\System\ADO
makfre15.bat \[programfiles]\[commonfiles]\System\ADO
msader15.dll \[programfiles]\[commonfiles]\System\ADO
msado15.dll \[programfiles]\[commonfiles]\System\ADO
msado20.tlb \[programfiles]\[commonfiles]\System\ADO
msador15.dll \[programfiles]\[commonfiles]\System\ADO
msadrh15.dll \[programfiles]\[commonfiles]\System\ADO
adomdrd.txt \[programfiles]\[commonfiles]\System\ADO
msadomd.dll \[programfiles]\[commonfiles]\System\ADO
ADOX
adoxrdme.txt \[programfiles]\[commonfiles]\System\ADO
msadox.dll \[programfiles]\[commonfiles]\System\ADO
jroread.txt \[programfiles]\[commonfiles]\System\ADO
msjro.dll \[programfiles]\[commonfiles]\System\ADO
Jet 4.0
expsrv.dll [sysdir]
msexch40.dll [sysdir]
msexcl40.dll [sysdir]
msjet40.dll [sysdir]
msjint40.dll [sysdir]
msjter40.dll [sysdir]
msjtes40.dll [sysdir]
msltus40.dll [sysdir]
mspbde40.dll [sysdir]
msrclr40.dll [sysdir]
msrd2x40.dll [sysdir]
msrd3x40.dll [sysdir]
msrecr40.dll [sysdir]
msrepl40.dll [sysdir]
mstext40.dll [sysdir]
mswdat10.dll [sysdir]
mswstr10.dll [sysdir]
msxbde40.dll [sysdir]
vbajet32.dll [sysdir]
Jet OLE DB Provider
msjetoledb40.dll [sysdir]
Access ODBC Driver
odbcjet.cnt [sysdir]
odbcjet.hlp [sysdir]
odbcji32.dll [sysdir]
odbcjt32.dll [sysdir]
oddbse32.dll [sysdir]
odexl32.dll [sysdir]
odfox32.dll [sysdir]
odpdx32.dll [sysdir]
odtext32.dll [sysdir]
MTxOCI
mtxoci.dll [sysdir]
ODBC Core
ds16gt.dll [sysdir]
ds32gt.dll [sysdir]
mtxdm.dll [sysdir]
odbc16gt.dll [sysdir]
odbc32.dll [sysdir]
odbc32gt.dll [sysdir]
odbcad32.exe [sysdir]
odbccp32.cpl [sysdir]
odbccp32.dll [sysdir]
odbccr32.dll [sysdir]
odbccu32.dll [sysdir]
odbcinst.cnt [sysdir]
odbcinst.hlp [sysdir]
odbcint.dll [sysdir]
odbctrac.dll [sysdir]
OLE DB Core
msdadc.dll \[programfiles]\[commonfiles]\System\OLE DB
msdaenum.dll \[programfiles]\[commonfiles]\System\OLE DB
msdaer.dll \[programfiles]\[commonfiles]\System\OLE DB
msdaosp.dll \[programfiles]\[commonfiles]\System\OLE DB
msdaps.dll \[programfiles]\[commonfiles]\System\OLE DB
msdasc.cnt \[programfiles]\[commonfiles]\System\OLE DB
msdasc.dll \[programfiles]\[commonfiles]\System\OLE DB
msdasc.hlp \[programfiles]\[commonfiles]\System\OLE DB
msdasc.txt \[programfiles]\[commonfiles]\System\OLE DB
msdasql.dll \[programfiles]\[commonfiles]\System\OLE DB
msdasqlr.dll \[programfiles]\[commonfiles]\System\OLE DB
msdatl2.dll \[programfiles]\[commonfiles]\System\OLE DB
msdatt.dll \[programfiles]\[commonfiles]\System\OLE DB
msdsqlrm.txt \[programfiles]\[commonfiles]\System\OLE DB
msxactps.dll \[programfiles]\[commonfiles]\System\OLE DB
oledb32.dll \[programfiles]\[commonfiles]\System\OLE DB
oledb32r.dll \[programfiles]\[commonfiles]\System\OLE DB
oledb32x.dll \[programfiles]\[commonfiles]\System\OLE DB
Oracle ODBC Driver
mscpxl32.dll [sysdir]
msorcl32.cnt [sysdir]
msorcl32.dll [sysdir]
msorcl32.hlp [sysdir]
msorcrdm.txt [sysdir]
Oracle OLE DB Provider
msdaora.dll \[programfiles]\[commonfiles]\System\OLE DB
msorcolr.txt \[programfiles]\[commonfiles]\System\OLE DB
RDS
HANDLER.reg \[programfiles]\[commonfiles]\System\MSADC
adcjavas.inc \[programfiles]\[commonfiles]\System\MSADC
adcvbs.inc \[programfiles]\[commonfiles]\System\MSADC
handsafe.reg \[programfiles]\[commonfiles]\System\MSADC
handunsf.reg \[programfiles]\[commonfiles]\System\MSADC
msadce.dll \[programfiles]\[commonfiles]\System\MSADC
msadcer.dll \[programfiles]\[commonfiles]\System\MSADC
msadcf.dll \[programfiles]\[commonfiles]\System\MSADC
msadcfr.dll \[programfiles]\[commonfiles]\System\MSADC
msadco.dll \[programfiles]\[commonfiles]\System\MSADC
msadcor.dll \[programfiles]\[commonfiles]\System\MSADC
msadcs.dll \[programfiles]\[commonfiles]\System\MSADC
msadds.dll \[programfiles]\[commonfiles]\System\MSADC
msaddsr.dll \[programfiles]\[commonfiles]\System\MSADC
msdaprsr.dll \[programfiles]\[commonfiles]\System\MSADC
msdaprst.dll \[programfiles]\[commonfiles]\System\MSADC
msdarem.dll \[programfiles]\[commonfiles]\System\MSADC
msdaremr.dll \[programfiles]\[commonfiles]\System\MSADC
msdatsrc.tlb [sysdir]
msdfmap.dll \[programfiles]\[commonfiles]\System\MSADC
msdfmap.ini [windir]
SQL Server ODBC Driver
12520437.cpx [sysdir]
12520850.cpx [sysdir]
Sqlsrdme.txt [sysdir]
cliconf.hlp [sysdir]
cliconfg.DLL [sysdir]
cliconfg.exe [sysdir]
odbcbcp.dll [sysdir]
sqlsodbc.hlp [sysdir]
sqlsrv32.dll [sysdir]
sqlstr.dll [sysdir]
sqlwid.dll [sysdir]
sqlwoa.dll [sysdir]
SQL Server OLE DB Provider
SQLOLEDB.txt \[programfiles]\[commonfiles]\System\OLE DB
SQLSOLDB.hlp \[programfiles]\[commonfiles]\System\OLE DB
dbmsadsn.dll [sysdir]
dbmsrpcn.dll [sysdir]
dbmsshrn.dll [sysdir]
dbmssocn.dll [sysdir]
dbmsspxn.dll [sysdir]
dbmsvinn.dll [sysdir]
dbnmpntw.dll [sysdir]
instcat.sql [sysdir]
sqloledb.dll \[programfiles]\[commonfiles]\System\OLE DB
Setup
common98.dll [sysdir]
mdac.cmd [sysdir]
msdamg9x.dll [sysdir]
odbcconf.exe [sysdir]
odbckey.inf [sysdir]
odbcstf.dll [sysdir]
System
asycfilt.dll [sysdir]
msvcirt.dll [sysdir]
msvcrt.dll [sysdir]
oleaut32.dll [sysdir]
olepro32.dll [sysdir]
stdole2.tlb [sysdir]
Visual FoxPro ODBC Driver
drvvfp.cnt [sysdir]
drvvfp.hlp [sysdir]
vfpodbc.dll [sysdir]
vfpodbc.txt [sysdir]
Versionnumber and description for files installed by mdac_typ.exe:
Fileslist for MDAC 2.5 SP1 (2.51.5303.5)
Filename / Version (x86) / Description12520437.cpx / N/A / SQL Server Codepage Translator
12520850.cpx / N/A / SQL Server Codepage Translator
adcjavas.inc / N/A / ADC/RDS JavaScript include file
adcvbs.inc / N/A / ADC/RDS VBScript include file
adojavas.inc / N/A / ADO JavaScript include file
adovbs.inc / N/A / ADO VBScript include file
advpack.dll / Not specified. / Advanced .INF Installer
asycfilt.dll / 2.40.4277.1 / OLE 2.40 for Windows NT™ and Windows 95™ Operating Systems
cabinet.dll / 1.0.601.4 / Cabinet File API
cliconf.hlp / N/A / SQL Server Client Configuration Help file
cliconfg.DLL / 1999.10.20.1 / Client Configuration Utility
cliconfg.exe / 1999.10.20.1 / Client Configuration Utility
dbmsadsn.dll / 1999.10.20.0 / Pipes Net DLL for SQL Clients
dbmsrpcn.dll / 1999.10.20.1 / RPC Net Library
dbmsshrn.dll / 1999.10.20.0 / RPC Net Library
dbmssocn.dll / 1999.10.20.0 / Net DLL for SQL Server
dbmsspxn.dll / 1999.10.20.0 / NWLINK SPX WINSOCK Net Library
dbmsvinn.dll / 1999.10.20.1 / VINES Net Library
dbnmpntw.dll / 1999.10.20.1 / Pipes Net DLL for SQL Clients
drvvfp.chm / N/A / Visual FoxPro ODBC Driver HTML Help
ds16gt.dll / 3.510.3711.0 / ODBC 16-bit Driver Setup Generic Thunking
ds32gt.dll / 3.520.5303.2 / Data Access - ODBC Driver Setup Generic Thunking
expsrv.dll / 6.0.0.8540 / Basic for Applications Runtime - Expression Service
HANDLER.reg / N/A / Registration entries file for setting up default RDS Handler
Handsafe.reg / N/A / Registration entries file for making RDS always run with a safe handler
Handunsf.reg / N/A / Registration entries file for making RDS not require a safe handler
instcat.sql / N/A / SQL Server SP Catalog updater
mdacrdme.htm / N/A / MDAC Release Notes
msadce.dll / 2.51.5303.1 / Data Access - OLE DB Cursor Engine
msadcer.dll / 2.51.5303.1 / Data Access - OLE DB Cursor Engine Resources
msadcf.dll / 2.51.5303.1 / Data Access - Remote Data Services Data Factory
msadcfr.dll / 2.51.5303.1 / Data Access - Remote Data Services Data Factory Resources
msadco.dll / 2.51.5303.1 / Data Access - Remote Data Services Data Control
msadcor.dll / 2.51.5303.1 / Data Access - Remote Data Services Data Control Resources
msadcs.dll / 2.51.5303.1 / Data Access - Remote Data Services ISAPI Library
msadds.dll / 2.51.5303.1 / Data Access - OLE DB Data Shape Provider
msaddsr.dll / 2.51.5303.1 / Data Access - OLE DB Data Shape Provider Resources
msader15.dll / 2.51.5303.0 / Data Access - ActiveX Data Objects (ADO) Resources
msado15.dll / 2.51.5303.0 / Data Access – ADO
msado20.tlb / 2.51.5303.0 / Data Access – ADO 2.0 Type Library
msado21.tlb / 2.51.5303.0 / Data Access – ADO 2.1 Type Library
msadomd.dll / 2.51.5303.0 / Data Access - ActiveX Data Objects Multidimensional (ADO MD)
msador15.dll / 2.51.5303.0 / Data Access – ADO
msadox.dll / 2.51.5303.0 / Data Access – ADO Extensions
msadrh15.dll / 2.51.5303.0 / Data Access – ADO Rowset Helper
mscpxl32.dll / 3.60.3.20 / ODBC Code Page Translator
msdadc.dll / 2.51.5303.0 / Data Access - OLE DB Data Conversion Stub
msdaenum.dll / 2.51.5303.0 / Data Access - OLE DB Root Enumerator Stub
msdaer.dll / 2.51.5303.0 / Data Access - OLE DB Error Collection Stub
msdamg9x.dll / 2.51.5303.5 / Data Access - Win98 Migration DLL
msdaora.dll / 2.51.5303.0 / Data Access - OLE DB Provider for Oracle
msdaosp.dll / 2.51.5303.0 / Data Access - OLE DB Simple Provider
msdaprsr.dll / 2.51.5303.1 / Data Access - OLE DB Persistence Services Resources
msdaprst.dll / 2.51.5303.1 / Data Access - OLE DB Persistence Services
msdaps.dll / 2.51.5303.0 / Data Access - OLE DB Interface Proxies/Stubs
msdarem.dll / 2.51.5303.1 / Data Access - OLE DB Remote Provider
msdaremr.dll / 2.51.5303.1 / Data Access - OLE DB Remote Provider Resources
msdart32.dll / 2.51.5303.0 / Data Access - OLE DB Runtime Routines
msdasc.chm / N/A / OLE DB Service Components HTML Help file
msdasc.dll / 2.51.5303.0 / Data Access - OLE DB Service Components Stub
msdasql.dll / 2.51.5303.2 / Data Access - OLE DB Provider for ODBC Drivers
msdasqlr.dll / 2.51.5303.2 / Data Access - OLE DB Provider for ODBC Drivers Resources
msdatl2.dll / 2.51.5303.2 / Data Access - OLE DB Implementation Support Routines
msdatsrc.tlb / 9.0.5303.0 / Data Access – Data Source Interfaces
msdatt.dll / 2.51.5303.2 / Data Access - OLE DB Temporary Table Services
msdaurl.dll / 9.1.5303.0 / Data Access - OLE DB RootBinder Stub
msdfmap.dll / 2.51.5303.1 / Data Access – Data Factory Handler
msdfmap.ini / N/A / Initialization file for configuring default RDS Handler
msexch40.dll / 4.0.2927.2 / Jet Exchange ISAM
msexcl40.dll / 4.0.3714.0 / Jet Excel ISAM
msjet40.dll / 4.0.3714.7 / Jet Engine Library
MSJETO~1.DLL / 4.0.3714.0 / OLE DB Provider for Jet
msjint40.dll / 4.0.2927.2 / Jet Database Engine International DLL
msjro.dll / 2.51.5303.0 / Jet and Replication Objects
msjter40.dll / 4.0.2927.2 / Jet Database Engine Error DLL
msjtes40.dll / 4.0.3714.5 / Jet Expression Service
msltus40.dll / 4.0.3714.0 / Jet Lotus 1-2-3 ISAM
msorcl32.chm / N/A / Oracle ODBC Driver Help (Compiled HTML)
msorcl32.dll / 2.573.5303.0 / Data Access - ODBC Driver for Oracle
mspbde40.dll / 4.0.2927.2 / Jet Paradox ISAM
msrd2x40.dll / 4.0.2927.2 / (R) Red ISAM
msrd3x40.dll / 4.0.3714.0 / (R) Red ISAM
msrecr40.dll / 4.0.2927.2 / Jet98
msrepl40.dll / 4.0.3714.0 / Replication Library
mstext40.dll / 4.0.3714.5 / Jet Text ISAM
msvcirt.dll / 6.0.8168.0 / (R) C++ Runtime Library
msvcrt.dll / 6.0.8397.0 / (R) C Runtime Library
mswdat10.dll / 4.0.3829.2 / Jet Sort Tables
mswstr10.dll / 4.0.3829.2 / Jet Sort Library
msxactps.dll / 2.51.5303.0 / Data Access – OLE DB Transaction Proxies/Stubs
msxbde40.dll / 4.0.2927.2 / Jet xBASE ISAM
mtxdm.dll / 1997.11.532.0 / MTS connection pooling - ODBC driver manager
mtxoci.dll / 1999.6.854.0 / MTS - Oracle OCI
odbc16gt.dll / 3.510.3711.0 / ODBC 16-bit Generic Thunking
odbc32.dll / 3.520.5303.2 / Data Access - ODBC Driver Manager
odbc32gt.dll / 3.520.5303.2 / Data Access - ODBC Driver Generic Thunking
odbcad32.exe / 3.520.5303.2 / Data Access - ODBC Administrator
odbcbcp.dll / 3.70.8.21 / BCP for ODBC
odbcconf.dll / 3.520.5303.5 / Data Access - ODBC Driver Configuration Program
odbcconf.exe / 3.520.5303.5 / Data Access - ODBC Driver Configuration Program
odbcconf.rsp / N/A / Data Access - ODBC Driver Configuration File
odbccp32.cpl / 3.520.5303.2 / Data Access - ODBC Control Panel
odbccp32.dll / 3.520.5303.2 / Data Access - ODBC Installer
odbccr32.dll / 3.520.5303.2 / Data Access - ODBC Cursor Library
odbccu32.dll / 3.520.5303.2 / Data Access - ODBC Cursor Library
odbcinst.chm / N/A / ODBC HTML help
odbcint.dll / 3.520.5303.2 / Data Access - ODBC Resources
odbcjet.chm / N/A / Jet ODBC HTML Help
odbcji32.dll / 4.0.5303.1 / ODBC Desktop Driver Pack 3.5
odbcjt32.dll / 4.0.5303.1 / ODBC Desktop Driver Pack 3.5
odbcstf.dll / 3.520.5303.5 / Data Access - ODBC Custom Action library
odbctrac.dll / 3.520.5303.2 / Data Access - ODBC Driver Manager Trace
oddbse32.dll / 4.0.5303.1 / ODBC (3.0) driver for DBase
odexl32.dll / 4.0.5303.1 / ODBC (3.0) driver for Excel
odfox32.dll / 4.0.5303.1 / ODBC (3.0) driver for FoxPro
odpdx32.dll / 4.0.5303.1 / ODBC (3.0) driver for Paradox
odtext32.dll / 4.0.5303.1 / ODBC (3.0) driver for text files
oleaut32.dll / 2.40.4277.1 / OLE 2.40 for Windows NT™ and Windows 95™ Operating Systems
oledb32.dll / 2.51.5303.0 / Data Access – OLE DB Core Services
oledb32a.dll / 2.51.5303.0 / Data Access – OLE DB Core Services Resources
oledb32r.dll / 2.51.5303.0 / Data Access – OLE DB Core Services Resources
oledb32x.dll / 2.51.5303.0 / Data Access – OLE DB Extensions
oledbjvs.inc / N/A / OLE DB JavaScript include file
oledbvbs.inc / N/A / OLE DB VBS include file
olepro32.dll / 5.0.4277.1 / OLE 2.40 for Windows NT™ and Windows 95™ Operating Systems
sqloledb.dll / 7.1.8.20 / OLE DB Provider for SQL Server
sqlsodbc.hlp / N/A / SQL Server ODBC Help
sqlsrv32.dll / 3.70.8.21 / SQL Server ODBC Driver
sqlstr.dll / 1999.10.20.1 / Function DLL for SQL Enterprise Components
sqlwid.dll / 1999.10.20.0 / Function DLL for SQL Enterprise Components
sqlwoa.dll / 1999.10.20.1 / Function DLL for SQL Enterprise Components
stdole2.tlb / 2.40.4277.1 / OLE 2.40 for Windows NT™ and Windows 95™ Operating Systems
vbajet32.dll / 6.0.1.8268 / Basic for Applications Development Environment - Expression Service Loader
vfpodbc.dll / 6.1.8629.1 / Visual Foxpro® ODBC Driver
Visual Banking AS, Sinsenveien 53D, 0585 Oslo Phone: (0047)2318 3600 www.visualbanking.net