Please visit our website for the latest news, docs, and examples.
http://www.aspdb.com/
*********************************************************************
Update Instructions:
--------------------
If you are installing a newer version of ASP-db onto your
system (you already have an older version installed) you MUST
remove the previous version first.
A. If you registered it with REGSVR32 originally, do the following:
First open a DOS prompt. Then, change into the directory where
the dll was installed, and type:
REGSVR32 /U ASPdbView-Server.dll (substitute your .dll name if
different, i.e. ASPdbView-Local.dll)
Note: If you get a message like "Bad command or file name" it is
probably because the REGSVR32 program is not in your path. Try to
locate the program REGSVR32.EXE on your C drive and add that folder
to your path. Or if REGSVR32 is not in your path, you might try
typing:
\Windows\System\REGSVR32 /U ASPdbView-Eval.dll
or
\WINNT\System32\REGSVR32 /U ASPdbView-Server.dll
You MUST then shut down and RESTART your web server.
To do this, go to the DOS prompt and type:
NET STOP IISADMIN /Y
NET START W3SVC
NET START MSFTPSV (only do this if you run FTP service)
You may now register your NEW dll by typing:
REGSVR32 ASPdbView-Server.dll (substitute your .dll name if
different, i.e. ASPdbView-Local.dll)
B. If you registered it with MTS originally, do the following:
If you use the Internet Service Manager (a.k.a. MTS) to install
and register your components such as ASP-db, use MTS to re-install
ASP-db. Following are the instructions for installing ASP-db with
MTS followed by the steps for updating to a NEWER version.
** Installing ASP-db for the first time with MTS **
1) Open Microsoft Transaction Server
2) Open Computers
3) Open My Computer
4) Open Packages Installed
5) Left click on Packages Installed
6) Choose NEW PACKAGE from the popup menu
7) Click on Create an Empty Package
8) Type in a name such as ASP_Stuff
9) Click Next then choose either Interactive or This User & FINISH.
10) Open up your "ASP_Stuff" package
11) Left click on Components, then right click on it and...
12) Choose NEW COMPONENT
13) Click on Install new component
14) Click on Add Files and choose the ASPdbView-Server.dll file that
you wish to register.
15) Click the Finish button.
It sounds like a lot of steps, but you can do it in about 2 minutes.
The next time you wish to update your component with a newer
version, you don't have to shut down your web server or anything.
You just do the following steps:
** Updating ASP-db with a new version in MTS **
1) Repeat steps 1 through 4 above, and then open up the ASP_Stuff
package, Components, and click on the ASPdb.View ball icon to
highlight it.
2) Press DEL on your keyboard or click the "X" toolbar button to
delete it.
3) Left click on My Computer to highlight it, and then right click,
and choose Shut Down Server Processes
4) Go to step 10 above and repeat steps 10 - 15 to register your new
version.
The advantages of using MTS (Internet Information Server) over
REGSVR32 are:
* You can see when your component is in use and how many people are
using it (it spins and there's a detail view that shows you usage).
* You can delete a component and re-install a new version without
taking the web server down.
* If a component crashes or goes into a loop, it will not take down
your web server. You can go to MTS and repeat step 3 (directly
above) and it will shut down the process.
* Each component runs in a separate process isolating it from other
components.
* MTS supports object pooling allowing multiple users to re-use the
component without requiring it to be loaded from disk for each use.
Notes:
------
There have been several changes to ASP-db that you should be
aware of. In some cases, there are new features that you may
use. In other cases, you may need to edit your source code
in order to conform to a new syntax. Please refer to the DOC
file for a more complete explanation,
--------------------------------------------------------------
March 26, 1998
There is a new property called dbImageDir. It is used to
define the relative path for all of your images files,
including the graphical navigation buttons.
Old way ...
Mydb.dbNavigationIcon="images/*.gif,grid,form,top, ..."
New way ...
Mydb.dbImageDir="images/"
Mydb.dbNavigationIcon="gif,grid,form,top, ... reload"
--------------------------------------------------------------
March 20, 1998
The dbDelimiter property has been renamed to dbCSVDelimiter.
Old way ...
MyDb.dbDelimiter = ","
New way ...
MyDb.dbCSVDelimiter = ","
--------------------------------------------------------------
Reload button is new (and a gif is provided: reload.gif).
The ability to display bar charts is new (and the gifs are
provided: blankbar.gif, bluebar.gif, greenbar.gif, redbar.gif,
and shadowbar.gif).
--------------------------------------------------------------
There are Several New Features. Please refer to the DOC file
for additional information.
* Drop down lists on the Filter Screen.
* MagicCell
* The Names on the Filter screen now use the NameMap names.
* Anchoring is on by default. (in DOC?)
* DbNavigationIcon="std"
* DbQuickProps
* ColGraph for graphs
* SelectBox is new
--------------------------------------------------------------
June 12, 1998
dbSQL="*" is new - allows you to browse through tables.
dbTables is new - used with dbSQL="*".
Tables button is new (and a gif is provided: tables.gif).
Delimiter redefining is new using (;,[]) - see doc.
Session variable: SV_SelectBoxItem is new.
dbFilterDropFlds has a new format and OLD code MUST BE CHANGED!
dbMagicCell now supports URLEncoding.
dbSuppressMsg is new - see doc.
dbFilterFlds has a new optional heading parameter.
dbStartUp="Filter" is new.
dbHeading is new.
---------------------------------------------------------------
June 29, 1998
dbHeading has been replaced with dbOptions. Example:
MyDb.dbOptions = "(;|/)300|Now viewing, the #tablename# table.<BR>"
The first parameter is the ConnectTimeout (default=300 seconds).
The second parameter is the Heading to be used above your database display,
with #tablename# being replaced by ASP-db with the name of the table being viewed.
In the above example (;|/) is an optional parameter that allows you to specify your own
delimiters. Necessary if your heading contains commas.
dbSQL = "Select * from owner.tablename" is now supported for SQL Server databases.
dbMagicCell and dbSelectBox now have 5 delimiters at the beginning. (;,[]!)
In the above example,
; is the major delimiter that separates fields
, is the minor delimiter that separates parameters within a field
[] are the delimiters surrounding the format specification.
! is the delimiter that replaces the # (in case your data fields might contain # signs)
Added support for Sybase Date datatype=133.
---------------------------------------------------------------
July 24, 1998
Implement a new param (index) in dbMagicCell="field,tag,magic format,index".
Index is to signal the use of the "field" as index instead of the std index (#).
dbGridIndex should be set to false!
---------------------------------------------------------------
July 28, 1998
Add another param "indexanchor" to dbMagicCell after "index" to allow anchor
with the index. Example: dbMagicCell="field,tag,magic format,index,indexanchor"
Use the "GridInitSortDESC" keyword of the dbOptions property to enable this feature.
For example: dbOptions="GridInitSortDESC=True" (Default=False)
If this is set to true, the first click on the column header will sort the column
in DESC order. A subsequent repeated click on the same column will reverse the
sort order.
---------------------------------------------------------------
July 29, 1998
dbGridHideDupRecFlds can be used to hide duplicated cells in a column.
Example: dbGridHideDupRecFlds ="0,car,3"
----------------------------------------------------------------------------------
IMPORTANT NOTE! You may need to modify your source code if you have been using
a previous version of ASP-db and have used any of the following properties:
a) dbHeading. The property dbHeading has been replaced with dbOptions.
If your old statement looked like this:
dbHeading = "Now viewing table: #tablename#"
change it to this:
dbOptions = "ConnectTimeout=300,Heading=Now viewing table: #tablename#"
b) dbFilterDropFlds. The property dbFilterDropFlds has been changed to allow for
more flexibility in how drop down lists are generated.
If your old statement looked like this:
dbFilterDropFlds = "tablename, fld1, fld2"
change it to this:
dbFilterDropFlds = "fld1,,tablename,fld1; fld2,,tablename,fld2"
c) dbEasyFilterText. This property has been eliminated. Instead, specify your
Choice of EasyFilterText in dbFilterParams. For example:
dbFilterParams = "EasyFilterText=false"
d) Session variable SV_RecordCount has been deleted. Use dbRecordCount instead.
----------------------------------------------------------------------------------
Of course, you may refer to the DOC file for more details.
http://www.aspdb.com/docs/aspdb.htm
---------------------------------------------------------------
|
