Database Type:

Select the type of database you want to use. We recommend to use a MS SQL Server, because it offers the best data access and scan performance and it has no standard size limitation (MS Access database files are limited to max. 2GB).

MS Access:

To use an MS Access database, you have to enter the full path of the used database file (".mdb" file) into the "File name" field. You can also browse for the file through the button right of this field, or create a new file with the button beneath. By default the path of the provided database file ("<COMMON APPDATA>\JAM Software\SpaceObServer\SpaceObServer.mdb") is entered here.

MS SQL Server:

If you choose to use a SQL Server database, you have to enter the name of the database server into "Server name". Through the drop down box you get a list of all accessible SQL Servers in your network.
Note: Sometimes not all SQL servers can be listed. If your server is not listed, please type its name manually into the field! When you have selected a server you may select a database on this server using the "Database" drop down box. If you do not select a database, the default database of the selected database user is used.

IBM DB2:

To connect to an IBM DB2 database you have to enter the name of the server, where DB2 is running, into 'Server name'. Enter the name of the database you want to use on this server into "Database".

Oracle:

To connect to an Oracle database you have to enter the name of the server, where Oracle is running, into "Server name".
Note: You can not use Windows integrated security in combination with an Oracle database.

My SQL:

Since ADO dose not provide a usable provider for My SQL we use an ODBC data source to connect to My SQL server. What you need is an installed My SQL ODBC driver, like MySQL Connector/ODBC. You can download this driver for free from the My SQL home page: dev.mysql.com
Note: SpaceObServer needs the 32 Bit version of ODBC drives, even on 64 Bit systems!
Please enter the name of your My SQL server into the "Server name" field. Then configure your SQL server Authentication in the "Login info" section. You should now be able to select the database to use in the "Database" drop down box.
Note: You can configure the used MySQL Connector (If you have more than one installed) and the My SQL port by clicking the button next to the "Server name" field.

Firebird:

Since ADO dose not provide a provider for Firebird we use an ODBC data source to connect to a Firebird database. You need to install the Firebird/Interbase ODBC driver. Please download the driver for free from the  Firebird home page: www.firebirdsql.org
Note: SpaceObServer needs the 32 Bit version of ODBC drives, even on 64 Bit systems!
Please enter the full path of your Firebird database into the "File Name" field. Then configure your SQL server Authentication in the "Login info" section.
Note: You can configure the used Firebird ODBC driver (If you have more than one installed) by clicking the button next to the "File Name" field.

Login info:

Select the security mode for the database access. You can choose between the "Windows Authentication" (the currently logged in user account is taken for database access), or you can enter a specified database user account into the "User Name" and "Password" field.
Note: "Windows Authentication" is only available for Microsoft base database Systems, MS SQL Server and MS Access.

Test Connection:

By using this button you can test if the database settings you entered are valid.

Download free MS SQL Server 2008 Express:

With this link you can download and install the "Microsoft SQL Server 2008 Express Version" from the Microsoft download center (See: MS SQL Server 2008 Express).