Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

ODBC Connection failure

Issue

Datacard ID Works gives an ODBC error. Examples shown below:

Microsoft SQL Server Login
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Data Source Error
Data source name not found and no default driver specified
State:IM002,Native:0,Origin:[Microsoft][ODBC Driver Manager]

Environment

  • I/NET Seven all versions
  • Datacard ID Works video badging software

Cause

The "IDWorksView" driver uses a ODBC Connection to allow the ID Works Software to communicate to the I/NET SQL Database. If for some reason this ODBC gets corrupted, you will get an error anytime you try to run the ID Works software.

Resolution

  1. Go to Start > Control Panel > Administrative Tools
  2. Select Data Sources (ODBC)
  3. Select the System DSN tab
  4. Highlight Seven ODBC SQL Server in the list and hit the Configure button
  5. Make sure the settings are as follows:
    • Name: Seven ODBC
    • Description: ODBC Connection for I/NET Seven
    • Server: (local)
  6. Hit Next
  7. Before you actually login to this window, choose the Client Configuration button and make sure these settings are correct.
    • Network libraries: TCP/IP
    • Connection parameters: Dynamically determine port
  8. Note that the InetThirdParty password changed in I/NET Seven rev 2.4X to PassInetDb3p_SE. If you try to use this in this process it will fail on you. Instead of using the InetThirdParty and the password here, use the Username and Password that you use for the DbCreateEditor. Then select the Next button.
  9. Verify the settings below, then hit Next:
    • Change the default database to: InetDb
  10. Verify the settings below, then hit Finish
    • Perform translation for character data
Tags (1)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎2018-09-10 05:09 AM
Updated by: