Get free live demo
Login
Cart
Home
Home
What is VisualCron?
Why choose VisualCron?
Our customers
Testimonials
Search
Social
Technology
Features
GENERAL
Features
Screenshots
API / SDK
Technology
ARCHITECTURE
Tasks
Triggers
Connections
AUTOMATION
General automation
Task Scheduler
FTP / SFTP/ SCP automation
Batch and exe automation
PowerShell automation
Cloud automation
Business Process Automation (BPA)
Encryption automation
SQL / database automation
Web macro recorder automation
Robotic Process Automation (RPA)
Managed File Transfer (MFT)
Extract Transform Load (ETL)
PDF automation and data extraction
XML automation and manipulation
Image automation and manipulation
Office 365, Excel and Macro Automation
Sharepoint automation
Archive automation
Virtual Machine Automation
Document scanning / OCR
ABOUT VISUALCRON
VisualCron is an
Automation
,
Integration
and
Task Scheduling Tool
for
Windows
.
Get free live demo
Download
Download
Change log
Requirements
Get free live demo
Order
Order
License guide
Choosing the right license
Basic vs Pro edition comparison
Cart
Get price quote
Use PO / get invoice
Return policy
Company information
Reseller information
Partners
Get free live demo
Support
Community forum
Documentation
Video tutorials
Maintenance & priority support
Contact us
Get free live demo
My pages
Start
My profile
My contacts
My licenses
My cloud Servers
My orders
Blog
Site map
Community forum
Support
Community forum
Please note that VisualCron support is not actively monitoring this community forum. Please use our
contact page
for contacting the VisualCron support directly.
Welcome Guest! To enable all features please
Login
or
Register
.
×
Forum
Search
Login
Register
Login
×
User Name or E-Mail Address:
Password:
Caps Lock is on
Remember me
×
Forum
Support
General problem solving
ODBC Errors
ODBC Errors
Previous Topic
Next Topic
Tools
Email this topic
Watch this topic
Print this topic
rreed
No customer
Topic Starter
2010-09-01T19:47:00Z
#1
VERY new to VC, please be patient.
Recently we got a couple errors on one of our servers running VC v5.6.0. The "descriptive name" has been removed to protect the innocent. We have an ODBC connection setup for it that uses a domain username/password. We're not sure why its descriptive name showed up. The other is another error. Job failed both times.
First one happened on one day:
Error in task sql: ERROR [HY008][Microsoft] [ODBC SQL Server Driver][SQL Server]Login failed for user ‘descriptive name’.
Error [28000][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘descriptive name’.
Second one happened another day:
Error in task sql: ERROR [HY008][Microsoft] [ODBC SQL Server Driver] Operation canceled.
Quick Reply
Reply
View All Posts by User
Sponsor
Forum information
Wanna join the discussion?!
Login to your Forum forum account
or Register a new forum account
×
Support
Official support
2010-09-02T09:17:27Z
#2
Maybe your SQL Job requires domain Credentials when logging in, not just in the connection string. Then you need to create and select a Credential.
Henrik
Support
http://www.visualcron.com
Please
like
VisualCron on facebook!
Quick Reply
Reply
View All Posts by User
rreed
No customer
Topic Starter
2010-09-02T19:18:30Z
#3
Sorry forgot to mention that part, we do have it setup using domain credentials (system dsn).
It's also happened on another job.
Quick Reply
Reply
View All Posts by User
rreed
No customer
Topic Starter
2010-09-02T19:26:31Z
#4
I think I'm better understanding the problem, we have the domain user credentials we want to use for the job setup in it as well as the System DSN. We can test connection in both VC and the System DSN all day long, tests fine.
When this error happens, the error message is showing the display name of a different user. We don't know where/how the other user credentials are getting passed along.
How/why is this happening?
Edited by user
2010-09-02T19:28:51Z
|
Reason: Not specified
Quick Reply
Reply
View All Posts by User
Support
Official support
2010-09-02T19:54:11Z
#5
Did you try to create a Credential in VisualCron and select it in the Task? This way it will be passed along.
Henrik
Support
http://www.visualcron.com
Please
like
VisualCron on facebook!
Quick Reply
Reply
View All Posts by User
rreed
No customer
Topic Starter
2010-09-02T19:57:50Z
#6
Yes.
Quick Reply
Reply
View All Posts by User
Support
Official support
2010-09-02T19:59:12Z
#7
Ok, to check if it is the right Credential, try this:
1. deselect the Credential and click OK
2. stop the VisualCron service
3. double click on VisualCronService.exe in the VisualCron folder
4. Connect and try to run the Task again
Henrik
Support
http://www.visualcron.com
Please
like
VisualCron on facebook!
Quick Reply
Reply
View All Posts by User
rreed
No customer
Topic Starter
2010-09-02T20:58:36Z
#8
Sorry, once again did not understand what I was looking at. In the task itself, there is No Credential but the connection is using the ODBC System DSN we've setup.
It is already currently set not using Credential but is using the ODBC connection.
Quick Reply
Reply
View All Posts by User
rreed
No customer
Topic Starter
2010-09-02T21:46:35Z
#9
Followed instructions, task completed successfully.
Quick Reply
Reply
View All Posts by User
Support
Official support
2010-09-06T22:49:30Z
#10
Great, thanks for the update.
Henrik
Support
http://www.visualcron.com
Please
like
VisualCron on facebook!
Quick Reply
Reply
View All Posts by User
rreed
No customer
Topic Starter
2010-09-07T17:52:01Z
#11
Sorry, meant the task you had given me was complete, not our scheduled task. I normally don't suck quite this much.
Have assigned Credentials to two problematic jobs, awaiting update from user to see if it helped/fixed it.
Quick Reply
Reply
View All Posts by User
Support
Official support
2010-09-09T09:31:16Z
#12
Ok, please keep us posted.
Henrik
Support
http://www.visualcron.com
Please
like
VisualCron on facebook!
Quick Reply
Reply
View All Posts by User
Similar Topics
Problems starting job with ODBC
(
General problem solving
) by
xedarius
2009-07-15T19:45:29Z
77777 errors
(
General problem solving
) by
Support
2017-12-29T10:27:19Z
SFTP Errors
(
General problem solving
) by
Support
2016-01-22T19:30:13Z
Strange Errors
(
General problem solving
) by
Support
2010-10-05T00:27:42Z
OutofMemory Errors
(
General problem solving
) by
lal
2008-12-04T14:07:01Z
Users browsing this topic
Guest
Forum
Support
General problem solving
ODBC Errors
© VisualCron
Scroll to Top