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


ADVERTISEMENT

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

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

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 :: 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

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 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

Windows / .NET :: Visual Studio 2010 64bit Can't Connect Oracle Database Through 64bit ODBC Driver

Sep 25, 2013

I am developing an 64bit And-In software. My OS is windows7 64bit Ultimate. Developer tool is Microsoft  Visual Studio 2010 Ultimate 64bit any-CUP.Server is SUN server and Oracle database 10.2.0.5 64bit enterprise edition.I have installed instantclient-odbc-win64-10.2.0.5 on my computer.I am able to connect through the command line sqlplus user/pass@server.In date source(c:windowssystem32odbcad32.exe), ODBC Driver connection successful.But in VS2010 C#, use Tools -> Connect Database,I get an error 193 (Oracle in instantclient10_2,c:ora10_64SQORA32.dll) cann't be loaded.SQORA32.dll is 32bit ODBC Driver or 64bit ODBC Driver?How can I connect database with vs2010 64bit? 

View 2 Replies View Related

Windows ODBC :: Connect To Oracle 9i From Windows 7?

Dec 20, 2012

Database: oracle 9i sitting on a 32 bit machine.
Client: windows7 64 bit computer
installed oracle 11gr2 client

Is there a way to connect to oracle 9i database from C:WindowsSysWow64odbcad32.exe on windows 7 machine? or what is the possible way to connect to Oracle 9i database?What we need is to run crystal reports from windows 7.

View 4 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 / .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 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

Windows :: Installing Multiple Version Of Client On A Single PC?

Sep 17, 2010

installing Oracle 9i and Oracle 10 g client on a single PC.

What are the things I should take not of for the installation?

View 4 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

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 :: 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

Performance Tuning :: Can Have Multiple LGWR Processes For Single Database

Jul 2, 2010

its possible to have multiple LGWR processes for a single database.If its possible how does the multiple processes write from redo log buffer to online redo log file.

View 3 Replies View Related

ODP.NET :: Can Multiple Calls Execute Within Single Oracle Session

May 8, 2013

Can multiple ODP.NET calls potentially execute within a single Oracle session due to connection pooling?

How can I test/observe this behavior?

We have an IIS application that uses one connection string for all logged in users and call aspx pages.

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

PL/SQL :: Single Long Connection Vs Multiple Short Connections To Oracle Server

Oct 8, 2012

A DB server (Oracle 11g) on Linux will support a Web Application Server (Java based) for hosting a public web site.For sending multiple INSERT statements over from the Java Server to Oracle Server, I have two ways to do it:

1) Wrap those insert statements together and send it over with one connection to Oracle

2) Send each insert statement separately to Oracle. As the result, multiple insert statements are sent and accordingly multiple connections to Oracle are needed.

Advantage of option 1 is just using one Connection. Disadvantages are that Oracle will then need to parse the statement string into multiple separate insert statements, and then loop through them to execute each. This may be costly in CPU sense.

While the option 2 may have quicker execute of each insert statement, but will need to create multiple connections.If the number of users is known and stable (such as intranet), I would prefer option 1; while for the internet there could hundreds concurrent users at the peak, I lean towards the option 2.

View 2 Replies View Related

SQL & PL/SQL :: Structure Schemas Within Single Oracle Instance To Support Multiple Project Development

Jan 24, 2013

The best way to structure my schemas within a single Oracle instance to support multiple project development. At the moment, within an Oracle instance I have Area_Dev and Area1_Test schemas, with the intention that Project Xv1.0 would use Dev schema for development and Test schema for testing.

Lets say I want to start on Project Xv2.0 development while I am still finalizing Project Xv.10 development what is the best way of accommodating that, without creating individual schemas for each project?

View 3 Replies View Related

Install Multiple Versions Of Oracle Databases 10GR2 And 11GR2 In A Single Node?

Oct 28, 2010

ORACLE DBA
EXPERTS

�I can install multiple versions of Oracle databases 10GR2 and 11GR2 in a single node using a unique Oracle ASM single instance?

View 6 Replies View Related

Windows :: Does Oracle Database 10.1.0.2 (64-bit) Compatible With Windows 2003 R2

Jan 9, 2011

Does Oracle Database 10.1.0.2 (64-bit) compatible with windows 2003 R2 standard X64 edition with Service pack 2.

View 1 Replies View Related

PL/SQL :: Merge Multiple Rows Into Single Row (but Multiple Columns)

Oct 17, 2012

How to merge multiple rows into single row (but multiple columns) efficiently.

For example

IDVal IDDesc IdNum Id_Information_Type Attribute_1 Attribute_2 Attribute_3 Attribute_4 Attribute_5
23 asdc 1 Location USA NM ABQ Four Seasons 87106
23 asdc 1 Stats 2300 91.7 8.2 85432
23 asdc 1 Audit 1996 June 17 1200
65 affc 2 Location USA TX AUS Hilton 92305
65 affc 2 Stats 5510 42.7 46 9999
65 affc 2 Audit 1996 July 172 1100

where different attributes mean different thing for each Information_type. For example for Information_Type=Location

Attribute_1 means Country
Attribute_2 means State and so on.

For example for Information_Type=Stats

Attribute_1 means Population
Attribute_2 means American Ethnicity percentage and so on.

I want to create a view that shows like below:

IDVal IDDesc IDNum Country State City Hotel ZipCode Population American% Other% Area Audit Year AuditMonth Audit Type AuditTime
23 asdc 1 USA NM ABQ FourSeasons 87106 2300 91.7 46 85432 1996 June 17 1200
65 affc 2 USA TX AUS Hilton 92305 5510 42.7 46 9999 1996 July 172 1100

View 1 Replies View Related

Server Administration :: Create Multiple Database In Single Server

Apr 18, 2011

I have database in single server. I already have ORACLE_SID=stagedb. So i want to create new sid and named as proddb.Is it possible have multiple db in single server? This server not running as RAC. It run as single only.

View 1 Replies View Related

Windows :: Fast Method To Install Oracle Client In Multiple Machines?

May 25, 2010

I need to install Oracle Data Provider for NET (and all depending Oracle client SW components) in multiple client machines.

Exist any other options (faster) without installing oracle client on each of the machines?

View 4 Replies View Related

Run A New Database In Microsoft Access To Import Tables Through ODBC - Get Error?

Mar 5, 2013

We are test Uniform ODBC drivers. When we run a new Database in Microsoft Access to import tables through the ODBC we get this error

Internal Error – unable to initialise NLS during driver load.

View 2 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







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