{"id":2083,"date":"2023-07-16T01:53:56","date_gmt":"2023-07-16T00:53:56","guid":{"rendered":"https:\/\/bidynamics365.com\/blog\/?p=2083"},"modified":"2023-07-16T01:53:56","modified_gmt":"2023-07-16T00:53:56","slug":"solved-system-data-oracleclient-requires-oracle-client-software-version-8-1-7-or-greater","status":"publish","type":"post","link":"https:\/\/bidynamics365.com\/blog\/?p=2083","title":{"rendered":"Solved: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater."},"content":{"rendered":"\n

Happy to connect again in this wonderful blog post.<\/p>\n

In the past few weeks, I got a chance to work on the data migration project. I was trying to connect the Oracle database using Ado.Net connection manager in SSIS package and received following error.<\/p>\n

\n

Test connection failed because of an error in initializing provider. System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.<\/strong><\/em><\/p>\n<\/blockquote>\n

You may have get an error screenshot like below.<\/p>\n\n\n\n

\"\"<\/a><\/p>\n\n\n\n

I have tried installing various dll’s based on the articles and suggestions.\u00a0 I will share here what worked for me and without conflicting with other Ado.net sql connection manager.<\/p>\n

After multiple tries, I have figured out that Oracle Data Access Components (ODAC)\u00a0<\/b>components required for make it work. Download the Oracle Client for Microsoft Tools <\/strong>both 32 bit and 64 bit exe and install the 32 bit first and 64 bit next. <\/span><\/p>\n

Download Link:<\/strong> <\/span>https:\/\/www.oracle.com\/database\/technologies\/net-downloads.html<\/a><\/p>\n\n\n\n

\"\"<\/a><\/p>\n\n\n\n

Hope this blog post puts someone in need in right direction and not wasting any time further on the installations.<\/p>\n\n\n\n

As always, if you need any assistance, Please don’t hesitate to reach me.<\/p>\n","protected":false},"excerpt":{"rendered":"

Happy to connect again in this wonderful blog post. In the past few weeks, I got a chance to work on the data migration project. I was trying to connect the Oracle database using Ado.Net connection manager in SSIS package and received following error. Test connection failed because of an<\/p>\n","protected":false},"author":3,"featured_media":2093,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[2,122,9],"tags":[259,260,258,256,257,61,261],"class_list":["post-2083","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-integration","category-snippets","category-ssis","tag-ado-net","tag-initializing-provider","tag-installation","tag-odac","tag-oracle-data-access-components","tag-ssis","tag-system-data-oracleclient"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/bidynamics365.com\/blog\/wp-content\/uploads\/2023\/07\/devenv_L5Tu5PJD88-1.png","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/bidynamics365.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2083","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bidynamics365.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bidynamics365.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bidynamics365.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bidynamics365.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2083"}],"version-history":[{"count":8,"href":"https:\/\/bidynamics365.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2083\/revisions"}],"predecessor-version":[{"id":2094,"href":"https:\/\/bidynamics365.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2083\/revisions\/2094"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bidynamics365.com\/blog\/index.php?rest_route=\/wp\/v2\/media\/2093"}],"wp:attachment":[{"href":"https:\/\/bidynamics365.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bidynamics365.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bidynamics365.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}