RE: Can't locate objrect method connect via package DBI

2001-07-06 Thread anshuman das

hi

this is the smallest part of my code.

**
#!/usr/bin/perl -w
#this is test.pl

use strict;
use DBI;

my $dbname = 'dcm_server';
my $datasource = 'dbi:Pg:dbname=dcm_server';
my $username = 'anshu';
my $auth = 'anshu';
my $host = '192.168.0.2';

print Trying to connect to database\n;
my $dbh = 
DBI-connect(dbi:Pg:dbname=$dbname;host=$host;,$username,$auth,{AutoCommit=0});

if ($dbh) { # If successfully connected
  print Connected to database\n;}
else {
  print Error Connecting to database\n;}



the error is  :
Can't locate object method connect via package DBI at test.pl line 14.

I have recently upgraded my system RHLinux 6.2 - RHLINUX 7
this upgradation made following changes
PostgreSQL 6.5 - 7
Perl 5 - perl 5.6.0
I installed DBI(1.14) and DBD manually.

Before upgradation, my code was performing very well.

Can you help me out?

Regards

Anshuman
[EMAIL PROTECTED]


From: Sterin, Ilya [EMAIL PROTECTED]
To: anshuman das [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Can't locate objrect method connect via package DBI
Date: Thu, 5 Jul 2001 22:21:07 -0400

Well let see the code, versions of DBI/DBD.

Ilya

  -Original Message-
  From: anshuman das [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, July 05, 2001 4:12 AM
  To: [EMAIL PROTECTED]
  Subject: Can't locate objrect method connect via package DBI
 
 
  Hi
 
  I have upgraded my machine as following
 
  RHLinux 6,.2 -- 7.0
  PostgreSql 65. -- 7.0
  Perl 5 --Perl 5.6
 
  I have installed DBI  DBD again after the upgradation.
  My problem is my old perl codes (which were running perfectly before
  upgradation) uses connect are not running. It can't connect postgresql
  databse through DBI. The error is ---
  Can't locate objrect method connect via package DBI
 
  I posted this letter earlier, somebody asked me wheather I used
  use DBI. THe
  answer yes, I mentioned that MY CODES WERE RUNNING PERFECTLY BEFORE
  UPGRADATION.
 
  Please help.
 
  Anshuman Das
  [EMAIL PROTECTED]
  
_
  Get Your Private, Free E-mail from MSN Hotmail at 
http://www.hotmail.com.

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.




RE: Can't locate objrect method connect via package DBI

2001-07-06 Thread Bhuvan A

Try, this code and check out whether you had implemented the
appropriate driver

here is the code..
*
#!/usr/local/bin/perl -w

use DBI;
use strict;

my(@drivers);
@drivers   =   DBI-available_drivers;
foreach(@drivers)   {print $_,\n;}



Get back with the result of this code!

bye!

-END-

On Fri, 6 Jul 2001, Neil Lunn wrote:

 The Script is fine so ther is something wrong with your installation. The
 output of perl -V and the output of your DBI build would be helpful.
 
 If you don't know how to do this:
 
 tar zxvf DBI-x.xx.tar.gz
 cd DBI-x.xx
 perl Makefile.PL 21 | tee log-conf
 make 21 | tee log-make
 make test 21 | tee log-test
 
 Paste the text from log-conf, log-make and log-test into your message.
 
 At a stab I would guess your old perl still resides on your system in
 another directory in your path, say /usr/local.
 
 -Neil
 
 
 -Original Message-
 From: anshuman das [mailto:[EMAIL PROTECTED]]
 Sent: Friday, July 06, 2001 7:53 PM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: RE: Can't locate objrect method connect via package DBI
 
 
 hi
 
 this is the smallest part of my code.
 
 **
 #!/usr/bin/perl -w
 #this is test.pl
 
 use strict;
 use DBI;
 
 my $dbname = 'dcm_server';
 my $datasource = 'dbi:Pg:dbname=dcm_server';
 my $username = 'anshu';
 my $auth = 'anshu';
 my $host = '192.168.0.2';
 
 print Trying to connect to database\n;
 my $dbh = 
 DBI-connect(dbi:Pg:dbname=$dbname;host=$host;,$username,$
 auth,{AutoCommit=0});
 
 if ($dbh) { # If successfully connected
   print Connected to database\n;}
 else {
   print Error Connecting to database\n;}
 
 
 
 the error is  :
 Can't locate object method connect via package DBI at 
 test.pl line 14.
 
 I have recently upgraded my system RHLinux 6.2 - RHLINUX 7
 this upgradation made following changes
 PostgreSQL 6.5 - 7
 Perl 5 - perl 5.6.0
 I installed DBI(1.14) and DBD manually.
 
 Before upgradation, my code was performing very well.
 
 Can you help me out?
 
 Regards
 
 Anshuman
 [EMAIL PROTECTED]
 
 
 From: Sterin, Ilya [EMAIL PROTECTED]
 To: anshuman das [EMAIL PROTECTED], [EMAIL PROTECTED]
 Subject: RE: Can't locate objrect method connect via package DBI
 Date: Thu, 5 Jul 2001 22:21:07 -0400
 
 Well let see the code, versions of DBI/DBD.
 
 Ilya
 
   -Original Message-
   From: anshuman das [mailto:[EMAIL PROTECTED]]
   Sent: Thursday, July 05, 2001 4:12 AM
   To: [EMAIL PROTECTED]
   Subject: Can't locate objrect method connect via package DBI
  
  
   Hi
  
   I have upgraded my machine as following
  
   RHLinux 6,.2 -- 7.0
   PostgreSql 65. -- 7.0
   Perl 5 --Perl 5.6
  
   I have installed DBI  DBD again after the upgradation.
   My problem is my old perl codes (which were running 
 perfectly before
   upgradation) uses connect are not running. It can't 
 connect postgresql
   databse through DBI. The error is ---
   Can't locate objrect method connect via package DBI
  
   I posted this letter earlier, somebody asked me wheather I used
   use DBI. THe
   answer yes, I mentioned that MY CODES WERE RUNNING PERFECTLY BEFORE
   UPGRADATION.
  
   Please help.
  
   Anshuman Das
   [EMAIL PROTECTED]
   
 __
 ___
   Get Your Private, Free E-mail from MSN Hotmail at 
 http://www.hotmail.com.
 
 ___
 __
 Get Your Private, Free E-mail from MSN Hotmail at 
 http://www.hotmail.com.
 
 __
 Please Note :
 Only  the intended recipient is authorised to access or use this e-mail.  If
 you are not the intended recipient,
 please delete this e-mail and notify the sender immediately.   The contents
 of this e-mail are the writer's 
 opinion and are not necessarily endorsed by the Gunz Companies unless
 expressly stated.
 
 We use virus scanning software but exclude all liability for viruses or
 similar in any attachment.
 




RE: Can't locate objrect method connect via package DBI

2001-07-05 Thread Neil Lunn


You will do better to post an example of your script, the actual error
message(s) received, and the output of perl -V, as is suggested in the
documentation.

You are running your script with -w aren't you!

--Neil

-Original Message-
From: anshuman das [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 6:12 PM
To: [EMAIL PROTECTED]
Subject: Can't locate objrect method connect via package DBI


Hi

I have upgraded my machine as following

RHLinux 6,.2 -- 7.0
PostgreSql 65. -- 7.0
Perl 5 --Perl 5.6

I have installed DBI  DBD again after the upgradation.
My problem is my old perl codes (which were running perfectly before
upgradation) uses connect are not running. It can't connect postgresql
databse through DBI. The error is ---
Can't locate objrect method connect via package DBI

I posted this letter earlier, somebody asked me wheather I 
used use DBI. THe 
answer yes, I mentioned that MY CODES WERE RUNNING PERFECTLY BEFORE 
UPGRADATION.

Please help.

Anshuman Das
[EMAIL PROTECTED]
___
__
Get Your Private, Free E-mail from MSN Hotmail at 
http://www.hotmail.com.

__
Please Note :
Only  the intended recipient is authorised to access or use this e-mail.  If
you are not the intended recipient,
please delete this e-mail and notify the sender immediately.   The contents
of this e-mail are the writer's 
opinion and are not necessarily endorsed by the Gunz Companies unless
expressly stated.

We use virus scanning software but exclude all liability for viruses or
similar in any attachment.