Connect To Oracle without ODBC (I'm A New Guy)

[Gregg]

I am developing a VB application that connects to a Orcale database. I was
told that it is possible
to connect to an oracle datasource with out using ODBC. This application
is going to installed in several
locations and not all the user have the odbc drivers. can anyone shed any
light on this for me. I was
told that you could do it in c or c++, but I have no idea.
Any help would be great

Thanks
Gregg

hi

Usually the ODBC drivers come along with the operating system. Microsoft
provides them. Using PROVIDER just select system DSN > add
username ... at server give the oracle sid. try it out


"Gregg" <GKury@yahoo.com> wrote:
>
>I am developing a VB application that connects to a Orcale database. I
was
>told that it is possible
>to connect to an oracle datasource with out using ODBC. This application
>is going to installed in several
>locations and not all the user have the odbc drivers. can anyone shed any
>light on this for me. I was
>told that you could do it in c or c++, but I have no idea.
>Any help would be great
>
>Thanks
>Gregg
>

[Simon Sellick]

<GKury@yahoo.com> wrote:
>
>hi
>
>Usually the ODBC drivers come along with the operating system. Microsoft
>provides them. Using PROVIDER just select system DSN > add
>username ... at server give the oracle sid. try it out
>
>
>"Gregg" <GKury@yahoo.com> wrote:
>>
>>I am developing a VB application that connects to a Orcale database. I
>was
>>told that it is possible
>>to connect to an oracle datasource with out using ODBC. This application
>>is going to installed in several
>>locations and not all the user have the odbc drivers. can anyone shed
any
>>light on this for me. I was
>>told that you could do it in c or c++, but I have no idea.
>>Any help would be great
>>
>>Thanks
>>Gregg
>>
>
I don't think you can do it without the Oracle client software loaded - the
bit that uses the tnsnames.ora file entries to 'know' what an Oracle SID
means. If you discover otherwise, please do let me know!

[mister pants]

"Gregg" <GKury@yahoo.com> wrote:
>
>I am developing a VB application that connects to a Orcale database. I
was
>told that it is possible
>to connect to an oracle datasource with out using ODBC.

It is indeed, and anyway using ODBC is old-hat nowadays. You can use Oracle
Objects for OLE ("OO4O"), or use an Oracle OLEDB Provider (Micro$oft$ one
works fine). There's probably one on your machine, if not install the latest
version of MDAC from Micro$oft.

Here's a handy tip, create a new file with a .UDL extension (i.e. 'x.udl'),
then double-click on it. That runs the Microsoft data link dialog, where
you can see what OLEDB providers are installed, and can test their connectivity.

This application
>is going to installed in several
>locations and not all the user have the odbc drivers. can anyone shed any
>light on this for me.


Each machine will still need the Client Tools configured (from you Oracle
CD).

I was
>told that you could do it in c or c++, but I have no idea.

You can use OO4O or ADO drivers from just about any language. I'd rather
force a large spike through my head than program in C++