Re: Perl Database connection string for Sql Server

2004-03-23 Thread Michael Peppler
directory.) > It is also able to find the Sybase.pm module. Cause > that error was sorted out. > Was told 1433 is the default port number by DBA. > # falcon is the database I want to connect to. > my $dbh = > DBI->connect("DBI:Sybase:falcon:$SQLSERVER:1433",$SQLUS

Perl Database connection string for Sql Server

2004-03-23 Thread v79k
.pl line 69 Database connection not made: at abc.pl line 69. My connection string is as follows. I have tried many other permutations but it won't connect. $SQLSERVER = "hawk"; # hawk is the SQL server, (also hostname right?) $SQLUSER = "merit"; # junk username $SQLPASS

Config::DBI - database connection support via Config::ApacheFormat files

2004-01-01 Thread Terrence Brannon
NAME Config::DBI - database connection support via Config::ApacheFormat files SYNOPSIS In .cshrc: setenv DBI_CONF dbi.conf In dbi.conf: # Pass may be a password, or in which case, the password is # is prompted for: Pass # Connect attribute # dbi_connect_method is a standard

Re: Checking your database connection

2003-08-14 Thread Andy Hassall
Ian Harisay wrote: > What is a convenient way to assert that the database connection you > have been working with is still valid? http://theoryx5.uwinnipeg.ca/CPAN/data/DBI/DBI.html#ping -- Andy Hassall ([EMAIL PROTECTED]) icq(5747695) (http://www.andyh.co.uk) Space: disk usage analysi

Checking your database connection

2003-08-07 Thread Ian Harisay
Hi, What is a convenient way to assert that the database connection you have been working with is still valid? Thanks, Ian

RE: Remote SQL Server Database Connection (examples please !)

2003-07-14 Thread Tim Johnson
Here's a script I use to notify users that there has been a change to their work order in our tracking system. It shows most things you might want to do with SQL via Perl. Note that this script assumes that you already have a DSN set up to connect to the DB using ODBC, and you may have to tweak

RE: Remote SQL Server Database Connection (examples please !)

2003-07-13 Thread Sterin, Ilya
Database Connection (examples please !) Hello: I am new in this list and have just a little experience with Perl. I want to connect to a remote SQL Server database and would like to receive an example of how to do this. I installed the iodbc (Drivers Manager) and then the DBD::ODBC, modules, i had to

Remote SQL Server Database Connection (examples please !)

2003-07-13 Thread Walter Lamagna
Hello: I am new in this list and have just a little experience with Perl. I want to connect to a remote SQL Server database and would like to receive an example of how to do this. I installed the iodbc (Drivers Manager) and then the DBD::ODBC, modules, i had to download the .rpms from libodbc bec

Help - perl to database connection

2002-07-11 Thread Bineesh Kumar P
Hi, I have a php page from which I want to connect to database through perl scripts. (Or is there any way by which I can call perl functions from php?) I use DBD::Oracle and DBI for connecting to Oracle from Perl. When I tried, the connection established through the first script is found to be i

How to Keep a database connection

2002-06-07 Thread Linda Xu
Hi, I am writing some report in perl to retrieve records from database. And every time when make a connection to database will take a long time. How can I make my script to 1. if the database connection is not there, make a connection from web server and database 2. if database

Re: Keeping a database connection across a fork

2001-09-01 Thread qmi
Hi, All: I have the almost same problems and I tried to initiate the database connection in the child. But every time I can only make database connection and do something only once. If I want to do it again it always shows me the application error and my server is killed(the program exit

Re: Keeping a database connection across a fork

2001-09-01 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sat, Sep 01, 2001 at 02:30:57PM -0500, Steven Lembark wrote: > Actually you can. Trick is to turn on the NO-DESTROY option (forgot the > exact keyword) and let the children destroy things when they exit. It's > actually fairly workable to share a

Re: Keeping a database connection across a fork

2001-09-01 Thread Steven Lembark
-- Stephen Clouse <[EMAIL PROTECTED]> > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Wed, Aug 29, 2001 at 03:23:39PM -0500, Jay Strauss wrote: >> I'm trying to write a daemon that accesses my database. I thought I >> could create the connection in the parent, and use it in the child.

Re: Keeping a database connection across a fork

2001-09-01 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, Aug 29, 2001 at 03:23:39PM -0500, Jay Strauss wrote: > I'm trying to write a daemon that accesses my database. I thought I could > create the connection in the parent, and use it in the child. But that > doesn't seem to work. Below is the c

Keeping a database connection across a fork

2001-09-01 Thread Jay Strauss
Hi, I'm trying to write a daemon that accesses my database. I thought I could create the connection in the parent, and use it in the child. But that doesn't seem to work. Below is the code. Any help would be appreciated Thanks Jay #!/usr/bin/perl -w use strict; use DBI; use POSIX qw(setsid

Re: Database connection

2001-08-16 Thread Bart Lateur
On Thu, 16 Aug 2001 10:11:50 +0200, Elango, Palchamy wrote: >It seems new Perl path (d:\Indigoperl) has not been set. Your script still >trying to find DBI.pm in G:\Perl Yeah. Run the "setup" script disguised as a DOS .bat file. -- Bart.

Re: Database connection

2001-08-16 Thread Elango, Palchamy
  It seems new Perl path (d:\Indigoperl) has not been set.  Your script still trying to find DBI.pm in G:\Perl Elango   gopinath r wrote: Hello I have some doubts about connecting oracle 8.4 database from perl 5 I installed Indigoperl(perl 5) in widows NT system.The directory G:/Indigoperl/site/l

Re: Database connection

2001-08-15 Thread Konstantin
ROTECTED]> Sent: Wednesday, August 15, 2001 8:51 AM Subject: Database connection > Hello > > I have some doubts about connecting oracle 8.4 > database from perl 5 > > I installed Indigoperl(perl 5) in widows NT system.The > directory G:/Indigoperl/site/lib contains DBI.pm > i

RE: Database connection

2001-08-15 Thread Neil Lunn
>-Original Message- >From: gopinath r [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, August 15, 2001 4:52 PM >To: [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Subject: Database connection > > >Hello > >I have some doubts about connecting oracle 8.4 >

Database connection

2001-08-15 Thread gopinath r
Hello I have some doubts about connecting oracle 8.4 database from perl 5 I installed Indigoperl(perl 5) in widows NT system.The directory G:/Indigoperl/site/lib contains DBI.pm if i try to connect to database ,it showing error "Can't locate DBI.pm in @INC (@INC contains: G:/Perl/lib G:/Perl/si

Database connection

2001-08-15 Thread gopinath r
Hello I have some doubts about connecting oracle 8.4 database from perl 5 I installed Indigoperl(perl 5) in widows NT system.The directory G:/Indigoperl/site/lib contains DBI.pm if i try to connect to database ,it showing error "Can't locate DBI.pm in @INC (@INC contains: G:/Perl/lib G:/Perl/si