{"id":329,"date":"2019-08-12T10:49:40","date_gmt":"2019-08-12T09:49:40","guid":{"rendered":"https:\/\/blogs.gre.ac.uk\/cmssupport\/?page_id=329"},"modified":"2019-08-12T10:49:40","modified_gmt":"2019-08-12T09:49:40","slug":"connecting-to-an-oracle-database-in-visual-studio","status":"publish","type":"page","link":"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/programming\/asp-net\/connecting-to-an-oracle-database-in-visual-studio\/","title":{"rendered":"Connecting to an Oracle database in Visual Studio"},"content":{"rendered":"\n

Note the instructions below assume you already have a database setup on the Oracle server you want to connect to. Please see the Oracle support pages<\/a>\u00a0for details on how to get an Oracle database setup for your use. <\/p>\n\n\n\n

To connect to your Oracle database bring up Server Explorer either by clicking on the tab next to the Toolbox or by going View > Server Explorer. Right click on ‘Data Connections’ then click ‘Add Connection…’ <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

On the next screen (titled ‘Choose Data Source’) change the data source by ensuring ‘Oracle Database’ is selected then click the ‘Continue’ button. <\/p>\n\n\n\n

\"Screenshot:<\/figure><\/div>\n\n\n\n

For the ‘Server name’ enter obiwan or quigon, then enter your username and MySQL password (for obiwan or quigon respectively) in the relevant fields. E.g. to connect to quigon, user sj593 would enter the following:<\/p>\n\n\n\n

\"Screenshot:<\/figure><\/div>\n\n\n\n

Click the ‘Test Connection’ button to ensure you have entered the correct details<\/p>\n\n\n\n

Assuming that you get told the test connection succeeded, click the ‘OK’ button to exit the ‘Add Connection’ wizard and you will have added a connection to the database that will appear under ‘Data Connections’ in ‘Server Explorer’, and you can then setup an SQLDataSource using this connection.<\/p>\n\n\n\n

\"Screenshot:<\/figure><\/div>\n\n\n\n

You can then setup a SQLDataSource using this connection, and use it to populate data controls such as a grid view, etc. as shown: <\/p>\n\n\n\n

\"Screenshot:<\/figure>\n\n\n\n


<\/p>\n","protected":false},"excerpt":{"rendered":"

Note the instructions below assume you already have a database setup on the Oracle server you want to connect to. Please see the Oracle support pages\u00a0for details on how to get an Oracle database setup …<\/p>\n","protected":false},"author":53,"featured_media":0,"parent":49,"menu_order":7,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-329","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/comments?post=329"}],"version-history":[{"count":0,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/329\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/49"}],"wp:attachment":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/media?parent=329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}