[RESOLVED] [1.0/1.1] help with publishing

[daimous]

hi guys...I published my windows application from one server and install that windows application to other machine from that publish location and the installation works fine but when I run my windows application and click the button that test the connection between the windows application and Oracle 10g Database server it gives me an error...

error:

System.Data.OracleClient requires Oracle Client software version 8.1.7 or greater

by the way, my publish settings

Publish Location: \\sharepoint\Installer
Installation Url: Blank
Install Mode and Settings: The Application is available offline as well

Application Files:
FIlename: Publish Status Download Group
Interop.WMPDXMLib.dll - Include(auto) - Required
Microsoft.mshtml.dll - Include - Required
RefNumGen.exe - Include(auto) - Required
RefNumGen.exe.config - Include(auto) - Required

Prerequisites:
Checked:
1. Create setup program to install prerequisite components
2. .NET Framework 2.0
3. Download prerequisites from the same location as my application

any help guys...

[AIS4U]

daimous:

Do you have Oracle Client software version 8.1.7 or greater
installed on the machine you are trying to run your application on?

When you use something like Access a run time is included and so the user
doesn't need to actually have Access installed. I don't think that is the case
with Oracle. I think each user of your application will have to have Oracle 8.1.7 or greater on their machine.

I'm not an expert and I may be wrong.

Perhaps someone else can correct me, if so.

Good Luck

I just noticed your other posting about transfering data and I think there was a hint of your current problem in that response:

Oracle offer a free junior burger version too. You can use it and distribute it just as you can SQL Server Express, so if you are planning to use Oracle as a back-end in production then that's a good development option.

Maybe you can get away with downloading and installing that version of Oracle???

[jmcilhinney]

I'm guessing that Oracle XE is generally intended to be installed on the machine on which the app is running, much as SQL Server Express is. If you're connecting to a proper, remote Oracle server then Oracle probably provide separate client software that must be installed on all the client machines that want to connect to that server. That client software should be included on the original installation media from which the production Oracle installation was performed, otherwise it would probably be available from the Oracle Web site. That's not definitive as it's just an intuitive assessment, but it seems plausible.

[jmcilhinney]

OK, I have it direct from an Oracle DBA that what I said before is correct. Oracle provide a client that must be installed on any system that needs to connect to an Oracle server.

[daimous]

If that would be the case then i have to install the Oracle Client to each user's computer...actually, i've already tried to install the Oracle 9i client to one of the user's computer but it install something that is not neccesary for my users like the PL*SQL and other things that may not be usefull to them...I just would to ask if there is downloadable Oracle Client that only install the things that my users need or do I just need to accept the fact that I need to install the Oracle 9i Client that comes from 1 CD to each user's computer? thanks in advance.

[jmcilhinney]

None of this is really a C# question. There's a Deployment forum and a Database forum on this site. Those with Oracle expertise could probably be most likely found in the Database forum. Also, if there's a downloadable Oracle client like you describe then it will be downloadable from the Oracle Web site.

[daimous]

I've already posted my problem at Database forum and i've also checked if the kind of package im looking for is available in oracle website but unfortunately it is not so I just have to intsall the full-blown Oracle Client 9i package to each user computer but i'll just select the components that my users will be needing and maybe i'll will install it in "Silent Mode" so that I will not be disturbing them..anyway, Thanks for that help guys!

[jmcilhinney]

You may already know about this but if not you should check out this page:

http://www.oracle.com/technology/sof...net/index.html

[daimous]

Thanks for that link.