Forum Discussion
Can't connect to Oracle Database from Microsoft Report Builder
- 5 years ago
OK Here is an update. First, many thanks to v-deddai1-msft
Here are the steps I followed one by one to solve my problem. Please Read them first, then execute. Otherwise you will get lost and get into trouble.
1- Delete any reference to oracle packages in machine.config:
See this article to find machine.config
.net - Where Is Machine.Config? - Stack Overflow
- Please becareful not delete parent section of the reference. e.g. see below:
<system.data>
<DbProviderFactories>
"Some Add elements"
</DbProviderFactories>
</system.data>- So you need to delete what's inside DbProviderFactories tag, not the whole tag.
2- Go the location of the oracle installation, and delete eveyerthing. Usually it is something like:
C:\app\client\product\12.2.0
-So what I did is I deleted the whole app folder.
3- Go to environment variable and delete the references to the oracle drivers. Below screenshot should say all:
4- Go to this article below. For your laptop / work computer, install 32 bit and 64 but execute the command lines for managed 32 and unmanged 64. I had report builder (32bit uses managed) and Power BI Desktop (64 bit uses Unmanged).
-Please don't use codes you find on the forum. Only use codes from the article.
5- On the server just install the 64 bit. But execute commands for both managed and unmanaged. The article above will explain it all.
6- If you have .Net applications in Visual Studio, please make sure they use the same version of oracle packages from Nuget that you installed.
Few Final notes:
A- Try to have the same version on server and on your development laptop. This will be very important if you have .Net apps. Otherwise your apps won't run if they refrence a higher version and on the server you have a lower version. or Atleast that's my experience.
B- I used the oracle (.exe) installer for 64 bit and 32 bit. Please run it as Admin otherwise it will throw an error. I never needed to use XCopy and I don't think you need that.
Connect Database Using The Direct Connection Method
This method works with all the versions of Oracle Forms builder above 6i. The steps are as follows:
- In Oracle Forms builder, click on the File menu and then click Connect option.
- Then in the Connect window, provide the username in the Username field.
- Provide a password in the Password field.
- In the Database field, provide the information using the format IP-Address:Port/OracleSID. For example, 123.456.78.9:1521/ORCL.
- Then click on the connect button to connect the database.
This May Work,
Peter