ODBC

[s_radhak]

I tried to connect to Oracle using "Microsoft ODBC for Oracle".

Tried to add a DSN using the same driver and it tells me that I need to install Oracle Client (specifically Net8) for this to work.

Does this mean that I have to install Oracle Client on every users machine?????????

I thought we could connect to Oracle database thro' a ODBC data source without installing Oracle Client on every users machine.

Any help is appreciated..

Thank you.

[marist89]

Yup, you must install the Oracle Client.

[s_radhak]

That's weird...

I was under the impression that I don't have to install Oracle client and connect to the database thro' ODBC.

Any other way or suggestions...........

[marist89]

JDBC Thin drivers

[JMac]

Jeff,
I'm a bit of a thicko with all this ... what are JDBC thin clients? Jave connectors???

-------------------------------------

John

[marist89]

Yes JDBC stands for Java Database Connectivity. The JDBC drivers come in two "flavors", Thick & Thin. The Thick drivers require the Oracle client to be installed but you can use more features of Net8. The Thin drivers don't require the Oracle client to be installed, but you can't use all the features of Net8. (Although, I have found the JDBC Thin driver has pretty much all the functionality you need...)

[s_radhak]

Where can I install the JDBC driver from?

[pshea]

You can download these (and other stuff) at:


http://otn.oracle.com/index.html