I'm trying to execute a SQL job using the SQL task. The SQL job resides on a SQL 2008 server that my connection is pointing to.

I can execute the job fine using SQL in SQL Management Studio.

However it fails when I execute the job using Visual Cron (V 5.3.1).

Here is the error message I receive. It appears it might be a problem with how it is trying to execute the job. Let me know how I can go about resolving this.

Exception in Task: The OdbcParameterCollection only accepts non-null OdbcParameter type ojbects, no OleDBParameter objects.

By the way. I am using a SQL Server connection/driver with my connection.

Are you using ODBC or Direct SQL in the Connection. It seems like you are using ODBC?

---

I thought the same thing, but I'm using SQL. I will try another SQL without using the Connection guide.

Could you export your settings and send to support@visualcron.com?

---

We looked at the Connection. It seems like, you used the connection guide and did chose: MSSQL and ODBC as Data provider. I recommend that you re-create the Connection and use MSSQL as database and MSSQL as data provider as well.

---

I had to setup the connection string manually and then was able to get this to work after a couple of tries and changes. Thanks for your help.