Client Tools :: Oracle / Crystal Reports On Windows 7 64Bit Machine?

Feb 1, 2011

I recently got a new PC at work which is Windows 7 64 bit.

We run lots of crystal reports(1000's) that pull data from an oracle back end.

I have installed the Oracle Client 32 bit on this machine and have no problem connecting to the database and pulling back data.

However, when I use crystal to access the TNS Name it gives me the following error.

[URL]

My path variable on the PC has "C:oracleproduct10.2.0client_1BIN;".

I also tried to create and ODBC using the 32bit ODBC on the machine and that connects fine, but when you try to access the DSN from Crystal, I still get the 12154 error.

View 7 Replies


ADVERTISEMENT

Client Tools :: Return Data From Oracle For Crystal?

Aug 9, 2010

I have problems in Oracle returning data from a stored procedure. In MS SQL it's quite simple.

i.e.

CREATE OR REPLACE PACKAGE globalpkg
AS
TYPE RCT1 IS REF CURSOR;
TRANCOUNT INTEGER := 0;
IDENTITY INTEGER;
END;
/

next the stored procedure:

CREATE OR REPLACE PROCEDURE mytest
(
RCT1 OUTGLOBALPKG.RCT1
)
AS
BEGIN
OPEN RCT1 FOR
SELECT *
FROM EMPLOYEE;
END;

Next trying to run the Stored procedure:

VARIABLE resultSet REFCURSOR
EXEC mytest (:resultSet);

Result always returns this error:

REFCURSOR - Unrecognized type.

I have tried using sample on the internet, but all returns the same error, what am I missing

View 32 Replies View Related

Windows :: Unable To Install Oracle 10g Client On 64bit Windows 2008

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

OLE DB :: ORA-03113 On Crystal Report - VS With 32bit Win7 And 64bit Oracle DB

Jan 10, 2013

we have moved our database to a new server which is 64bit. (earlier database was 32bit)

when i try to connect my crystal report or Vs .net to the new server i'm getting below error.

ORA-03113: end-of-file on communication channel

my computer is Win 7 (32bit)

View 2 Replies View Related

Installation :: How To Install Oracle 9i Client Software On Windows 8 64bit

Nov 12, 2013

How to Install Oracle 9i client software on Windows 8 64bit?

View 7 Replies View Related

Client Tools :: Unable To Get All Views In Crystal Report

Nov 11, 2008

One of my developer creating views in his own schema,we are able to see that views from sqlplusw. But we are unable view them from crystal report tool(CRW32) ,Except this schema all are visible...

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

Installation :: Get Oracle 10gr2 64bit Download For Windows 7 64bit?

May 6, 2013

where i can get oracle 10gr2 64bit download for windows 7 64bit?

View 2 Replies View Related

Installation :: Oracle 10g Client Install Skips - Windows 7 Machine

Nov 15, 2013

I have Oracle 11g database home in my 64 bit Windows 7 machine. However, now i would like to install Oracle 10.2.0 client as well. I tried giving a separate location.

But for some reason, whenever i start the Setup and run the Administrator Type, the installation just skips without giving any errors. It just creates the inventory folder in the specified path.  It goes to the Product-Specific Prerequisite Checks and exits without giving any warnings or errors. 

View 15 Replies View Related

Client Tools :: How To Configure SQL DEVELOPER Via Virtual Machine Oracle Database

Mar 21, 2012

i have oel installed on my parallel Virtual machine.

i have a problem with configuring sql developer to the oracle database which is located in my virtual machine.

my os is windows7 32 bit.

View 13 Replies View Related

Best Way To Change Language Of Windows Oracle Client Machine Edit Registry

Jun 29, 2012

We have installed oracle client on Windows machine and despite selecting language as English

when look in registry shows NLS_LANG as

AMERICAN_AMERICA.WE8MSWIN1252.

What is the best way to change language of Windows oracle client machine edit registry.

View 2 Replies View Related

Client Tools :: Oracle Client 32 Bit On Windows Server 2008 R2 64 Bit

Jul 20, 2012

Can i install Oracle 10g Client 32 bit on our Windows Server 2008 R2 64 bit?

View 1 Replies View Related

Client Tools :: SQLPLUS Windows In Oracle 11g

Feb 27, 2011

the reason for not availability of ISQLPLUS & SQLPLUSW window from oracle 11g.

View 3 Replies View Related

Client Tools :: Display Windows On Oracle SQL Developer?

Sep 10, 2013

find in the menu of Oracle SQL Developer how to display the result of explain plan for .. I have just "Succès de l'élément plan FOR".

View 3 Replies View Related

Client Tools :: Windows 7 / Oracle 10g - Not Getting Editor From Sqlplus

Jan 29, 2012

I am using Windows 7 and oracle 10g; From sqlplus* I can not use editor (using ed). but when I see the variable from DEFINE.. It shows that default editor is notepad..

I can use editor in winxp.How to get (use) editor ?

View 1 Replies View Related

Client Tools :: Migration From Windows Mssql To Linux Oracle

Dec 10, 2012

Env destination-linux:2.6.18-308.13.1.el5,oracle:10.2.0.1 ,source:windows.mssql v:8.00760

I was try migrate one sample database from mssql "Pubs" using Oracle SQL Developer Tool.

After migraton i've got prefixes in tables like MD_<table_name> but i can not see tables from Pubs only a lot of tables like :

MD_COLUMNS
MD_GROUPS
etc...

View 10 Replies View Related

Client Tools :: How To Install Oracle Developer Suit 10g On Windows 7 32 Bit

Oct 3, 2011

can u give me link from where i have to learn step by step how to install oracle develor suit 10g on windows 7 32 bit

View 4 Replies View Related

Client Tools :: 10g On Windows 7 - Unable To Initialize Oracle Call Interface

Oct 16, 2013

I work with oracle 10g, on windows 7. sometime when i try to start my sqlplus in prompt command this message display.

C:UsersSony>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

But the solution people have proposed into the forum are:

1 - check the environment variable Oracle_home and modify if it ending by ""

2 - or try tho run my promt command as Administrator.

I try the both, but only the second works. while now i don't understand why it works when i start the promt command as Administrator and why it no works when i don't run it like administrator. Another thing is i am the only user of my computer, i have only one session (administor session).

View 4 Replies View Related

Client Tools :: ORA-06413 - Connection Not Open Error Oracle On 64-bit Windows

Jul 11, 2013

I have newly installed Oracle 11g R2 64 bits to window 8 PRo 64 bits. Able to connection successfully Oracle NEt Configuration Assistant service name.

But when I try to connect it Toad 9.6 32 bits its show error message

ORA-06413: Connection not open

View 5 Replies View Related

Forms :: Run Report Developed By Crystal Reports By Click On Button In Oracle Developer 6i?

Dec 19, 2011

I want to run a report developed by crystal reports by click on a button in oracle developer 6i.

Is it possible. If yes then how can i do this.

View 8 Replies View Related

Client Tools :: Similar To Oracle Reports Builder 6i?

Jul 14, 2011

Any good tool similar to Oracle reports builder 6i ?Which should be OPENSOURCE.

View 7 Replies View Related

Client Tools :: Audit Records From Specific Machine / Terminal Only?

Apr 11, 2011

Is there any tool available for audit records from a specific Machine/terminal Only?

View 1 Replies View Related

Windows :: Connect Oracle From Win 7 64bit

Jun 22, 2013

Recently i have installed oracle 10g.2 in my laptop under Win-7 64bit. But cannot connect oracle from Windows form [C#], Office application[Excel] and odbc. Showing error[Tns could not resolve the connect identifier specified Drivers SQLSetconnectAttr failed ]

Though I can connect oracle from toad and sqlplus and form 6i.

View 17 Replies View Related

Oracle Error In Windows-7 64bit

Oct 30, 2010

i installed windows-7 64bit and i try to run my program(that work's with Oracle 11g) i get this error:

Attempt to load Oracle client libraries threw BadImageFormatException this problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed

and from where i can download 64 bit oracle client ?

View 1 Replies View Related

Installation :: Oracle 10gR2 For Windows 7 64bit Processor?

Jul 10, 2012

I need to download Oracle 10g R2 for windows7 64bit processor. send the link

View 4 Replies View Related

Reports & Discoverer :: Output Saved On Client Machine Instead Of Server?

Dec 6, 2010

is it possible to put DESTYPE=LOCALFILE in run_report_object_list?

View 1 Replies View Related

Forms :: Oracle 11g Windows 64bit / File Extraction Password

Nov 27, 2012

I downloaded Oracle Fusion Middleware11g Forms and Reports (ofm_frmrpts_win_11.1.2.0.0_64_disk1_1of1). When I begin to extract I am getting bogged down with a password message and that is:

File Windows-amd64 is password protected. please enter the password in the box below.

BTW- I downloaded Windows64 based forms and reports on my windows xp pro machine. I am trying to unzip them and burn it on a DVD so that I can install them on my new dell windows 7 professional laptop.

View 7 Replies View Related

Installation :: Oracle 11g Client 32bit And 64bit?

Sep 14, 2012

I have Windows 2008 R2 64 Bit Operating Server Installed.

Other software that are Installed :

1) Visual Studio 2010 Ultimate 32 Bit.

2) Microsoft SharePoint server 2010 64 Bit.

For my development purpose I want to install both oracle 11g client 32 bit and oracle 11g client 64 on the same machine.

Is it possible to install both 32 and 64 bit instance on the same machine.

View 5 Replies View Related

Installation :: Install Oracle 11g Client In Ubuntu 12.04 64bit

Jul 3, 2013

Most of the ones I'm seeing online relate to the database, not the client.  I have linux.x64_11gR2_client.zip and and trying to do runInstaller and I get up to perform prerequisite tests and it tells me that I am missing packages and that kernel parameters are wrong. I've tried to run the runfixup.sh file and get a lot of this:

 ./orarun.sh: 186: [: true: unexpected operator./orarun.sh: 848: [: unexpected operator./orarun.sh: 864: [: unexpected operator./orarun.sh: 882: [: unexpected operator./orarun.sh: 903: [: unexpected operator./orarun.sh: 1052: [: unexpected operator./orarun.sh: 1057: [: unexpected operator./orarun.sh: 1075: [: unexpected operator./orarun.sh: 1085: [: unexpected operator./orarun.sh: 1115: [: unexpected operator./orarun.sh: 1143: [: unexpected operator./orarun.sh: 1189: [: unexpected operator./orarun.sh: 139: [: unexpected operator./orarun.sh: 139: [: unexpected operator./orarun.sh: 1228: [: unexpected operator./orarun.sh: 1284: [: unexpected operator./orarun.sh: 1342: [: unexpected operator./orarun.sh: 1426: [: unexpected operator./orarun.sh: 1451: [: unexpected operator And many of the supposedly missing packages actually are installed. IE: make. I have make 3.81 installed but the installer insists upon make 3.80. 

View 3 Replies View Related

Client Tools :: How Can Isqlplus Available For Windows Client

Sep 23, 2010

I have an Oracle server on CentOS 5.4, I can visit isqlplus on server, but I can't visit isqlplus on a windows client. ping works between server and client. I remember client doesn't need to install software via isqlplus, but I am not pretty sure.

View 2 Replies View Related







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