Windows :: Oracle Versus Microsoft OLEDB
Sep 2, 2011
we are running a front end application on classic asp and we are using microsoft ole db version to connect to oracle 9i database.Now as the users are increasing daily, the application performance is degrading day by day.
my question is will oracle ole db increase the performance of my front end application. and is it possible for me to migrate from microsoft oledb to oracle oledb without much changes in the application.
View 1 Replies
ADVERTISEMENT
Jun 30, 2011
I need to create a doc file using Microsoft Word where I can get data from an Oracle DB.
I search on MS Word, for something like ODBC (like in Excel and Access) but in vain.
I need to do this so I can format the data on the doc file in any way I want. Not like in Oracle Reports, where formatting is a little bit restrictive.
View 9 Replies
View Related
Oct 1, 2012
I'm using Microsoft Access 2007 as a front end to Oracle 10g tables using an ODBC Connection. I need to be able to add attachments to the records in one of my linked tables to hold emails, screen shots, log entries etc.
Access 2007 handles this capability with a field format called Attachment. I don't want to store the attachments locally but want them to be stored in Oracle, but I'm not sure what format the field in Oracle needs to be so that it will come across in Access as an Attachment field.
View 2 Replies
View Related
Aug 8, 2012
My company already work with Oracle 10g, I developed an application using this database and asp.NET. It allows the management of BD and exploitation of these data by clients via ASP pages.
Now I must use Microsoft Exchange (especially the calendar) to retrieve data from the Oracle database and embed links to setup my ASP pages to the calendar.
Being new to Exchange, my questions are:
- It can be done?
- Should I use a particular driver?
- Some idea ?
View 0 Replies
View Related
Oct 11, 2012
I need to install Oracle oledb 32 bit driver for delphi application connecting to 11.2.0.3.0 db
do i install driver from oracle client for 11.2.0.3.0 or download from [URL]
are they both the same.
View 1 Replies
View Related
Aug 23, 2012
I have a particular sql code which works perfectly fine on sql developer. But if I run the same sql code through a batch file it does not get executed. It does not throw an error too.
SQL code - clean_tables.sql
begin
execute immediate 'drop table external_tables';
execute immediate 'drop table security';
exception
when others then
null;
end;
Batch file - Clean.bat
set ORACLE_SID=orcl
set ORACLE_HOME=C:oracleproduct11.2.0dbhome_1
set PATH=C:oracleproduct11.2.0dbhome_1BIN
sqlplus security/password@orcl <c:Reportclean_tables.sql
pause
View 2 Replies
View Related
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
Apr 8, 2013
Is Oracle certified Oracle 11.2.0.2.0 to run under a Microsoft 2008 Cluster ?
View 6 Replies
View Related
Jun 19, 2012
Bulk of Microsoft Application is running on windows server 2003 (OS) , is it possible to run parallel an oracle application on the same server .
View 4 Replies
View Related
Apr 2, 2012
I want to use SSIS,when i use oracle 10g as a data source to SQL Server 2008 as Destination, it gives error ora-01017 invalid username/password logon denied, i did normal oracle installation and give full privileges(sysdba or sysoper) to the user(sys,system...),when i check connection it shows test connection succeeded but when click on next it gives above error.
View 3 Replies
View Related
Aug 24, 2012
I have one .mdb (Microsoft Access Database) file and it has some tables in it. I had load it once using toad. But now i have to load it frequently into the database. Is it possible using external table, so i can access that tables using "select" statement.
View 6 Replies
View Related
Sep 17, 2012
A database containing inventory data has been migrated from Oracle 10g to Oracle 11g. I have access to both the Oracle 10g and Oracle 11g database on different client computers. Both databases use the same character set, WE9MSWIN1252 (query shown below). However the results from the sql SELECT show incorrectly displayed characters. I would like the "1/2" character and degree character to show in the text. The ASCIISTR function shows that the underlying ascii is the same in the two copies of the databases.
Is there a setting that needs to be changed in Oracle 11g so that the saved special characters in the database show correctly (as in Oracle 10).
Query of database character set
SQL> Select value from SYS.NLS_DATABASE_PARAMETERS where PARAMETER = 'NLS_CHARACTERSET'
WE8MSWIN1252
Under Oracle 11g, this is a query on DSI using SQLPLUS 11.2.0.1.0.
SQL> select description from part where id = '57234';
DESCRIPTION
----------------------------------------
KL BRKT PLN 22╜░ ANGLE (AMER BOT RAIL)
SQL> select asciistr(description) from part where id='57234';
ASCIISTR(DESCRIPTION)
--------------------------------------------------------------------------------
[code].....
View 6 Replies
View Related
May 7, 2011
I am currently in the favorable situation in which I have excess amounts of memory available on the database server - a single node setup. The server only serves the single instance and no other processing. Database size is around 2.3tb and memory is 50gb. For the majority of processing, AIX is allocating a significant amount (anywhere from 30-40%) of the memory to the AIX file system cache (persistent pages).
I've been trying to find documentation about this, but have not had any luck yet. My guess is that it would be better to allow Oracle to cache this data - meaning increase the SGA target and max size to allow for a larger buffer cache. However, the nice thing about the AIX cache is if process memory is needed, the file system cache gives up pages. If the memory was allocated to the SGA, its pretty much locked in.
I have read several articles stating that a larger buffer cache is not always better, as a larger cache takes more management. But having both of the caches active seem to be a waste of memory, effectively storing the data twice - once in AIX persistent pages and a second time in Oracle database buffer cache.
View 4 Replies
View Related
Jul 16, 2008
We have a .NET application on windows server 2008 32bit using the stored procedures on an Oracle 10g environment. We are trying to deploy the .NET application onto a 64bit x86 Windows server 2008.
We face an error trying to install the x64 version of the Oracle 10g client on windows 2008. The error we get is Problem signature:
Problem Event Name: APPCRASH
Application Name: javaw.exe
Is the x64 version of the Oracle 10g client certified for Windows 2008? Has anyone successfully installed the 64bit version of the oracle client on win2008?
We have a workaround in place with 32 bit version of the client running with the 32 bit version of the .NET application on x64 win2008. However to maximize the infrastructure we need to use the 64 bit version or we would have to turn to MSSQL Server .
View 4 Replies
View Related
Feb 27, 2012
can i install oracle 10g at windows 7 ultimate 32 bit
View 1 Replies
View Related
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
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
Aug 22, 2012
Do we have KM available in ODI 11g for integration with Microsoft OLAP?
View 1 Replies
View Related
Mar 13, 2009
I'd like to implement a treeview control with checkboxes in every node using Microsoft TreeView Control 6.0 in Forms 6i. I already did the following steps:
1. Download and register OCX (regsvr32 C:windowssystem32comctl32.ocx)
2. Draw OCX control on form.
3. Right click on OCX control and Insert Object "Microsoft TreeView Control 6.0"
4. Import OLE Library Interfaces "MSComctlLib.TreeCtrl.2"
5. Set Data Block Single Record to YES
6. Set OLE Class of Listview control to "MSComctlLib.TreeCtrl.2"
7. Rename treeview control to "ACX_TREE" and Data Block to "BLK_CONTROLS"
Now I need to populate the treeview adding code to the "WHEN_NEW_FORM_INSTANCE" Trigger, but I don't see how. how to do this and/or a place where I can find a working example?
View 4 Replies
View Related
Sep 13, 2013
we are running SAP application against oracle database. say, if I use brspace or brtools (from SAP side) to shutdown or startup database or collect stats, does this mean it not recommend to use oracle command to shutdown/start & collect stats?
View 3 Replies
View Related
Aug 26, 2011
we can you java code natively with Oracle. But I didn't get how to decide when to use native java in oracle and when to use pl/sql.
View 5 Replies
View Related
Jun 13, 2013
Oracle Database 11.2.0.3.0 64bitI have followed most steps of this link and I came to a stop at the point where I use the Network Configuration Assistant.I have selected the following
1) Directory Usage Configuration>
2) Microsoft Active Directory>
3) Operation (2nd): Select the directory server you want to use, and configure the directory server for Oracle usage.>
4) Input my AD hostname>
5) Then it displays a message that "The directory contains an older version of the required Oracle Schema. Directory usage configuration cannot continue without the correct Oracle Schema. If you have authorization to create the directory schema then you can upgrade the Oracle Schema now. Would you like to upgrade the Oracle Schema? I have selected: Yes, I want to upgrade... and thereafter I get the errors:
The Assistant is unable to create or upgrade the Oracle Schema for the following reason:
ConfigException: Could not upgrade the Oracle Schema: oracle.net.config.ConfigException: TNS-004409 Directory Service Errorcaused by: oracle.net.config.DirectoryServiceException: TNS - 04431: DirectoryService: no entries foundcaused by: oracle.net.ldap.NNFLException.You may need to upgrade the directory schema from a specific computer which directly supports your directory type.
Command Line Error Response
ConfigException: Could not check for the Oracle Schema: oracle.net.config.Config
Exception: TNS-04409: Directory service error caused by: oracle.net.config.DirectoryServiceException: TNS-04431: DirectorySe
rvice: no entries found caused by: oracle.net.ldap.NNFLException
View 4 Replies
View Related
Jul 25, 2012
I have been asked to look at making an existing Oracle server resilant. The technology I need to use are:
- Windows 2008 R2 Enterprise SP2
- Microsoft Cluster Services
- Oracle Enterprise 11g release 2
- Oracle Fail-Safe (latest version available)
Unfortunately ApEX 4.1 and Mod_plsql are install on the existing stand-alone server. I'm afraid i know very little about Oracle and ApEX but i need to make a design decision and check fiesablilty.
I believe the HTTP service and Mod_plsql can be moved to a independant server which should work but ApEX itself must remian on the database server (i'm told).Will ApEX work in a MSCS setup? I can only find references to RAC support, RAC is out of scope.
View 0 Replies
View Related
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
Feb 23, 2011
I want to open a word document which is present in a shared drive in Microsoft word from my oracle 10g form.
View 2 Replies
View Related
Jul 6, 2010
I m trying to open Report in Microsoft Office Excel format with below code.
declare
v_report_nameVARCHAR2(100) := 'F:IrfanNewReportsCurrency.rdf';
v_formatVARCHAR2(12):= 'SPREADSHEET';
begin
Web.Show_Document([URL]......);
end;
when my report run I received one message window File download after that this below error window appear & data can't show in proper format.
View 2 Replies
View Related
Dec 27, 2011
Procedure and function. exact reason when we go for function or procedure?
View 3 Replies
View Related
Aug 26, 2011
In the article regarding gathering CBO Statistics, it states: QUOTE When an Oracle database is created, a job will be scheduled that will generate the database statistics for you. You will still need to collect system statistics however, as these are not collected by the automatic statistics gathering mechanism.
what is the difference between "database statistics" and "system statistics"? In other words, do I need to run this script for each schema owner in my 10g/11g instance?
variable whoami varchar2(20);
begin
select user into :whoami from dual;
end;
exec dbms_stats.gather_schema_stats( -
ownname => :whoami, -
options => 'GATHER AUTO', -
estimate_percent => 15, -
cascade => true).
View 2 Replies
View Related
Oct 6, 2011
if one of the columns is given as
ABC varchar2(10)
the size of the data in bytes that this column going to hold.
View 5 Replies
View Related
Apr 30, 2013
about the functionalty w.r.t. unique constraint and Distinct clause. Below is the example which is confusing me lot.
--Below statement will create table and unique constraint
Create Table A (A Varchar2 (10) Unique);
Insert Into A Values (Null);
Insert Into A Values (1);
Insert Into A Values (2);
[code]...
If we are saying each null value is having a unique value, then why oracle distinct showing records.
View 3 Replies
View Related