Invalid Connection on SQL task - VisualCron - Forum

Community forum

rgepfert
2008-07-23T17:50:31Z
I am trying to set up a simple database task. I have the connection string correct, but it gives me the error "Invalid Connection". Is this a permissions issue? Also, I want to create an Oracle task, but everytime I select the Oracle connection in the drop down and save it reverts back to a SQL Server option
Support
2008-07-23T17:57:48Z
The list you are talking about is just a example list of connnection strings. We are currently working on a new version which will help you further identify and test your string. You can go to http://www.connectionstrings.com  to try finding the exact connection string.

Remember that it is the textbox with the connection string that is important. Not the list above.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
rgepfert
2008-07-23T18:01:22Z
yes, I did select SQL Server (Standard) from the dropdown and I put the connection string in the textbox that should connect to my database, but when I try to test the job it is giving me Invalid Connection
Support
2008-07-23T18:06:22Z
SQL server (standard) is not refering to Oracle but MSSQL. Look here for Oracle connection strings:

http://www.connectionstrings.com/?carrier=oracle 

You have to cut/paste the connection string based on the provider (ODBC or OLEDB).
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top