Error when connecting mysql or oracle
Hi All, I got a code from a PERL list that inserts a row into a mysql db table. I changed to my needs, tried, and it worked. Then I decided to install DBD-Oracle.ppd to see if it would work well with Oracle but it did not. After that my machine rebooted for no reason and now when I run the same script that worked once for mySQL I get the following message: [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] DBD::oracle initialisation failed: Can't locate object method driver via package DBD::oracle at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'oracle' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugsora.cgi line 71 [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 Does anyone know how to fix it??? thanks sio _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error when connecting mysql or oracle
Well, this really isn't a mysql issue. This is an ActiveState perl issue, But it sounds like you've clobbered your DBD files some how and or you're just not initializing them correctly. Siomara Pantarotto wrote: Hi All, I got a code from a PERL list that inserts a row into a mysql db table. I changed to my needs, tried, and it worked. Then I decided to install DBD-Oracle.ppd to see if it would work well with Oracle but it did not. After that my machine rebooted for no reason and now when I run the same script that worked once for mySQL I get the following message: [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] DBD::oracle initialisation failed: Can't locate object method driver via package DBD::oracle at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'oracle' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugsora.cgi line 71 [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 Does anyone know how to fix it??? thanks sio _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error when connecting mysql or oracle
I reinstalled these two packages: D:\Perl\binppm install DBI.ppd Installing package 'DBI.ppd'... Writing D:\Perl\site\lib\auto\DBI\.packlist D:\Perl\binppm install DBD-Mysql.ppd Installing package 'DBD-Mysql.ppd'... Writing D:\Perl\site\lib\auto\DBD\Mysql\.packlist and now it works again: mysql select * from bug; +---+---+ | bugID | description | +---+---+ | 1 | The system reboots when you click button continue | | 2 | The main page crashes when more than 3 user connect to the system | | 3 | BLA BLA BLA | +---+---+ 3 rows in set (0.12 sec) the third line I insert via cgi script. My question now are: Do you think that when installing DBD-Oracle things got messed up??? Doe anyone know how to make it work with Orcale besides mysql?? Thanks siomara From: Colin Faber [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Siomara Pantarotto [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Error when connecting mysql or oracle Date: Sun, 20 May 2001 22:43:37 -0600 Well, this really isn't a mysql issue. This is an ActiveState perl issue, But it sounds like you've clobbered your DBD files some how and or you're just not initializing them correctly. Siomara Pantarotto wrote: Hi All, I got a code from a PERL list that inserts a row into a mysql db table. I changed to my needs, tried, and it worked. Then I decided to install DBD-Oracle.ppd to see if it would work well with Oracle but it did not. After that my machine rebooted for no reason and now when I run the same script that worked once for mySQL I get the following message: [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] DBD::oracle initialisation failed: Can't locate object method driver via package DBD::oracle at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'oracle' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugsora.cgi line 71 [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 Does anyone know how to fix it??? thanks sio _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error when connecting mysql or oracle
well I've never really looked into how the PPM app that activestate works, I'd assume you'd probably just want to go grab the .zip file and unzip it into your library path your self, Then when you want to play with it make sure to use the Oracle driver in your DBI connect statement. Siomara Pantarotto wrote: I reinstalled these two packages: D:\Perl\binppm install DBI.ppd Installing package 'DBI.ppd'... Writing D:\Perl\site\lib\auto\DBI\.packlist D:\Perl\binppm install DBD-Mysql.ppd Installing package 'DBD-Mysql.ppd'... Writing D:\Perl\site\lib\auto\DBD\Mysql\.packlist and now it works again: mysql select * from bug; +---+---+ | bugID | description | +---+---+ | 1 | The system reboots when you click button continue | | 2 | The main page crashes when more than 3 user connect to the system | | 3 | BLA BLA BLA | +---+---+ 3 rows in set (0.12 sec) the third line I insert via cgi script. My question now are: Do you think that when installing DBD-Oracle things got messed up??? Doe anyone know how to make it work with Orcale besides mysql?? Thanks siomara From: Colin Faber [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Siomara Pantarotto [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Error when connecting mysql or oracle Date: Sun, 20 May 2001 22:43:37 -0600 Well, this really isn't a mysql issue. This is an ActiveState perl issue, But it sounds like you've clobbered your DBD files some how and or you're just not initializing them correctly. Siomara Pantarotto wrote: Hi All, I got a code from a PERL list that inserts a row into a mysql db table. I changed to my needs, tried, and it worked. Then I decided to install DBD-Oracle.ppd to see if it would work well with Oracle but it did not. After that my machine rebooted for no reason and now when I run the same script that worked once for mySQL I get the following message: [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] DBD::oracle initialisation failed: Can't locate object method driver via package DBD::oracle at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'oracle' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugsora.cgi line 71 [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 Does anyone know how to fix it??? thanks sio _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http