Re: C# Oracle Q (from a SQL Server point of view)

On 19 Sep, 11:28, Ruud de Koter <nob...@xxxxxxxxxxxx> wrote:
arun.hal...@xxxxxxxxx wrote:
On 18 Sep, 14:13, "fitzjarr...@xxxxxxx" <fitzjarr...@xxxxxxx> wrote:
On Sep 18, 5:13 am,arun.hal...@xxxxxxxxx wrote:
I want to be able to connect to the Oracle DB without having to make
any installations (would like to just use the dll's instead).
Installing the Oracle InstantClient might 'solve' this 'problem'. I
suggest you visitwww.oracle.comandsearch the downloads for the
InstantClient software.
I want to do this without any installations.
I dont want to make any modifications to the production server.
Any other ideas?
How are you going to get "the dll's" on the production machine (or on
any machine) without some kind of an installation process? I suggest you
think this over once again.

Regards,

Ruud de Koter.

The dll i need in C# is contained within the project i am using.
The only thing i need is the connection details (database and server)
and the only way it seems to get this information is installing the
client and then using a TNSNAMES.ora. seems like an unnecessary
process.
I guess i'll just have to do the installation then

Hi Arun,

I am by no means a specialist in what you are trying to achieve, and the experience I have in Microsoft environments mostly dates from a previous millenium. What I know about the Oracle client and the way it often/mostly operates in M$ environments, suggests it does a bit more for you than just reading the tnsnames.ora. In fact, the whole endless procession of database access technologies developed by Microsoft, are different definitions of the software interface between the (Oracle) database client and the programming environment. You *will* need the dll's that make up the Oracle InstantClient, and I was assuming those are the ones you meant.

If you google around with appropriate terms (I tried "oledb Oracle dll client"), you 'll see you 're not the first to find you *do* need an Oracle client installed.

Anyway, I 'll rephrase: re-investigate and think this over again.

Regards,

Ruud de Koter

.

Relevant Pages

  • Re: Oracle, Linux & OFA - Fevered Dreams?
    ... space for the Oracle installation using a mount point of /u01/app/ ... environmental variables for the user oracle to the values that I chose ... NEVER had such stupid problems like this with Sybase installations on ... Express on Linux a while ago. ...
    (comp.databases.oracle.server)
  • Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin
    ... If not: you could reinstall DBI and DBD::Oracle and make sure that your Oracle environment is set correctly. ... If you have multiple Oracle installations: set your $ENVusing the ORACLE_HOME with which you compiled your DBD::Oracle. ... If you have multiple perl installations (with DBI, DBD::Oracle) you may have to set the correct path to perl (first line of your script). ...
    (perl.dbi.users)
  • Re: ocp 10g or 9i
    ... There are still many 8i installations around! ... Oracle doesn't offer 8i certifications anymore. ... "If you don't eat your meat, you cannot have any pudding. ...
    (comp.databases.oracle.server)
  • Re: Cannot connec to http://localhost:5500/em on Windows XP Pro SP1
    ... of knowledge about Oracle installations made me discard it too quickly. ... There I can see the normal Enterprise Manager logon screen. ... so I got stuck into some infinite loop of em logon screens and links. ...
    (comp.databases.oracle.server)
  • Re: SMS2003 Advanced Client doesnt finish the installation
    ... Have you installed and configured the management point and server locator ... Also how did you do the client installations? ... > SMS server and services configuration. ...
    (microsoft.public.sms.setup)