Skip to Main Content
  • Questions

  • Required components for client-side access to DB....

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Ken.

Asked: August 01, 2000 - 8:36 am UTC

Last updated: July 07, 2007 - 10:38 am UTC

Version: 7.3.3

Viewed 1000+ times

You Asked

We are running Financials 10.7 (Inventory, Order Entry, and
Purchasing) in 7.3.3 in HP-UX environment. User access is thru
Web Server 3. I and one other developer have client/server
access to SQL*Plus thru SQL*Net.
I developed and am running numerous Crystal Reports for
distribution. I want to enable user access to such reports, but
cannot do so over the web. We do not want to load client
components on users' PCs that they won't use. All they need is
to be able to hit the DB.
Crystal has native Oracle drivers. I am thinking that all I
need to load on PCs is sqlnet, listener, and tnsnames .ora files.
Is my assumption correct? Any online docs that address this
issue?

Thanks in advance. Ken Banyas

and Tom said...

You need to do a client install on those clients. We put various components into the registry and the are a variety of .dll's needed for SQLNet support. When Crystal reports says they have a native driver -- what they mean is they use OCI directly and not ODBC for performance. Regardless of whether they use ODBC or OCI, they still need SQLNet.

So you need to install sqlnet -- not just the sqlnet.ora file -- on the client machines. You'll do a minimal install of just sqlnet (no sqlplus or anything they do not want) on the client machines.

Rating

  (6 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

error ..

atul, January 07, 2003 - 6:32 am UTC

Sir,

I'm using oracle 8.1.6...and users using crystal report 8
to get the report..

On one client we installed oracle client and crystal reports
we can connect to oracle from that client...but for getting crystal reports it gives error like

"ERROR: ([Microsoft][ODBC Driver Manager] Data source name not found and no default driver"

it also shows some crora8.dll which gets installed when crystal reports installation...

How to get solution??

Thanks.
atul




Oracle ODBC Driver

Sujata, June 16, 2003 - 5:33 pm UTC

OS: Windows XP and 2000

Tom,

O.K. One of the client machine has Oracle 8 client (client needs it for lot of other apps that they access) installed on it (XP Machine)...and we need to give client access to Oracle 8i database through an Access database app.
ODBC driver that came with Oracle 8 as well as the "Microsoft ODBC driver for Oracle"
are not working (giving ODBC failure error)..
We have succesfully made it work with Oracle 8i client (Oracle ODBC driver)..on another machine.

Question: Can we install the latest Oracle driver (Oracle ODBC Driver for Rdb , Release 3.0.2.6 for Windows)...not the client...just the driver...
Will this mess up the existing registery or dlls...
or do we need to install the whole Oracle 8i client (in a separate home ofcourse)...and will that mess up the existing Oracle 8 dlls...please recommend..

Thanks a bunch..


Tom Kyte
June 17, 2003 - 7:09 am UTC

sorry -- you lost me back at "ODBC failure error" :) odbc drivers do in fact work, you've done something wrong.


ODBC is just an api, it requires the underlying client support. If you put an rdb odbc adapter on there but no rdb client code -- well, you won't get to rdb.

as for messing up the registry or dlls, as I recall, that happens every time you install virtually anything on windows?



Oracle ODBC & RAC9i

Eduardo, December 21, 2004 - 2:22 pm UTC

Dear, I´ve a very big problem. I installed Oracle ODBC 9.2.0.6 and our own application on a server. This application uses this ODBC for connecting to our business database. This database is installed on RAC9i environment. Well, our application shows on his log file the following error: "Unable to connect SQLState=08004 [ORACLE][ODBC][Ora]ORA-01033: ORACLE initialization or shutdown in progress" but the alert.log doesn´t show nothing about this. Are we losing the "power" of RAC9i?

Can you help me?

Tom Kyte
December 21, 2004 - 3:08 pm UTC

It means what it says -- the database to which you are connecting to is either being started or shutdown.

eg: if you log into the server and try to get into the database just using good ol sqlplus, what then?

Oracle ODBC & RAC9i

Eduardo, December 21, 2004 - 6:28 pm UTC

Yes, I can get into the database and query any v$ view or any table. I think that the database is work fine. But now, I´m still at home and when I return to my office I'll see if the RAC9i´s instances are "desincronizated" using the svrctl command to review the configuration and I´ll update this review with the information. Is it probably the mistake?

Tom Kyte
December 21, 2004 - 7:24 pm UTC

or the odbc connection you've set up isn't pointing to the same database you think it should be...

oracle 9i connectivity...

Perumal, August 24, 2006 - 12:20 pm UTC

Hi Tom


front end : VB 3.0
back end : Oracle 9.2 ( server) on SOLARIS
: Client Oracle 7


when connecting Vb 3.0 application with oracle 9.2 databse through oracle 7.1 client
we got the following error

ERR #3146 ODBC-- call failed.
[Microsoft][ODBC DLL] Driver'SQLSetConnectoption failed[Oracle][Driver not capable]
[Oracle][ODBC ORacle Driver][Oracle OCI][ORA-12154: TNS:Could not resolve Service name.(#12154)


we have two environment of which one works fine other one throws the above error.
We are still not identified ho

Tom Kyte
August 27, 2006 - 8:01 pm UTC

looks like the tnsnames.ora is not setup right on that client.

Required components for client-side access to DB

Barry, July 06, 2007 - 1:06 pm UTC

I am trying to write a client side script to run in a MS environment (XP or 2K) that includes a SQL database query. I thought I could use the ADODB object to connect to the Oracle (version 10) DB server, but it appears that the driver is not a default driver installed with the MDAC package. Is there something short of the full Oracle client install that I can include to get access to the DB drivers that is required? It seems that if this were a java application, the JDBC driver provies the complete functionality I need to do this, but when I try to do the same in VB, all the help files I find say I need to install the complete client software package.
Any help you can provide to reduce the size of the required installation will be greatly appreciated.
Thanks
Tom Kyte
July 07, 2007 - 10:38 am UTC

you can use the instant client.

http://www.oracle.com/technology/tech/oci/instantclient/index.html
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.