6 Replies Latest reply on Mar 22, 2017 9:51 AM by sdelausnay RSS
    pkumari Newbie

    Problem while executing query.

    Error.PNG

      • Re: Problem while executing query.
        pchung Collaborator

        Error Message seems to be pretty straightforward. Did you verify that you are indeed properly configured to connect to the database? Configuration section of your DataBase thing.

          • Re: Problem while executing query.
            pkumari Newbie

            I have checked my database connection and it is showing status as connected. screenshot1.PNGconnection string screen shot.PNG

            I am connecting to my local database and this is the connection url string by using this connection url string in properties it i showing status as connected.

             

            Please help me.

              • Re: Problem while executing query.
                pchung Collaborator

                Unfortunately the isConnected is not a good indicator. (Bug sorry)

                I don't see a port defined in your connection string, so I think that may need to be fixed.

                To check if you are actually connected, when you are setting up an SQL Query or Command, go to Tables/Columns tab and see if actual content shows up. If there is, you are connected.

                Also look at the application log to check for errors.

                  • Re: Problem while executing query.
                    pkumari Newbie

                    I am getting these errors:

                     

                    Async Execution Failed in Employee_test1 [The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".]

                     

                    [context: com.thingworx.webservices.context.HttpExecutionContext@140f07b][message: Unable to Invoke Service Test on Employee : The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".]

                     

                    Can you please explain more clearly how to resolve it.