Instant Client And ODBC Drivers

Dec 17, 2012

I've to install ODBC drivers required by a Windows application ( Windesign ).I've downloaded on Oracle website :

- instantclient-basic-windows.x64-11.2.0.3.0.zip
- instantclient-odbc-windows.x64-11.2.0.3.0.zip
- ODBC driver - Oracle 10.1.exe
- ODBC driver - Oracle 10.2.exe
- ODBC driver - Oracle 9.01.exe
- ODBC driver - Oracle 9.02.exe

But any of them contains install.exe or something like that...So I don't understand how to install instant client...I've found a doc on the web : " ... copy unzipped files into a folder ( ex.: C:OracleInstantClient ) and add Environment Variables TNS_ADMIN and PATH ) ... "I did it. But while adding ODBC driver with Windows admin tools , only SQL Server is available !!!.

View 2 Replies


ADVERTISEMENT

Client Tools :: ODBC Instant Client Oracle 10g

Jun 28, 2010

The version is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi. for Unix AIX 5

I install the ODBC Driver Manager, Basic Instant Client, ODBC Instant Client packages (libsqora.so, odbc_update_ini.sh).

The error:

[oracle@d4 oracle] $ isql OracleODBC-10g user passtemp -v
[01000][unixODBC][Driver Manager]Can't open lib '/home/oracle/instantclient_10_2/libsqora.so' : file not found
[ISQL]ERROR: Could not SQLConnect

Configuration

odbcinst.ini
[Oracle10gODBCdriver]
Description = Oracle ODBC driver for Oracle 10g
Driver = /u01/app/oracle/product/10.2.0/db_1/lib/libsqora.so
Setup =
FileUsage =
CPTimeout =
CPReuse =

The documentation explic with exists the file libsqora.so.10.1 but not exists in the ODBC Instant Client packages.

I applied ln -s libsqora.so.10.1 libsqora.so but the connection not function

odbc.ini
[oradns]
Application Attributes=T
Attributes=W
BatchAutocommitMode=IfAllSuccessful
CloseCursor=T
[code].......

View 1 Replies View Related

Client Tools :: To Update The ODBC Drivers In ORACLE 8i Version

Dec 6, 2010

I want to update the ODBC drivers in ORACLE 8i version. it's possible or not.

View 2 Replies View Related

Instant Client :: Using ODBC Without Running Odbc_install.exe (no Installation)

Aug 29, 2012

Is it possible to have a VB.NET aplication using Oracle ODBC driver without running/installing odbc_install.exe?

I want to deploy my application without having to run anything on the client so I guessed that instant client would work but I can't make it work.

View 0 Replies View Related

Windows / .NET :: Using Older ODBC Drivers With 11G

Sep 13, 2012

the need to use 9i Oracle ODBC drivers with 11g? What issues might be raised with this? Our application is using a very old technology and has issues, in certain functional areas, with 11g ODBC, and we found by reverting the driver to 9.0.0.2 it works.

View 6 Replies View Related

Windows ODBC :: Install - How To Make Drivers Available To All Users

Sep 9, 2013

I installed the Windows 7 64-bit ODBC drivers, but the install does not seem to have made the drivers available to all users, but rather only the installing user. This install is for an image that will be cloned as a virtual machine, so the drivers, client, settings, etc. will need to be available to anyone who logs in.

Is there a way to do the install so that all the settings and files put in by the installer will apply to all users? And if so, how do you do that?

View 0 Replies View Related

Windows / .NET :: Multiple Oracle ODBC Drivers In Single Database

Jan 9, 2013

I work in a large bank in a department that produces reports for different areas of the bank. By and large, we use Microsoft Office products to interface with our Oracle databases.Recently, we had two new databases come online that use Oracle 11g - we were not using any 11g databases before this point. We have two other databases that we use that run on Oracle 10g.

Up until the two new databases were brought in, our reporting was done from systems that used 10g and 9I. We all ran the Oracle 9I driver to connect to them, and it worked very well without issue. With the addition of the 11g databases to our reporting pool, we have been forced to upgrade our ODBC connections to the 11g driver, and it has not gone well at all. I had one query that typically ran in 30 minutes take +13 hours+ to run yesterday. Speed is not the only issue, either; we have sporadic ODBC call fails, crashes, and other general failures to deal with.

Our Oracle DBAs have been trying to solve the issue, but have not yet found a solution, and each day that this goes on we fall further and further behind, as I have daily time-sensitive reports to send out that depend on this data.

One of our DBAs said she read somewhere that Oracle had not included MS Access support in the 11g driver, and that the errors were due to the imperfect connection that the driver created. I don't know of there's any truth to that, but it would provide an explanation for our troubles. We have to use Access for our reporting, as over 90% of our existing reports and processes use Access, and having to change over everything at once is just not feasible.

Is there any way to force the 9I and 11g ODBC connections to coexist, so that we don't have to use the 11g driver for our 10g databases? Or is there a better 11g driver available?

View 2 Replies View Related

Oracle 10g Instant Client For Window 7

Dec 18, 2012

There are three versions of Oracle 10g instant client (10.2.0.2, 10.2.0.3 and 10.2.0.5) on Oracle website. which one works with Window 7? Where I can find the documentation from Oracle website?

View 1 Replies View Related

Instant Client :: LD - Can't Link With (MH-BUNDLE)?

Mar 2, 2013

I'm writing on behalf of the MacPorts package management system. I am trying to update the MacPorts port of Oracle Instant Client from 10.2.0.4.0 to 11.2.0.3.0 [URL}...and while many of our ports including the PHP oracle module continue to work fine with this version, soci [URL}.... and TOra [URL]...

ld: can't link with bundle (MH_BUNDLE) only dylibs (MH_DYLIB) for architecture x86_64

This is on OS X 10.8.2 compiling with Xcode 4.6's version of clang ("Apple LLVM version 4.2 (clang-425.0.24) (based on LLVM 3.2svn)").I suspect this is because soci and TOra are doing something with static libraries, and Oracle Instant Client is only shipped as a dynamic library. But I can't explain why this worked with 10.2.0.4.0, unless something has changed about how Oracle Instant

Client is being built. It's not clear whether this is an intentional change in Oracle Instant Client, and if it is, what developers should do to fix their software.I have not heard back from the developers of TOra, and the developers of soci

View 3 Replies View Related

Connecting To DB Remotely Through Toad Using Oracle Instant Client?

May 5, 2013

trying to connect to DB remotely through Toad..

"instantclient" already downloaded and configured as below :

dll files like "oci.dll,... etc" are here : C:Oracleinstantclientinstantclient_11_2
Created both tnsnames.ora & listener.ora are here : C:Oracleinstantclient
etworkadmin

And did the below in user/system variables :

User Variables :
=========
TNS_ADMIN with value "C:Oracleinstantclient
etworkadmin"

System Variables :
===========
TNS_ADMIN with value "C:Oracleinstantclient
etworkadmin"
ORACLE_HOME with value "C:Oracleinstantclient"
Path edited and added this value "C:Oracleinstantclientinstantclient_11_2"

But i am still facing the below error :

ORA-12541: TNS:no listener

View 21 Replies View Related

C++ Call Interface :: Instant Client 11g OCCI In MSVC6++ Windows 7 32-bit

Jun 28, 2012

I install Oracle instant client 11g in my Windows 7(32bit), and use MSVC6++ to test program occidml.cpp, compile is no problem, but when I run it, it crash on create Connection. I have tried to link with different version of OCCI library ( v8,v9), but all crash on create Connection.

View 0 Replies View Related

Precompilers, OCI & OCCI :: Connecting To Oracle Database With Instant Client 11.01.06

Mar 19, 2009

connecting to an oracle db with the instant client 11.01.06. I can connect to the db via other tools like sqldbx or SqlTools 1.5 which are also using oci. So now I tried it with c++ using Visual Studio 2005 SP1.

First I tried this

Environment* env=Environment::createEnvironment(Environment::DEFAULT);
Connection* con=NULL;
try{
con=env->createConnection("user","pwd","//servername:ip/mydb");
}

and got following error: "the attribute OCI_ATTR_USERNAME is greater than the maximum allowable length of 255".

So I tried:

Environment* env=Environment::createEnvironment(Environment::DEFAULT);
Connection* con=NULL;
try{
con=env->createConnection("user","pwd","tnsservice-name");
}

where tnsservice-name is the name I specified in the tnsnams.ora, and which I used with the other tools working fine -> same error.My username is only 4 long, so I thought it might have something to do with the string. So I tried:

Environment* env=Environment::createEnvironment(Environment::DEFAULT);
Connection* con=NULL;
string user="user";
string passwd="pwd";
string db="tnsservice-name";
try{
con=env->createConnection(user,passwd,db);
AfxMessageBox("sucess");
}

now it returned the error "TNS:connect descriptor too long". Can't have anything to do with the .ora file, since it worked fine for the other tools. Plus it didn't matter if I renamed the .ora file or removed it from the TNS_ADMIN directory..So I searched a little more for a solution and so an example, where the the last argument is missing. So I tried

string user="user";
string pwd="pwd";
Environment* env=Environment::createEnvironment(Environment::DEFAULT);
Connection* con=NULL;
try{
con=env->createConnection(user,pwd);
}

It returns: "TNS: protocol Adapter error" which I somehow can understand, since the adapter doesn't know to wich db to connect.I also tried to use some frameworks like soci or otl but was never able to compile them... (link errors, unknown data types etc...).

View 1 Replies View Related

Instant Client :: ORA-12545 / Connect Failed Because Target Host Or Object Does Not Exist

Jan 31, 2013

I have installed the Oracle Instant Client* on UNIX(Mac OS X Lion 10.7.5), and I want to use it on localhost because i just want to study and test it.but here, the some error appeared to me. so I was so screwed up.

here is the error messages and the settings

Command:

~ user$ sqlplus scott tiger

ERROR:

ORA-12545: Connect failed because target host or object does not exist

env settings:

$ORACLE_HOME=/usr/local/oracle
$ORACLE_SID="Oracle 10g+ASM" // I don't know what ORACLE_SID means
$ORACLE_LIBRARY=/usr/local/oracle/instantclient_10_2
$DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:$ORACLE_HOME/instantclient_10_2
$SQLPATH=$ORACLE_HOME/instantclient_10_2
$PATH=$PATH:$SQLPATH

View 1 Replies View Related

Oracle Client 10.2.0.3.0 With ODBC?

Nov 17, 2010

I have recently installed the latest Oracle 32bit client 10.2.0.3.0 on a Windows 2008 server. Installation was successful and I was able to create the required service names and test them to the Oracle database server. Now when I try to create an ODBC connection with Oracle in OraClient10g_home1, I get the following error: SQORAS32

An unsupported operation was attempted

If I install Oracle client 10.2.0.1.0, I don't get this error. It happens with the latest client. Is there any was to solve this error?

View 3 Replies View Related

Windows / .NET :: ODBC Setup Error For Oracle Client

Sep 5, 2012

I'm trying to setup ODBC connection for my Oracle client while installing BO. Following are the steps I followed.

1. Downloaded the Oracle Client from the link [URL] . From that downloaded two zip files. “Instant Client Package – Basic Lite" and “Instant Client Package – ODBC”. Extracted the Zip Files to the folder I created under C: as C:Oracleinstantclient_11_2.

2. Since I'm setting up in ODBC in windows 2008 64-bit R2. I was advised to install 32 bit . So in cmd prompt, from the location C:Oracleinstantclient_11_2, ran odbc_install.

3.Created the Environment variables as
i) *TNS_ADMIN - C:Oracleinstantclient_11_2*
ii) *Oracle_Home - C:Oracleinstantclient_11_2*
iii) *Edited the PATH variable with ;C:Oracleinstantclient_11_2*

4. Created the tnsnames.ora file in C:Oracleinstantclient_11_2. Its content are as follows.
clarity_dev =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = claritydev.vip.its.ebay.com )(PORT = 1521))
)
(CONNECT_DATA =
(SID = clarity)
)
)

5. From the folder %windir%sysWOW64odbacd32.exe, Opens ODBC Data Source Adminsitartor. In that I found my Oracle in instantclient_11_2 and added following details.

Data Source Name : claritydev.vip.its.com
TNS Service Name : clarity_dev
User Id: clarity1

When I test connect it, I get error *ORA-12154:*
*     TNS:could not resolve the connect identifier specified*

I've seen FAQs for this error, but couldn't find anything which solves. Is there any steps I'm missing? I've checked in DB properties. It uses SID not the Service Name.

View 3 Replies View Related

Windows / .NET :: Oracle ODBC Drive In Linux Client To Connect With Mono Application

Aug 6, 2012

I am creating a cross platform database application using Mono. It uses oracle database as back end. I used ODBC drive to connecting database. I can connect to database using this following connection string in my windows machine

Driver={Oracle in OraDb11g_home1};Server=localhost;Uid=system;Pwd=manager

For Linux I uses Linux Oracle OS for Database server. I installed oracle client in my fedora OS. and cofigure the client using net cofiguration assistant tool with oracle client. client connection working OK. Then I try to connect with my mono application using the following connection string

Driver={Oracle ODBD Drive};Server=orcl;Uid=system;Pwd=manager

but the above connection string not worked.I am using Oracle 11g version. Do I need to install any other ODBC driver to access oracle database

View 1 Replies View Related

Mismatched Oracle Drivers - Upgrade (10.2.0.1 To 10.2.0.5)?

Jun 26, 2012

We are running Oracle Enterprise software on various client and DB servers and we are experiencing a problem (outlined here ) where the apparent mismatch between the oracle drivers are causing the errors. Our db servers are using 10.2.0.4 and 10.2.0.5 drivers and the clients are using 10.2.0.1.

Firstly, are the drivers the same on the Express and Enterprise editions so that if I update a development server usingExpress version (I dont have the authority to upgrade the Enterprise version nor the time to commission that) and it is successful, can I reasonably expect an upgrade to the Enterprise client versions on other servers to be safe/error free, baring environmental factors of course ?

Secondly, can I upgrade to version 10.2.0.5 now or do I have to go to the 11g version only ?

View 1 Replies View Related

Windows :: Mismatched Oracle Drivers / Upgrade Version

Jun 26, 2012

We are running Oracle Enterprise software on various client and DB servers and we are experiencing a problem (outlined here [URL] .....) where the apparent mismatch between the oracle drivers are causing the errors.

Our db servers are using 10.2.0.4 and 10.2.0.5 drivers and the clients are using 10.2.0.1.

Firstly, are the drivers the same on the Express and Enterprise editions so that if I update a development server using Express version (I don't have the authority to upgrade the Enterprise version nor the time to commission that) and it is successful, can I reasonably expect an upgrade to the Enterprise client versions on other servers to be safe/error free, baring environmental factors of course ?

Secondly, can I upgrade to version 10.2.0.5 now or do I have to go to the 11g version only ?

View 2 Replies View Related

ODBC Connectivity Rather Than OTG?

Feb 1, 2013

What are the steps required to change an ORACLE stored procedure (on a AIX/UNIX machine) using OTG to connect to a DB2 database, to an ORACLE stored procedure that uses ODBC or JDBC connectivity?

All I need to do in the stored procedure is a simple insert statement into a DB2 table.

What kind of ODBC/JDBC driver do I need on the UNIX machine? unixODBC?

What would be different in the ORACLE stored procedure for it to use ODBC connectivity rather than OTG.

View 1 Replies View Related

SQL & PL/SQL :: Microsoft ODBC For Oracle And Autocommit

Feb 10, 2011

I am using an Microsoft Access application which accessing an Oracle Database with ODBC.

each time i change data in the ACCESS forms, the change is committed in the database. I would like to know how to set the AUTOCOMMIT off.

View -1 Replies View Related

Windows :: ODBC 64bit Vs 32bit?

Jan 14, 2012

I am using DataBase Express 11g as a development site.I have developed a Delphi GUI to run with it. (32bit). All runs as expected!My associate has a Windows 7 (64bit) machine. Express installation does not supply an ODBC driver. DataBase Express installs without problem, but it is the connectivity that is the problem

I understand that 11g(full) supplies both 32 & 64 OBDC drivers.I do not want to install the full 11g database if it can be avoided.

This is going to be more of a problem the more 64bit machines get into the workplace.Is there an alternative connection method available?

View 1 Replies View Related

Windows ODBC :: 11g Dsns From MS Access

Nov 12, 2012

Using Server 2008 Standard Edition 64 bit. We have been running full client (admin) version 10.2.0 and just installed full client (admin) 11.2.0. Both homes are in my path variable with 11.2 first.

From ODBC Administrator, I can can create new system data sources using the 11.2 client driver and the testing widget built into the data source creator says my connection is good to both 10.2 dbs and 11.2 dbs. So the 11.2 odbc driver would seem to be working.

However, from MS Access, I can only see 10.2 drivers and 10.2 data sources, which fail unless I put the 10.2 home in first place in my path.

I cannot find a way to "access" the 11.2 drivers from MS Access. If I try to create a new data source from inside MS Access, I only see the old 10.2 driver.

View 3 Replies View Related

Windows / .NET :: Oracle 10g ODBC For Setup

Jan 4, 2013

i want to use Oracle database client 10g ODBC driver but i don't have it.

I want the driver for setup.

View 0 Replies View Related

Windows :: Connect To 8i Database Via Oracle 9.02 ODBC

Sep 17, 2002

I am attempting to connect to an Oracle 8i database via the Oracle 9.02 ODBC driver and I am receiving the following error message upon testing the connection in WinXp's ODBC Data Source Administrator dialog box: "Unable to connect SQLState=IM004 [[Microsoft]][[ODBC Driver Manager]] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" .

I am running Oracle Client 9.2 on a P4 machine running winXP.

View 28 Replies View Related

Windows / .NET :: ODBC Administrator Has Stopped Working

Dec 8, 2012

I installed the Oracle instant client version 10.2.0.3 and the corresponding ODBC driver. When I try to add a DSN in ODBC Manager using the Oracle driver, it crashes and I get this message:

"ODBC Administrator has stopped working"
"Windows is checking for a solution to the problem..."

Trying to isolate this problem, I ran odbcad32.exe under DependencyWalker and it worked correctly without crashing. According to the Dependency Walker FAQ, this can be due to a "buffer overrun, stray/bad/freed pointer, etc.". They have a switch to set SET NODEBUG_HEAP=1 to check for this. When I did this, it crashes insider DependencyWalker also.

View 0 Replies View Related

Networking And Gateways :: What Character Set Sent From DG4ODBC To ODBC Driver

Jun 19, 2013

When a database is configured to use AL16UTF16 what character set is sent from DG4ODBC to an ODBC driver when passing in Arabic characters ?

i am using easy soft odbc driver for transfering data from oracle to MS SQL server. English text is going fine, but when i am trying to transfer some arabic text, it is getting corrupted.

View 2 Replies View Related

Getting Oracle Odbc Ora-28000 Account Locked Error?

Sep 15, 2012

I am getting Oracle odbc ora-28000 account locked error

View 1 Replies View Related

Windows / .NET :: Connecting To Oracle Database Using ODBC Driver

Jul 16, 2012

I'm using following connection string: +connectionString="Driver={Oracle ODBC Driver};Server=someDb;Uid=useruidr;Pwd=password"+

when I call method "Open" on "OdbConnection" I get following exception: +ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified+

"someDb" is specified correctly in tsnames.ora,
"...client" and "...clientin" are added to PATH environmental variable
ORACLE_HOME is set to "...client"

I have Oracle Client 11.2.0.3.0 installed
Operating system is Windows 7 32 bit

When I change Driver to "Microsoft ODBC for Oracle" it works fine. However I want to use Oracle ODBC Driver.

View 2 Replies View Related

Windows / .NET :: Oracle ODBC As User Works But Fails As SYS

Feb 1, 2013

Windows 7
Oracle XE 11gR2

From Windows, I can successfully create and connect with a system data source using an user Oracle account.But when doing then same configuration process I can not create or connect using the 'SYS' account.

i get the error 'ORA-2009: connection as SYS should be as SYSDBA or SYSOPER'.

What is the solution to creating an ODBC DSN for the user 'SYS'?

View 6 Replies View Related

Networking And Gateways :: TNS - Listener Not Given SID - Access To Oracle 10g ODBC Connection?

Aug 25, 2010

ODBC--call failed.TNS:listener was not given the SID in CONNECT_DATA (#12504)

TNSname sets the SID. SQL*Plus is able to connect from the client Windows XP Proff using the same name. Access, on the same client, uses the same Oracle driver to connect successfully to other Oracle databases. These other databases show equal tnsname (different name and SID...)

ODBC Data Source Administrator configures the database and the test connection is successful.

Cannot set up a link from Access to the Oracle database. At some point, I have created a new Access database and it did let me connect, view the list of tables, and set up links to several tables, but the next day I could not open any of the tables and the complain was: ODBC--connection to 'MYDB' failed.

It seems that SQL*Plus passes correctly the SID from the TNSname but ODBC, when invoked from Access, does not. Yet, ODBC does it right for other databases.

View 12 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved