how to implement login module using Oracle 10g database (logic & Oracle 10g Queries) and how can i use membership and roles with Oracle 10g & VS 2.0
Hi all, Can any one tell me how to implement login module using Oracle 10g database (logic & Oracle 10g Queries) and how can I use membership and roles with Oracle 10g & vs 2.0. , for implement this is it compulsory to install oracle 10g server on the same machine on which I'm implementing this task or otherwise i can use other system as a server (like remote login or client server)
Hi,You should have the Oracle 10g Server or Client In your machine.In Case Client is in your Machine then Server Must be somewhere,that is enough to use.I hope then we ...DBD:Oracle for Oracle 9.0.2 and 9.2 ?
Currently in a project to convert our existing 7.3.4 and 8.1.7 Databases
to Oracle9i.( Either the 9.0.1 or 9.2 version ) Now I'm having some
problems connecting to some test databases I have setup. Do I need to
upgrade my perl version or Dbi / DBD version to be able to connect? I
keep getting the :=20
DBI->connect(servwhDBMET) failed: ORA-03113: end-of-file on
communication channel (DBD: login failed)
...urgent: .NET Provider for Oracle or Oracle Data Provider for .NET
If I want to access Oracle DB in ASP.NET application, and I am using .NET Provider for Oracle or Oracle Data Provider for .NET, should I have to install OracleClient on my .NET server? Is there other choice? Thank you very much.Johnson
Johnson2007:should I have to install OracleClient on my .NET server? You have to options1. install the ODP.NET on your web serverOR2. put the oracle assemblies in your BIN directory
Hi jimmy,Thank you for you reply. Because I could not find a server right now, I should test it first before I agree or disagree with you, as most articles I...DBD::Oracle for Oracle 9i versoin 9.2.0 (64 bit Oracle)
I am unable to compile/build DBD::Oracle with Oracle 9i (64-bit Oracle RDBMS)
library. Could someone please help? Thanks.
This message contains information from Equifax Inc. which may be confidential and
privileged. If you are not an intended recipient, please refrain from any
disclosure, copying, distribution or use of this information and note that such
actions are prohibited. If you have received this transmission in error, please
notify by e-mail email@example.com.
On Thu, Jul 22, 2004 at 05:14:03PM -0400, Surjit.Sahoo@equifax.com wrote:
...install_driver(Oracle) failed while connecting to oracle 10.2.0.2
Could u pls help on this issue.
Presently we are using the following versions=20
Perl version -------- perl, v5.6.1 built for sun4-solaris
DBD::ORACLE --------- 1.15
DBI version ---------- 1.28
ORACLE -------- oracle 10.2.0.2
THE BELOW CODE WAS WORKING FINE WITH ORACLE 220.127.116.11
=...RE: install_driver(Oracle) failed while connecting to oracle 10.2.0.2
We have Changed the permissions .
Even after that, I am getting the following error as
install_driver(Oracle) failed: Can't load
e.so' for module DBD::Oracle: ld.so.1: perl: fatal: libclntsh.so.9.0:
open failed: No such file or directory at
/usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206.
at (eval 1) l....NET Oracle Provider
Hi all,I am using .NET 2.0 Frameworks Oracle provider and it does not have a OracleDbTypes Type for me to use. I would like to create a parameter that is of the Oracle type NVARCHAR, but it seems I can only use DbTypes, which does not have this. If I used DbTypes.String, would this be ok, otherwise, how else can I be more specific about the Oracle Parameter data type?Thanks
can u explain which type of data u r going to storeThank uBaba Thank uBabaPlease remember to click "Mark as Answer" on this post if it helped you.
What's your version of ODP? You have OracleD...DBD::Oracle and Oracle 9.2?
My sysadmin is trying to install DBD::Oracle on a Solaris box running
The ph_type.t test is failing with
PERL_DL_NONLAZY=1 ./perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/ph_type....NOK 12 expected 'trailing' but got 'trailing ' for VARCHAR2
t/ph_type....FAILED test 12
Failed 1/19 tests, 94.74% okay
all skipped: no reason given
t/s...RE: :Oracle and Oracle 9.2?
I have the same experience on Linux however on Windows all tests passes =
(I'm not sure if it is related to different Oracle version - test of =
windows Perl against Linux Oracle is OK).
Linux Oracle: 18.104.22.168
Windows Oracle: 22.214.171.124
-- Petr Smejkal
-- Business Systems Analyst / Country IT Cz/Sk
-- +420 284 059 639
> -----Original Message-----
> From: Tom Malaher [mailto:firstname.lastname@example.org]
> Sent: Friday, April 04, 2003 1:35 AM
> To: email@example.com
> Subject: DBD::Oracle and Oracle 9.2?
> My sysadmi...DBD::Oracle 1.12 on Oracle 9iR2 126.96.36.199 test errors (again)
I am still not having any luck in getting the tests to pass. It appears to
be the CLOB re-reading that is failing.
I have checked all the usual places for help. I have also tried creating a
test stub that does a similar thing to the failed tests.
Below is the full set of information from the build and test as requested
(note this is long).
Anyone any ideas?
> perl Makefile.PL -v
Using DBI 1.32 installed in
Duplicate specification "S=s" for option "s"
Configuring D...DBD::Oracle 1.12 on Oracle 9iR2 188.8.131.52 test errors
I am having some problems testing DBD-Oracle-1.12 in the following
Compilation is fine.
Output from test stage is:
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/long.......Unexpectedly had to drop old test table 'dbd_ora__drop_me'
t/long.......ok 97/143Use of uninitialized value in numeric eq (==) at
t/long.t line 230.
# failed test 98 at line 230...Return an Oracle Ref Cursor to a .NET DataReader object by using the .NET Managed Provider for Oracle
I am wondering if anyone in this community knows the shorter way to return an Oracle Ref Cursor to a .NET DataReader object by using the .NET Managed Provider for Oracle, something likereturn (IDataReader) SqlHelper.ExecuteReader(ConnectionString, "GET_ACCOUNT", Id);
instead of using the way below (look at the C# code)
Stored Procedure create or replace PROCEDURE "GET_ACCOUNT"
p_ID IN ACCOUNT.ID%type, retCursor OUT SA.MYGEN.sqlcur
OPEN retCursor FOR
ID = p_ID
...Which .Net Provider for Oracle 9i Microsoft or Oracle
Can anyone provide me pros and cons of provider to access Oracle Database ? I am aware of Microsoft Provider and Oracle Provider.
I guess you can use either. But as some post suggests, if both installed, then MS ODP will not work.
I've been using DataDirect Technologies Connect for .Net and Oracle. It's not free, so it depends on your budget.
The speed improvements were great for us, and it's ni...DBD::Oracle and Oracle 9.2.0
need help making DBD:0racle work with Oracle 9.2.0
transcript follows this msg.
Problem appears to be related to 64-bit libraries.
After initial failure of "make", dropped back and ran
perl Makefile.PL -p
Encountered fatal error at make test.
Can someone drop me a clue as to where/what to try next?
Truly appreciate any help.
<< TRANSCRIPT OF SESSION >>
[oracle@jumpstart DBD-Oracle-1.14]$ perl Makefile.PL
Using DBI 1.37 installed in