Sponsored Content
Full Discussion: Connecting to DB
Operating Systems AIX Connecting to DB Post 302189825 by rollthecoin on Monday 28th of April 2008 03:50:34 AM
Old 04-28-2008
Connecting to DB

Is it possible to connect to two databases in a single query with different username and passwords?

provide an example pls
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

connecting ....sql

if; sqlplus /nolog <<EOF conn / as sysdba spool /tmp/start.out @/oracle/home/start.sql spool off exit EOF fi For this code i am getting error: Test.sh: syntax error at line 7 : `<<' unmatched (8 Replies)
Discussion started by: dreams5617
8 Replies

2. UNIX for Dummies Questions & Answers

connecting the ip address

Hi, I have three ip address say x.x.x.x , y.y.y.y and z.z.z.z I am connecting to x.x.x.x first and from there i am telnet y.y.y.y and getting into y and from there i am telnet to z i want to know, can we write a script, which can automatically connect from x to y and from y to z.. is... (1 Reply)
Discussion started by: vasikaran
1 Replies

3. Shell Programming and Scripting

connecting unix to vb

how can i check to number of files and directory containing no data in whole system and display it if 'home' is to root directory it contains 10 subdirectory and many files (1 Reply)
Discussion started by: shafique
1 Replies

4. Linux

connecting to INTERNET

Hi, I can ping www.yahoo.com (then domain name server is OK) but I can not navigate by Motzila to www.yahoo.com or any other Web Site. What can be the problem ? Mozila is configured in preference /advance to go automaticaly on WEB. We are under RED HAT AS3. What should I check ? Many thanks... (1 Reply)
Discussion started by: big123456
1 Replies

5. UNIX for Dummies Questions & Answers

Connecting to the Internet

I have just installed Linux and everything looks great, but how do I get my browser (Mozilla) to connect to my internet service provider? I have a cable connection to Bigpond in Australia, if that means anything - the ISP will not provide support for Linux. Your help would be greatly... (2 Replies)
Discussion started by: openhead
2 Replies

6. Solaris

Ftp not connecting to ip

If i do a ftp localhost , it works but if i do a ftp x.x.x.x (ip ) it does not work thoug all the services are running what could be the reason for this bash-3.00# ftp localhost Connected to localhost. 220- bash-3.00# ftp 10.63.25.176 Connected to 10.63.25.176. 421 Service not available,... (7 Replies)
Discussion started by: fugitive
7 Replies

7. Shell Programming and Scripting

connecting through sqlplus

I am trying to connect to one of the oracle sever using uni through sqlplus command: sqlplus -s BOXI_ALPH_AUDITOR,Q078_audit$@Q047 But its not getting connected. I tried using some different server using same syntax its working. What differene i found is the password is having no special... (2 Replies)
Discussion started by: gander_ss
2 Replies

8. Shell Programming and Scripting

Connecting database

Hi all, In my concern they gave a task to me do cran job like To write a shell script for To connect a database it should execute a query it should save the output of the query after getting the output it should send a mail to you inbox for every one hour I can able to... (8 Replies)
Discussion started by: thelakbe
8 Replies

9. Linux

connecting to SSH

Well im on Fedora, and theres no sub section for Fedora so yea Well how do you connect to an SSH, while on a windows terminal? And also to transfer a file from my desktop to a server? how is this done scp command is not working for me (3 Replies)
Discussion started by: gangsta
3 Replies

10. Solaris

vpn not connecting

Hi, I have been using using internet explorer on windows for connecting with production server using vpn connection. i want to use same vpn to connect from solaris system to the production server.it is not connecting is there solution (0 Replies)
Discussion started by: malikshahid85
0 Replies
Password(3pm)						User Contributed Perl Documentation					     Password(3pm)

NAME
DBIx::Password - Allows you to create a global password file for DB passwords SYNOPSIS
use DBIx::Password; my $dbh = DBIx::Password->connect($user); my $dbh = DBIx::Password->connect_cached($user); $dbh->getDriver; DBIx::Password::getDriver($user); DBIx::Password::checkVirtualUser($user); DBIx::Password::clearConfig(); DBIx::Password::readConfig("$ENV{HOME}/.my.secret.file"); DESCRIPTION
Don't you hate keeping track of database passwords and such throughout your scripts? How about the problem of changing those passwords on a mass scale? This module is one possible solution. It stores all your virtual users and data in /etc/dbix-password.conf. For each user you need to specify the database module to use, the database connect string, the username and the password. You will have to give a name to this virtual user. You can add as many as you like. I would recommend that if you are only using this with web applications that you change the final permissions on this package after it is installed in site_perl such that only the webserver can read it. A method called getDriver has been added so that you can determine what driver is being used (handy for working out database indepence issues). If you want to find out if the virtual user is valid, you can call the class method checkVirtualUser(). It returns true(1) if the username is valid, and zero if not. Once your are done you can use the connect method (or the connect_cache method) that comes with DBIx-Password and just specify one of the virtual users you defined while making the module. BTW I learned the bless hack that is used from Apache::DBI so some credit should go to the authors of that module. This is a rewrite of the module Tangent::DB that I did for slashcode. If your program does not need the system-wide information stored in the /etc/dbix-password.conf file, you may use the clearConfig() and readConfig() functions to get the data from another source. At any time, readConfig() may also be used to merge the data from another file into the currently-loaded configuration. Hope you enjoy it. HOME
To find out more information look at: http://www.tangent.org/DBIx-Password/ AUTHOR
Brian Aker, brian@tangent.org SEE ALSO
perl(1). DBI(3). perl v5.10.0 2009-05-09 Password(3pm)
All times are GMT -4. The time now is 06:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy