Timeclock Plus 5.0

Posted on 2006-05-08
Last Modified: 2011-09-20
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.
Question by:jahhan
    LVL 15

    Expert Comment

    Sounds to me like you need to contact the Timeclock vendor.

    If you have the connectionstring then post it here and we might be able to help.

    Author Comment

    I did contact the vendor but I have to pay some $$$ to get connected to their second level support.  How do I post the connectionstring?  Is that a txt file or something of that nature?
    LVL 15

    Accepted Solution

    It might be hard coded in the program.  :( :(

    This link give examples of different connection string formats.  You could look for one of these in an INI file or the registry.

    Expert Comment

    In my case there was an issue with connectivity for SQL Server. I tested by trying to connect using the tc_user login from a different computer. I kept an error that my login is not associated with a trusted SQL connection. Once I worked out the connectivity quirks I was able to login using Enterprise Manager with tc_user.

    After that everything worked fine.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now