Guest
2010-11-15T15:04:09Z
Hello,
I have installed ActiveSMS on "Server1" and is functioning fine.
I would like to install ActiveSMS Client on the "Server2", but I can not correct setup the DSN and ODBC.

Can you give me the detailed instruction, how to do it?
"Server1" is on Win2008, "Server2" on Win2003

Thank you,
Rastie.

Support
2010-11-16T10:58:40Z
To setup the ActiveSMS Client you need to setup a System DSN to point to the .mdb file on the server. The procedure as follows:

1) On the Server, create a File Share for the directory C:\Program Files\IntelliSoftware\Database.

2) On the Client, install ActiveSMS selecting the 'Client Only Components' option.

3) On the Client, map a network drive to the File Share created above (e.g. 'I:').

4) On the Client,
- open Data Source ODBC,
- Add new System DSN,
- Driver: Microsoft Access Driver,
- Data Source Name: 'IntelliSMS'
- Select the ActiveSMS database file, (e.g. 'I:\ActiveSMS.mdb')

5) To test setup, on the client, open the ActiveSMS Console and click the Test Connection button.


The configuration above using a Microsoft Access database file access via a network share. An alternative approach would be to use Microsoft SQL or MySQL database, and have the DSN on the server and client point to the same database.

Users browsing this topic