{"id":405,"date":"2019-04-05T15:21:54","date_gmt":"2019-04-05T15:21:54","guid":{"rendered":"https:\/\/stoneedge.com\/kb\/?post_type=ht_kb&#038;p=405"},"modified":"2026-03-26T15:46:34","modified_gmt":"2026-03-26T15:46:34","slug":"creating-odbc-connections","status":"publish","type":"ht_kb","link":"https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/","title":{"rendered":"Creating ODBC Connections"},"content":{"rendered":"<h2>Overview<\/h2>\n<ul>\n<li>Steps needed to create an ODBC connection for an SQL database in the Windows operating system.<\/li>\n<li>This is needed to connect Stone Edge to your SQL database.<\/li>\n<\/ul>\n<h2>Opening the ODBC Controller<\/h2>\n<ol>\n<li>In finder type &#8220;ODBC&#8221;<\/li>\n<li>You may find 2 programs come up -&gt; Click: &#8220;ODBC Data Sources (32-Bit)&#8221;<br \/>\nNOTE: You may need to run this program as an administrator for the ability to make edits.<\/li>\n<\/ol>\n<p>*If you cannot find the program though the search, you can also use this direct file path: &#8220;C:\\Windows\\SysWOW64\\odbcad32.exe&#8221;<\/p>\n<h2><strong>Set up the DSN (Data Source Name)<\/strong><\/h2>\n<p>NOTE: You will need to setup an SQL server and database beforehand.<\/p>\n<div class=\"mceTemp\">\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-2341\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/DSN1.png\" alt=\"\" width=\"621\" height=\"438\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/DSN1.png 588w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/DSN1-300x212.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/DSN1-50x35.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/DSN1-60x42.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/DSN1-100x71.png 100w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/><\/p>\n<\/div>\n<ol>\n<li>Click \u201cSystem DSN\u201d from the tabs at the top and click the \u201cAdd\u201d button on the right to open the \u201cCreate New Data Source\u201d pop-up.<\/li>\n<li>Select a driver for the data source should be \u201cSQL Server\u201d near the bottom of the list.<\/li>\n<li>Click \u201cFinish\u201d to open the \u201cCreate a New Data Source to SQL Server\u201d pop-up<\/li>\n<li>Enter the required fields on the initial screen:\n<ol type=\"a\">\n<li>Create a &#8220;Name\u201d for the ODBC connection, something you will remember.<br \/>\nNOTE: Every computer that connects to the database will need a DSN, so keep the naming consistent.<\/li>\n<li>Skip the \u201cDescription\u201d<\/li>\n<li>The SQL \u201cServer\u201d to connect to is where the database is located.\n<ol type=\"i\">\n<li>The same server name is used for logging into SQL Server Management Studio.<\/li>\n<li>If you choose the wrong server name, you will eventually get an error.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<li>Click \u201cNext\u201d and choose a verification method for the login ID.\n<ol type=\"a\">\n<li>The first option uses Windows Auth if enabled and setup prior on your SQL server. If you are not able to click &#8220;Next&#8221; to move to the next sceen it is not setup properly and you may need to check your server settings.<\/li>\n<li>The second, easier option is using SQL authentication. Enter the login ID and password you created to access the SQL database in SSMS.<\/li>\n<\/ol>\n<\/li>\n<li>Click \u201cNext\u201d. If you have the correct permissions the next screen should load.\n<ol type=\"a\">\n<li>If it takes more than a few seconds, it most likely failed. You may need to try a different authorization method or change the &#8220;Client Configuration&#8221; from a Dynamic port to the Port number: 1433 (setup using SQL Server Manager).<\/li>\n<\/ol>\n<\/li>\n<li>Checkmark to \u201cChange the default database\u201d from &#8220;Master&#8221; to the database you created.<\/li>\n<\/ol>\n<p><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/DSN2.png\" alt=\"\" width=\"499\" height=\"351\" \/><\/p>\n<ol start=\"8\">\n<li>Click \u201cNext\u201d -&gt; \u201cFinish\u201d<\/li>\n<li>The \u201cODBC Microsoft SQL Server Setup\u201d pop-up will appear reviewing your choices.<\/li>\n<li>Click \u201cTest Data Source\u2026\u201d on the bottom-left of the screen.<\/li>\n<li>If the test comes back successfully (as a pop-up) click \u201cOK\u201d -&gt; &#8220;OK&#8221; and you have finished the setup.\n<ol type=\"a\">\n<li>If you are not able to get a successful message you may need to change your settings or check your network connection to the server.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Overview Steps needed to create an ODBC connection for an SQL database in the Windows operating system. This is needed to connect Stone Edge to your SQL database. Opening the ODBC Controller In finder type &#8220;ODBC&#8221; You may find 2 programs come up -&gt; Click: &#8220;ODBC Data Sources (32-Bit)&#8221; NOTE:&#8230;<\/p>\n","protected":false},"author":2,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[20],"ht-kb-tag":[160],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Creating ODBC Connections - Stone Edge Order Manager<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating ODBC Connections - Stone Edge Order Manager\" \/>\n<meta property=\"og:description\" content=\"Overview Steps needed to create an ODBC connection for an SQL database in the Windows operating system. This is needed to connect Stone Edge to your SQL database. Opening the ODBC Controller In finder type &#8220;ODBC&#8221; You may find 2 programs come up -&gt; Click: &#8220;ODBC Data Sources (32-Bit)&#8221; NOTE:...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/\" \/>\n<meta property=\"og:site_name\" content=\"Stone Edge Order Manager\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-26T15:46:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/DSN1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/\",\"url\":\"https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/\",\"name\":\"Creating ODBC Connections - Stone Edge Order Manager\",\"isPartOf\":{\"@id\":\"https:\/\/stoneedge.com\/kb\/#website\"},\"datePublished\":\"2019-04-05T15:21:54+00:00\",\"dateModified\":\"2026-03-26T15:46:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/stoneedge.com\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating ODBC Connections\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/stoneedge.com\/kb\/#website\",\"url\":\"https:\/\/stoneedge.com\/kb\/\",\"name\":\"Stone Edge Order Manager\",\"description\":\"Documentation for the Stone Edge Order Manager\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/stoneedge.com\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating ODBC Connections - Stone Edge Order Manager","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/","og_locale":"en_US","og_type":"article","og_title":"Creating ODBC Connections - Stone Edge Order Manager","og_description":"Overview Steps needed to create an ODBC connection for an SQL database in the Windows operating system. This is needed to connect Stone Edge to your SQL database. Opening the ODBC Controller In finder type &#8220;ODBC&#8221; You may find 2 programs come up -&gt; Click: &#8220;ODBC Data Sources (32-Bit)&#8221; NOTE:...","og_url":"https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/","og_site_name":"Stone Edge Order Manager","article_modified_time":"2026-03-26T15:46:34+00:00","og_image":[{"url":"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/DSN1.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/","url":"https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/","name":"Creating ODBC Connections - Stone Edge Order Manager","isPartOf":{"@id":"https:\/\/stoneedge.com\/kb\/#website"},"datePublished":"2019-04-05T15:21:54+00:00","dateModified":"2026-03-26T15:46:34+00:00","breadcrumb":{"@id":"https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/stoneedge.com\/kb\/articles\/creating-odbc-connections\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/stoneedge.com\/kb\/"},{"@type":"ListItem","position":2,"name":"Creating ODBC Connections"}]},{"@type":"WebSite","@id":"https:\/\/stoneedge.com\/kb\/#website","url":"https:\/\/stoneedge.com\/kb\/","name":"Stone Edge Order Manager","description":"Documentation for the Stone Edge Order Manager","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/stoneedge.com\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/405"}],"collection":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/comments?post=405"}],"version-history":[{"count":9,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/405\/revisions"}],"predecessor-version":[{"id":4160,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/405\/revisions\/4160"}],"wp:attachment":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/media?parent=405"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=405"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}