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

    • 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 ...
    • OPEN VPN Certificate Expired / Expiration

      The OPEN VPN ca.crt file expired today so all OPEN VPN systems will require an updated ca.crt  Download the ca.crt file  Place it in the OpenVPN Config folder, typically here: C:\Program Files\OpenVPN\config (unless they are not on the 64-bit ...
    • MKMS Launches but does not display on screen

      This is for Stark 35.xxxx versions Below are some steps that you can go through in order to get it back to screen. If these do not help. Please let tech support know and we can connect and remove the user setting for that user so that it defaults to ...