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

From: Ruud de Koter <nobody_at_internet.org>
Date: Wed, 19 Sep 2007 20:10:17 +0200
Message-ID: <46f165ee$0$227$e4fe514c@news.xs4all.nl>

> On 19 Sep, 11:28, Ruud de Koter <nob..._at_internet.org> wrote:

>> arun.hal..._at_gmail.com wrote:
>>> On 18 Sep, 14:13, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>>>> On Sep 18, 5:13 am,arun.hal..._at_gmail.com 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 Received on Wed Sep 19 2007 - 13:10:17 CDT