{"id":24318,"date":"2022-02-02T14:30:23","date_gmt":"2022-02-02T14:30:23","guid":{"rendered":"https:\/\/1-grid.com\/knowledge\/plesk-accessing-databases-with-odbc\/"},"modified":"2023-10-19T12:59:29","modified_gmt":"2023-10-19T12:59:29","slug":"plesk-accessing-databases-with-odbc","status":"publish","type":"ht_kb","link":"https:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/","title":{"rendered":"Plesk: Accessing Databases with ODBC"},"content":{"rendered":"

This article provides you with information on how to access your database using ODBC connection.<\/p><\/blockquote>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

If your application needs to access external databases through ODBC, you can create the necessary ODBC connection in Plesk. After you have created the ODBC connection, you can customize the application to use that ODBC connection to access information in the database.<\/p>\n

Note that the database does not necessarily need to be external; ODBC can be used to access local databases as well.<\/p>\n

To create a new ODBC connection to a database:<\/strong><\/p>\n

    \n
  1. Go to Websites & Domains<\/strong> and click ODBC Data Sources<\/strong>.<\/li>\n
  2. Click Add ODBC DSN<\/strong>.<\/li>\n
  3. Specify the ODBC connection name and description in the corresponding fields.<\/li>\n
  4. Select the required driver in the Driver<\/strong> field.<\/li>\n
  5. Click OK<\/strong>.<\/li>\n
  6. Choose the appropriate options on the driver configuration screen. Typically, you should specify the path to the database, user credentials and other connection options, depending on the selected driver.<\/li>\n
  7. Click Test<\/strong> to check whether the connection will function properly with provided settings. Click Finish<\/strong> to complete the creation.<\/li>\n<\/ol>\n

    <\/p>\n

    To change settings of an existing ODBC connection:<\/strong><\/p>\n

      \n
    1. Go to Websites & Domains<\/strong> and click ODBC Data Sources<\/strong>.<\/li>\n
    2. Click the required connection name in the list.<\/li>\n
    3. Change the settings as needed.<\/li>\n
    4. Click Test<\/strong> to check whether the connection will function properly with new settings. Click Finish<\/strong> to save changes.<\/li>\n<\/ol>\n

      To remove an ODBC connection:<\/strong><\/p>\n

        \n
      1. Go to Websites & Domains<\/strong> and click ODBC Data Sources<\/strong>.<\/li>\n
      2. Select the checkbox next to the connection you want to remove.<\/li>\n
      3. Click Remove<\/strong>, confirm the removal and click OK<\/strong>.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

        This article provides you with information on how to access your database using ODBC connection.       If your application needs to access external databases through ODBC, you can create the necessary ODBC connection in Plesk. After you have created the ODBC connection, you can customize the application to…<\/p>\n","protected":false},"author":21,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[1174],"ht-kb-tag":[55,270,480,684,747,1106],"class_list":["post-24318","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-hosting","ht_kb_tag-access","ht_kb_tag-database","ht_kb_tag-how-to","ht_kb_tag-odbc","ht_kb_tag-plesk","ht_kb_tag-web-hosting"],"yoast_head":"\nPlesk: Accessing Databases with ODBC - 1-grid Knowledge Base<\/title>\n<meta name=\"description\" content=\"Access databases with ODBC in Plesk effortlessly with our step-by-step guide: 1-grid Knowledge Base\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Plesk: Accessing Databases with ODBC - 1-grid Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"Access databases with ODBC in Plesk effortlessly with our step-by-step guide: 1-grid Knowledge Base\" \/>\n<meta property=\"og:url\" content=\"https:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/\" \/>\n<meta property=\"og:site_name\" content=\"1-grid Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/1grid.co.za\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-19T12:59:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33049516282\/original\/cocKnx4HU3hY19znz35yyEV2MXjes7RQIw.png?1605090763\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@1grid_hosting\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/\",\"name\":\"Plesk: Accessing Databases with ODBC - 1-grid Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\"},\"datePublished\":\"2022-02-02T14:30:23+00:00\",\"dateModified\":\"2023-10-19T12:59:29+00:00\",\"description\":\"Access databases with ODBC in Plesk effortlessly with our step-by-step guide: 1-grid Knowledge Base\",\"breadcrumb\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/1grid.co.za\/knowledge\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Plesk: Accessing Databases with ODBC\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"contentUrl\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"width\":100,\"height\":100,\"caption\":\"1-Grid Domain Hosting Knowledge Base\"},\"image\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/1grid.co.za\/\",\"https:\/\/twitter.com\/1grid_hosting\",\"https:\/\/www.instagram.com\/1grid_hosting\/\",\"https:\/\/za.linkedin.com\/company\/1-grid\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Plesk: Accessing Databases with ODBC - 1-grid Knowledge Base","description":"Access databases with ODBC in Plesk effortlessly with our step-by-step guide: 1-grid Knowledge Base","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:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/","og_locale":"en_US","og_type":"article","og_title":"Plesk: Accessing Databases with ODBC - 1-grid Knowledge Base","og_description":"Access databases with ODBC in Plesk effortlessly with our step-by-step guide: 1-grid Knowledge Base","og_url":"https:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/","og_site_name":"1-grid Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/1grid.co.za\/","article_modified_time":"2023-10-19T12:59:29+00:00","og_image":[{"url":"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33049516282\/original\/cocKnx4HU3hY19znz35yyEV2MXjes7RQIw.png?1605090763"}],"twitter_card":"summary_large_image","twitter_site":"@1grid_hosting","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/","url":"https:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/","name":"Plesk: Accessing Databases with ODBC - 1-grid Knowledge Base","isPartOf":{"@id":"https:\/\/1grid.co.za\/knowledge\/#website"},"datePublished":"2022-02-02T14:30:23+00:00","dateModified":"2023-10-19T12:59:29+00:00","description":"Access databases with ODBC in Plesk effortlessly with our step-by-step guide: 1-grid Knowledge Base","breadcrumb":{"@id":"https:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/1grid.co.za\/knowledge\/plesk-accessing-databases-with-odbc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/1grid.co.za\/knowledge\/"},{"@type":"ListItem","position":2,"name":"Plesk: Accessing Databases with ODBC"}]},{"@type":"WebSite","@id":"https:\/\/1grid.co.za\/knowledge\/#website","url":"https:\/\/1grid.co.za\/knowledge\/","name":"1-Grid Domain Hosting Knowledge Base","description":"","publisher":{"@id":"https:\/\/1grid.co.za\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/1grid.co.za\/knowledge\/#organization","name":"1-Grid Domain Hosting Knowledge Base","url":"https:\/\/1grid.co.za\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/","url":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","contentUrl":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","width":100,"height":100,"caption":"1-Grid Domain Hosting Knowledge Base"},"image":{"@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/1grid.co.za\/","https:\/\/twitter.com\/1grid_hosting","https:\/\/www.instagram.com\/1grid_hosting\/","https:\/\/za.linkedin.com\/company\/1-grid"]}]}},"_links":{"self":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24318","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/comments?post=24318"}],"version-history":[{"count":1,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24318\/revisions"}],"predecessor-version":[{"id":29461,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24318\/revisions\/29461"}],"wp:attachment":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/media?parent=24318"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-category?post=24318"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-tag?post=24318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}