Perl Database connection string for Sql Server

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 = salem; # junk pwd Was told

Re: Perl Database connection string for Sql Server

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,$SQLUSER,$SQLPASS) || die (Database connection not made: $DBI::errstr

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

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 STDIN in which case, the password is # is prompted for: PassSTDIN # Connect attribute # dbi_connect_method

Re: Checking your database connection

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 analysis tool

Checking your database connection

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 !)

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

Help - perl to database connection

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

How to Keep a database connection

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

Keeping a database connection across a fork

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

Re: Keeping a database connection across a fork

-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

Re: Keeping a database connection across a fork

-- 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. But

Re: Keeping a database connection across a fork

-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

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: Database connection

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/lib

Re: Database connection

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

-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 from perl 5 I installed Indigoperl(perl 5

Re: Database connection

, 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 if i try to connect to database ,it showing error Can't

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 if i try to connect to database ,it showing error Can't locate DBI.pm in @INC (@INC contains: G:/Perl/lib

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 if i try to connect to database ,it showing error Can't locate DBI.pm in @INC (@INC contains: G:/Perl/lib