Setting the SQL DSN for KC6

Setting the SQL DSN for KC6

If running 64 bit version go to Start > and in the search field type the following:
windows\syswow64\odbcad32 and then click on the link at the top of the start menu. Proceed to step 1.


If running 32 bit system go to Start > Control Panel > Administrative Tools > Data Sources (ODBC) > 

System DSN tab > Add > SQL Server.

Name  : wkennel6


Description: Kennel Connection


Server: Click drop down and choose your SQL server.



SQL DSN




Click Next. You can set login to use either Windows NT authentication or using SQL server authentication. We recommend using SQL Server authentication. The username and password will be what you created for the SQL server. If you do not know the password, open the KC6 folder and find the wkennel.ini configuration file. Open it. At the very bottom will be the PID which is the password.


Login ID: sa
PW:  SQL PW



SQL DSN



Click Next. You will now need to change the “default database” to “wkennel”. Click the dropdown and choose “wkennel”. Then press Next.



SQL DSN



Click Finish. Then click “Test Data Source..” This should test successfully. If it does not, there is an issue with the connection to the SQL server. Check firewalls.


If it tests successfully, click ok and ok again. This will close the ODBC administrator window. Now start Kennel Connection.


    • Related Articles

    • Setting the SQL DSN for KC6 on Windows 10

      From your desktop screen, press the Windows key  + X on your keyboard to bring up the administrative menu.  Choose "Control Panel" or use the search feature built into the task bar and search for "Control Panel". In the upper right hand corner of the ...
    • Setting the Access DSN for KC6 on Windows 10

      1.  From your desktop screen, press the Windows key  + X on your keyboard to bring up the administrative menu.  Choose "Control Panel" or use the search feature built into the task bar and search for "Control Panel". 2.  In the upper right hand ...
    • Setting the Access DSN for KC6 on Windows 8

      To set the DSN for Kennel Connection 6 you can try this first. Open Kennel Connection and go to Utilities > ODBC > Reset DSN. If this succeeds, you should be able to print. If it fails, please proceed to the next step below. Open your Windows control ...
    • Setting SQL to always start with Windows

      Setting SQL to always start with Windows When using a SQL database, SQL server needs to be running in order for Kennel Connection to function.  SQL server should always start when Windows starts.  Here are the steps. Click on Start, All Programs. ...
    • Error "Microsoft ODBC SQL Server driver DBNETLIB Connection Write send" when using SQL server

      Cause 1 - This is a network drop where this computer is losing connection to the server/main computer.   Sometimes just rebooting the computer is enough to get it to reconnect.  If that doesn't work, technical support can attempt to network it again. ...