Select which database is used
When you install LBE Desktop Helpdesk it will use the MS Access database called
helpdesk.mdb installed into the same directory as the helpdesk.
If you
- move the database
- create new one with a different name or location,
- wish to use MS Sql
- wish to use Oracle
then you will need to modify the database connection information in the helpdesk.
To do so, select File, Select Database from the
main menu:
Connection String
This is how the helpdesk knows which database to use and how to connect to it.
Here are some typical values:
Access
PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=C:\LBE\HELPDESK.MDB
MS Sql
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=lbe_user;Password=lbe;Initial
Catalog=LbeHelpdesk;Data Source=inspiron
- Data Source is the name of the database server.
- Initial Catalog is the database to be used
- User Id and Password are for the user you will have set up for the helpdesk
database
Oracle
Provider=MSDAORA.1;Password=lbe;User ID=lbe_user;Data Source=beq-local;Persist
Security Info=True
- Data Source is the name of the Oracle connection you must set up using the
Oracle Net 8 Easy Config.
- User Id and Password are for the user you will have set up for the helpdesk
database
Build button
You don't need to write the connection strings from scratch. Click the Build
button, select the appropriate driver, (please use an OLE DB driver), then select
the database. For both Oracle and Sql Server you will need to provide a user
id and password. Don't forget to check the box "Allow saving of password".
Database Type
Select the matching database type from the drop-down list. If you select the
wrong type for your connection string you will probably see errors when using
the helpdesk.
Installation requirements
Every machine that you use the helpdesk on must have installed the latest Microsoft
Data Access components (MDAC) from www.microsoft.com/data/download.htm. If you
intend to use Oracle you must also have installed the Oracle client tools.
| 
