How to setup ODBC Driver/Connection 64 bit

How to setup ODBC Driver/Connection 64 bit

How to setup your ODBC?

  1. Search your Start Menu in Windows for ODBC

  1. Select Add

  1. Select SQL Anywhere 17 (If not listed please select the next SQL Anywhere available)

  1. Select ODBC Tab:
  • Data Source Name: Your Database Name (MKMSDEFAULT)
  • Check Microsoft Applications & Delphi Applications

  1. Select Login Tab:

User ID: Enter your MKMS Username 

Password: MKMS Password

Action: Connect to a running database on another computer.

Server Name: Your server name. (MKMS)

Database Name: Your database name (MKMSDEFAULT)

  1. Once all required tabs are filled out. Go to ODBC Test Your connection

If test is Successful then congratulations your ODBC has been setup!

    • Related Articles

    • Native DB Connection Parameters

      The Micro Key management series of applications uses Native DB connections that can be defined by the ConnManager.exe application. This is just a brief guide that may help someone understand how our applications connect to the Sql server and it may ...
    • Employee Rights / Permissions in MKMS (Form Access Rights)

      Setting Employee Permissions ❑Almost every Screen Page (Form) within the Micro Key Millennium Series (MKMS) - whether used for data entry, look-up, or printing a report - also has an associated Form Name. •The associated Form Name may, or may not, be ...
    • Workstation Install (v8252 and Above)

      Workstation Install (v8252 and above) Steps Run the MKSSetup.exe as admin Select Next When it prompts you for the above, select No. In the next prompt screen above, select Next In the screen above, check the box highlighted and select Next If you are ...
    • Cluster Failover Procedure (MKSCluster.exe)

      Cluster Fail-over Procedure and Recovery When the system is operating normally the servers should be running the following applications. Primary Server (the server actively running the SQL Anywhere Server - database server engine), and Signal ...
    • Mobile VO validated error troubleshooting

      Make they are all a T or A (Tech or All) Make sure they have a schedule under employee -- Tech/Employee module for days, time in and time out This script may help you below :     select               --      7210 as [Subject],           --  7210 as ...