Can not connect to SQL database using "Execute Query"

[tcrz24 (Taylor)]

Before i begin, i’ve done some research here and it seems that all issues/solutions similar to my problem have to do with Oracle and ODBC. This is not my case as i am strctly using SQL.

Above is the error i am getting when trying to execute my query.

Any help is appreciated. Thanks!

[AshwinS2 (Ashwin S)]

hi @tcrz24

Have you use connect activity and check the query

Thanks
Ashwin S

[sreekanth]

@tcrz24 ,You did not pass the variables correctly to the query.Refer this

How to Pass variable to sql execute query?

I realized my earlier answer is different based on the type of database/connection. My earlier answer with the ‘?’ was for an ODBC connection. For SQL you do use the usual ‘@argument’ in your statement. Do you have var1 in the input paramaters? Make sure you have var1 in there and no misspellings (I believe it is case sensitive, but can’t remember). Then type in “select column1, column2 FROM table where column1 in @var1” If that still isn’t working, try this instead: “select column1, column2 …

[tcrz24 (Taylor)]

Yes, the connect activity was tested sucessfuly.

[tcrz24 (Taylor)]

I don’t believe this is what i’m looking for, but i tried many of the different solutions in that thread anyways with no luck. I am still getting the error.

[tcrz24 (Taylor)]

Solved: It was a simple connection timeout issue.