Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


Tillman Stevens
2017-04-06T18:56:33Z
Using Visual Cron Version 8.2.4, Build 18573

Attempting to connect to an access database. I tried creating a connection using Windows 7 Control Panel > Administrative Tools > ODBC, then adding a connection in VisualCron pointing to the existing connection and selecting the ODBC connection. Testing the connection returns the following error: "Connection test failed. Error: ERROR [IM002][Microsoft][ODBC Driver Manager][Data source name not found and no default driver specified"

I have also attempted to create a connection as follows:
Use Connection Guide
Storage Type: File
Database Type: Access
Data provider: ODBC
Driver: {Microsoft Access Driver (*.mdb)}
DBQ: C:\Nil\Nil.mdb

Again, when I test the connection, the following error occurs: "Connection test failed. Error: ERROR [IM002][Microsoft][ODBC Driver Manager][Data source name not found and no default driver specified"
Sponsor
Forum information
Support
2017-04-10T14:32:13Z
Try first, in Windows ODBC window, to setup the ODBC connection in the SYSTEM DSN. Only when placed there it will be visible by VisualCron.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Tillman Stevens
2017-04-10T14:43:09Z
That was the first thing I did. Just tried it again, same error.
Support
2017-04-10T15:44:43Z
Could you add some screenshots of the db settings?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Tillman Stevens
thomas
2017-04-12T08:55:32Z
Tillman Stevens
2017-04-13T17:32:48Z
Where do I find that?

I have attempted creating both 32bit and 64bit ODBC connections, both failed, however, I am able to connect using the ODBC data sources using software other than VisualCron. The error only occurs in visualcron.
Support
2017-04-14T14:11:00Z
Yes, you need the 64 bit drivers as VisualCron will run in 64 bit mode. That is probably the problem!
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Tillman Stevens
2017-04-14T14:20:39Z
I installed the 64 bit access drivers before my last attempt, posted above.
Support
2017-04-14T14:26:09Z
Originally Posted by: Tillman Stevens 

I installed the 64 bit access drivers before my last attempt, posted above.



But is the ODBC connection setup in 64 bit mode and uses the 64 bit driver?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top