Data Source name not found and no default driver specified. SQLState=IM002

Data Source name not found and no default driver specified. SQLState=IM002

Error
"Data Source name not found and no default driver specified. SQLState=IM002" when trying to run any reports
Resolution
  1. Go to the Connector
  2. Find the connection the report with the error is running off
  3. Ensure the report is on the correct connection type
Note: For ABM Users - this error is often related to the ABM Auto-connection being located on the System DSN connector. To resolve:
  1. Open the Connector Module
  2. Double Click Enterprise
  3. Double Click System DSN
  4. Right Click Once on ABM (or the connection that appears)
  5. Select Move To
  6. Select ODBC Driver for SQL Server
  7. Try running your reports again


    • Related Articles

    • Changing Tenant Name in MYOB Advanced

      Problem: You have included an invalid symbol or would like to change the Tenant Name for your company in MYOB Advanced. Resolution: Login to MYOB Advanced In the Search Box, type Tenant to bring up the Tenants List Select the appropriate company from ...

    • Modelling Data using the RESTful ODBC Driver

      To model the table's column-information in the desired way, you need to first generate the schema of your data source. Add the below connection parameter in the DSN Manager of your connection wizard:     Generating Schema Files Under the Connection ...

    • Minimum Role Requirements for using Velixo Reports

      Overview At the most basic level, Velixo is governed by the same access rights as MYOB Advanced.  So if you want to control access to various Velixo features, you can do so by controlling access to the screens used for those elements in MYOB ...

    • Scheduling Alchemex Reports

      You would like your reports automatically emailed to particular users across your organisation It’s time to stop manually distributing your reports and start saving time by scheduling your reports to automatically distribute themselves.  In this tip, ...

    • Windows 10 Metadata directory access

      ISSUE: Users are unable to run out reports due to them not being available in report manager. Users receive an error when opening or using Security Manager "Operation must use an updateable query." If our metadata repository folder is created by an ...