473,511 Members | 15,503 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

oracle connect ; manual eror handling

Have been connecting to oracle using the following with success
my $dbHandle = DBI->connect($sConnectString, $sUsername, $sPassword );
adding ,\%attr after password permits me to set the db handle options

But now we use a different connect syntax to support OS authentication:
my $sLoginString = "$sUsername/$sPassword";
my $dbHandle = DBI->connect($sConnectString, $sLoginString) ;

this will work but if I add \%attr after the LoginString, the connect
complains that I gave it an empty password. What I need to be able to
do is to use the second syntax but still be able to set dbh options.
ANy ideas?

Jul 19 '05 #1
0 2835

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3698
by: jayPLEASEtylerNOwilliamsSPAM | last post by:
Hi, I set up PHP 4.xx using Apache 1.3 on Windows XP to begin a project. The project now needs to be moved to a real test box. Admittedly, I am not quite sure how I was able to access Oracle on my...
4
19967
by: susmita_ganguly | last post by:
Hi I am trying to upgrade from oracle 8i to oracle 9i on the same server ..I don't know much abt migration . Can anyone help me out. Thanks. Susmita
4
8933
by: sajid | last post by:
This is a treeview Root -- Cricket1 ---Cricket2 ---sachin --Cricket3 --dravid --FootBALL1
1
4590
by: vwhk | last post by:
Dear All, I new in Oracle. I would like to have your advice that how can I create a new oracle database in AIX. I've tried using "svrmgrl" on terminal but couldn't connect as "connect...
11
3535
by: DFS | last post by:
Architecture: Access 2003 client, Oracle 9i repository, no Access security in place, ODBC linked tables. 100 or so users, in 3 or 4 groups (Oracle roles actually): Admins, Updaters and ReadOnly....
1
2739
by: Yanick Quirion | last post by:
Hi all, I'm trying to find a simple code to connect to an Oracle Database (9i) with C under linux. I have a script that read a form from the web and I want to access my Oracle database with...
3
2114
by: Marvinq | last post by:
I am working on an Access 2002/Oracle vba automated overnight process. The problem is there is one user with rights to a certian set of tables and another user with a certain set of tables. I...
6
4913
by: sarat | last post by:
How to connect to oracle using C++ program and select some data from a table?
0
1812
by: MartyN | last post by:
I have a Windows 2000 machine (running IIS) which I upgraded from the Oracle 8i client to the 10g client. I did the whole "Oracle uninstall/reboot/manual file delete/manual registry editing/reboot"...
0
7242
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7138
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7508
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5662
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5063
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4737
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3222
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3212
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1572
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.