What is Archivists’ Toolkit?
The Archivists’ Toolkit™, or the AT, is the first open source archival data management system to provide broad, integrated support for the management of archives. It is intended for a wide range of archival repositories. The main goals of the AT are to support archival processing and production of access instruments, promote data standardization, promote efficiency, and lower training costs.
Installation
This is just a brief overview of the installation steps since there is already an official manual that covers most of these steps.
- You first need to create a blank database using either MYSQL or Microsoft SQL server; in our case I used MS SQL.
- Once the database has been created, you then need to install the a Archivists’ toolkitapplication on the client machine, after the installation you need to browse to the %install directory%\Program Files\Archivists’ Toolkit 2.0\ and launch the “Maintenance Program 2.0.exe”
- This program is used to prep the Db and create all the necessary tables.
Now here is where things got out of hand for me, based on the specified documentation I needed to select my DB type, enter the connection URL, then my username and password.
Connection URL:
Connection URL:
Jdbd:sqlserver://[ip address]:[port];databaseName=[name]
e.g: Jdbc:sqlserver://127.133.68.55:1059;databaseName=OurArchivesHowever that didn’t seem to work. I did further research and discovered I needed to first have the following in place ;
- SQL Server 2005 JDBC driver, and a CLASSPATH configured
- Create a ODBC connection to the DB Server
1-- Download sqljdbc_
3-- Enter an installation directory when prompted. We recommend that you unpack this zip file in %ProgramFiles% with the default directory: "Microsoft SQL Server 2005 JDBC Driver".
Once you have followed the above information the next step is to setup your classpath on the client machine.
- On a Windows machine right click "My Computer" --> Properties --> Advanced tab--> Environment Variables--> User variables for user name -->Click new --> Specify a "Variable name" and the "Variable value" which is path you created above in step 3.
And finally instead of following the format;
Jdbd:sqlserver://[ip address]:[port];databaseName=[name]
I used Jdbd:sqlserver://[ip address], typed in my User and Password went on to the next screen and enter in my repository name as the DB name and all was well.
Hopefully this can help someone and save you the back and forth effort of trying to set this up.
Related Links
http://archiviststoolkit.org/support/userManual1_1
http://www.microsoft.com/downloads/details.aspx?familyid=e22bc83b-32ff-4474-a44a-
22b6ae2c4e17&displaylang=en
http://msdn.microsoft.com/en-us/library/ms378428%28SQL.90%29.aspx
22b6ae2c4e17&displaylang=en
http://msdn.microsoft.com/en-us/library/ms378428%28SQL.90%29.aspx
No comments:
Post a Comment