The path might vary as per your installation directory. Go to the command Prompt (Run as Admin) -> and then run the following command. To do that we need to register the OraOLEDB driver. The same test connection, we will now be doing in SSRS. Please note that here we are using the OLE DB driver.ħ. You can do the test connection by following the below screenshot. After creating the Reporting Services Project, you need to do the test connection. Create a Report Server Project –> File-> New -> Project -> Reporting Services -> Report Server ProjectĦ. The next step is to test the connection from Visual Studio and SSRS.ĥ. So, we have now successfully installed the Oracle drivers. The format of tnsnames.ora file as below- Ref: Once the 32 bits and 64 bits driver installations are done, you need to place the tnsnames.ora file in the following locationĮ:\app\client\xxxx\product\12.2.0\client_1\Network\AdminĮ:\app\client\xxxx\product\12.2.0\client_2\Network\Admin You can check the same going to the My computer -> Properties -> Advance System setting -> Environmental Variables -> System Variables -> Pathģ. During the installation, it was already done. No need to update any environmental variable. For me, the installation folder asĮ:\app\client\xxxx\product\12.2.0\client_1 (32 bits)Į:\app\client\xxxx\product\12.2.0\client_2\ (64 bits)Ĭlient_#, the number will change according to your installation order. You need to note down where the oracle driver is getting installed, you need to place the tnsnames.ora file in that location which we will discuss later. Once you double click on that, you will get the information on GUI which is self-explanatory. After uncompressing the file, you will see the installer file. (Download link available during the time the blog had been written)Ģ. Please note that we need to check for the installer which has the OLE DB/ ODP. We need to go to the Oracle official site to search for the drivers for the required version. Since we are in the same system, we need to install both the bit-ness of Oracle drivers one by one. SSDT runs in 32 bit whereas SSRS runs in 64 bit. SSRS – SQL Server Reporting Services 2014.ġ. It means SSDT and SSRS both are installed in the same system. We would be using a single system to develop the report using SQL Server Data Tools (SSDT) and host the report in Report Server. In this blog, we will go through the ODAC driver installation and configuration with the SQL Server Reporting services (SSRS) data source to connect Oracle data source using Oracle native driver. exe installer to install the Oracle related drivers as we are more comfortable with the Windows MSI installers. It varies across the Oracle versions, and the type of installer that we would need. In general, there are several links available to download the ODAC components from the Oracle official site.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |