Timeclock Plus 5.0
Posted on 2006-05-08
I recently installed Timeclock Plus 5 on a Windows 2000 server which also has SQL 8. Originally Timeclock 4 was installed which utilized MSDE. After upgrading to Timeclock 5 we switched the storage method to SQL. Intranet clients are able to run the client executable in order to log in and out of the system, but Internet users are unable to connect to the Timeclock server. They receive an error message of 'Open failed: invalid connection string attribute'. Before upgrading Timeclock 4 Internet clients were able to access the server by port 9001, but now with the upgrade they are unable to. I checked the SQL database and I noticed that the port number it was listening to requests on was on port 1433. I updated my firewall settings to include port 1433 so external Timeclock users requesting access would be permitted to key in there hours of work. Unfortunately this change did not resolve my problem. I am not to familiar with SQL so I am in need of some assistance.