Visual Studio - ClickOnce Oracle Client ?

finance_teacher
finance_teacher used Ask the Experts™
on
I did the below steps, but get a
"System.data.oracleclient requires oracle
client software version 8.1.7 or greater" error.

How can I include in my APP without having to
manually install the "OracleClient" on 200+ PCs ?
----------------------------------------------------
Steps
 1. create new C# dot net 3.5 WinForms APP
 2. add "New Item", "Data", "DataSet"
 3. open Server Explorer WINDOW, "Connect to Database", "OracleClient"
 4. drag table onto "DataSet1.xsd"
 5. open "Form1.cs", open Data Sources WINDOW
 6. drag table onto "Form1.cs"
 7. deploy APP via ClickOnce
 8. get above error on some client PCs
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
In references, can you change Copy Local to yes for that assembly?
Most Valuable Expert 2012
Top Expert 2014

Commented:
In the Publish tab (which you use for ClickOnce) of project properties, click on Application Files button. Against the Oracle DLL, select "Include" from the list.

Author

Commented:
I have both of the above done, but it still gives the same error.

How can I package Oracle CLIENT with my ClickOnce install ?
references.jpg
appFiles.jpg
Most Valuable Expert 2012
Top Expert 2014
Commented:
You are using the Microsoft Oracle driver. Try downloading ODP.NET.

http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

Author

Commented:
I added the four attached DLLs, republished, and it seems to work.

Am I missing anything ?
s001.jpg

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial