please stop forwarding any more mail
please stop forwarding any more mail thanks
[Oracle] DBI: Oracle client libs necessary ??
Hi this is just a question for my understanding: Does the perl-dbi module depends/needs the oracle client library installation (at least) or does connecting to oracle databases on remote hosts work without it ? ty Markus
How to get out of dbi-users
I doubt this will do much good since you didn't read the responses to the last person who sent such a request to the list, but if you send email to [EMAIL PROTECTED] you will receive instructions that include how to unsubscribe from this list. The same instructions were sent to you when the list moved to perl.org or when you subscribed, whichever was later. If you have already tried the instructions from [EMAIL PROTECTED] and were not able to get removed from the list, please send your request to [EMAIL PROTECTED], not to the list. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: gadgil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 00:13 Subject: please stop forwarding any more mail please stop forwarding any more mail thanks
Re: [Oracle] DBI: Oracle client libs necessary ??
It needs at least the Oracle SQL*Net software to connect to remote hosts. To build, it also needs either Oracle's Pro*C or OCI. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: Markus Fischer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 00:11 Subject: [Oracle] DBI: Oracle client libs necessary ?? this is just a question for my understanding: Does the perl-dbi module depends/needs the oracle client library installation (at least) or does connecting to oracle databases on remote hosts work without it ?
Re: [Oracle] DBI: Oracle client libs necessary ??
Say you have an Oracle DB installed and running on Machine A. To use DBI with the database you need the DBD::Oracle module installed on a machine where you also have the Oracle client libraries, etc. installed, either Machine A itself, or another machine, Machine B. If you want to run the Perl code on Machine A or Machine B then there is no problem. Just install DBD::Oracle on them. If you do not have the Oracle client installed on the machine where you want to run your Perl code, Machine C, then you can use the DBD:Proxy module (with supporting modules Net::Daemon, RPC:PlServer and Storable) installed on Machine C, and those modules plus DBD::Oracle installed on Machine A or B. Then, Machine C can run Perl code against the database on Machine A. If you need to go the DBD::Proxy route then you should consult the Cheetah Book Programmming the Perl DBI, and it's a good idea to consult it anyway. -- David Adams Computing Services Southampton University - Original Message - From: Markus Fischer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 8:11 AM Subject: [Oracle] DBI: Oracle client libs necessary ?? Hi this is just a question for my understanding: Does the perl-dbi module depends/needs the oracle client library installation (at least) or does connecting to oracle databases on remote hosts work without it ? ty Markus
Re: dbi connection error
You've got the connection string and DSN definition confused.
For a DSN-less connection use something like:
my $DSN = 'driver={SQL Server};
Server=.;database=vision;
uid=sa;pwd=secret;';
my $dbh = DBI-connect(dbi:ODBC:$DSN) or die $DBI::errstr\n;
--
Simon Oliver
(Fwd) Question: Oracle 8.1.7 with Perl
- Forwarded message from Kim Leung [EMAIL PROTECTED] - Date: Thu, 14 Jun 2001 19:35:28 +1000 (EST) From: Kim Leung [EMAIL PROTECTED] Subject: Question: Oracle 8.1.7 with Perl To: [EMAIL PROTECTED] Hi Tim, I was looking at dbi-users and your name keeps reappearing with answers so I thought I would direct my question at you. I just want to know if Perl 5.6 (is there such a version or does this mean its version 5.006?) using DBI v1.13 and DBD:Oracle 1.03 will still all work if I upgrade the Oracle database from v7.3.4 to v8.1.7? If the answer is no, then what versions of Perl, DBI and DBD:Oracle should I upgrade to so that they are compliant to Oracle8.1.7? You must be a busy man, but I would appreciate it very much if you can reply ASAP. Thanks in advance. Kim Leung Analyst/Programmer _ http://messenger.yahoo.com.au - Yahoo! Messenger - Voice chat, mail alerts, stock quotes and favourite news and lots more! - End forwarded message -
(Fwd) DBperl extension
- Forwarded message from Daniel Czajko [EMAIL PROTECTED] - From: Daniel Czajko [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: DBperl extension Date: Fri, 15 Jun 2001 15:54:57 -0400 Could you point me in the direction where I can download the Oracle extension to Perl that would work with Perl version 5? Thanks Daniel Czajko Co-op student-Information Systems Ontario College Application Services 370 Speedvale Avenue Guelph, Ontario N1H 7M7 1-888-892-2228 x218 http://www.ocas.on.ca http://www.saco.on.ca - End forwarded message -
(Fwd) about tpmonitor
- Forwarded message from liu_wen [EMAIL PROTECTED] - From: liu_wen [EMAIL PROTECTED] To: Tim.Bunce [EMAIL PROTECTED] Subject: about tpmonitor Date: Mon, 18 Jun 2001 09:37:02 +0800 Hi,Tim Bunce I know u from http://www.grin.net/~mirthles/pile/database_connection_pooling.html, Could u tell me some info about tp and where I can find more resources? thanks. Peaker - End forwarded message -
Re: DBI Connect Failure
Ron, Michael, Thanks, using option 1, all the syntax errors are cleared up! I'm not too clear on where the print statements are needed, so if you could refer me to some documentation about this, I'd appreciate it. However I still can't connect to my sample Postgres database. On: package PgSQL; use strict; use PgSQL::Cursor; use CGI qw(:standard); my $dbh; $dbh = db_connect(mydb) or die Error: $PgSQL::error; print $dbh; I get: Undefined subroutine PgSQL::db_connect called Thanks again for your help, Christine Ronald J Kimball wrote: On Wed, Jun 20, 2001 at 03:47:31PM +0200, Christine Kluka wrote: Neil, Thanks, I added my to this variable and to the array and hash declarations in my row subroutine -- this eliminated the not imported errors. Now when I execute the script I am prompted for explicit package names for each instance of a scalar, array or hash. I believe that if I declare the fully qualified package name where the database handler is invoked, this should take care of the problem. I've tried several ways of doing this, but they all fail on syntax or for more serious reasons. That's another error that means you haven't declared your variables. When you use strict 'vars', you have three options for each variable. Declare it with my: my $lexical_variable; $lexical_variable = 7; print $lexical_variable; Declare it with use vars: use vars qw/ $global_variable /; $global_variable = 7; print $global_variable; Specify the package name every time you use it: $main::global_variable = 7; print $main::global_variable; Most people prefer the first two options. Ronald
RE: please stop forwarding any more mail
You mean unsubscribe, because it sounds like you are responding to spam, you must of forgotten that you actually signed up for this service. As Michaels said, [EMAIL PROTECTED] Ilya -Original Message- From: gadgil To: [EMAIL PROTECTED] Sent: 6/21/01 1:13 AM Subject: please stop forwarding any more mail please stop forwarding any more mail thanks
RE: (Fwd) DBperl extension
You must now use DBI and DBD::Oracle modules from www.cpan.org. Oraperl is the old extension of processing Oracle queries. Ilya -Original Message- From: Tim Bunce To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: 6/21/01 6:00 AM Subject: (Fwd) DBperl extension - Forwarded message from Daniel Czajko [EMAIL PROTECTED] - From: Daniel Czajko [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: DBperl extension Date: Fri, 15 Jun 2001 15:54:57 -0400 Could you point me in the direction where I can download the Oracle extension to Perl that would work with Perl version 5? Thanks Daniel Czajko Co-op student-Information Systems Ontario College Application Services 370 Speedvale Avenue Guelph, Ontario N1H 7M7 1-888-892-2228 x218 http://www.ocas.on.ca http://www.saco.on.ca - End forwarded message -
RE: DBI Connect Failure
Well do you have a db_connect subroutine defined for the PgSQL namespace? It's telling you the exact problem. Ilya -Original Message- From: Christine Kluka To: Ronald J Kimball; Chase Michael A. Cc: Neil Lunn; [EMAIL PROTECTED] Sent: 6/21/01 6:14 AM Subject: Re: DBI Connect Failure Ron, Michael, Thanks, using option 1, all the syntax errors are cleared up! I'm not too clear on where the print statements are needed, so if you could refer me to some documentation about this, I'd appreciate it. However I still can't connect to my sample Postgres database. On: package PgSQL; use strict; use PgSQL::Cursor; use CGI qw(:standard); my $dbh; $dbh = db_connect(mydb) or die Error: $PgSQL::error; print $dbh; I get: Undefined subroutine PgSQL::db_connect called Thanks again for your help, Christine Ronald J Kimball wrote: On Wed, Jun 20, 2001 at 03:47:31PM +0200, Christine Kluka wrote: Neil, Thanks, I added my to this variable and to the array and hash declarations in my row subroutine -- this eliminated the not imported errors. Now when I execute the script I am prompted for explicit package names for each instance of a scalar, array or hash. I believe that if I declare the fully qualified package name where the database handler is invoked, this should take care of the problem. I've tried several ways of doing this, but they all fail on syntax or for more serious reasons. That's another error that means you haven't declared your variables. When you use strict 'vars', you have three options for each variable. Declare it with my: my $lexical_variable; $lexical_variable = 7; print $lexical_variable; Declare it with use vars: use vars qw/ $global_variable /; $global_variable = 7; print $global_variable; Specify the package name every time you use it: $main::global_variable = 7; print $main::global_variable; Most people prefer the first two options. Ronald
RE: (Fwd) Question: Oracle 8.1.7 with Perl
-Original Message- From: Tim Bunce To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: 6/21/01 5:58 AM Subject: (Fwd) Question: Oracle 8.1.7 with Perl - Forwarded message from Kim Leung [EMAIL PROTECTED] - Date: Thu, 14 Jun 2001 19:35:28 +1000 (EST) From: Kim Leung [EMAIL PROTECTED] Subject: Question: Oracle 8.1.7 with Perl To: [EMAIL PROTECTED] Hi Tim, I was looking at dbi-users and your name keeps reappearing with answers so I thought I would direct my question at you. If you see Tim's posts on the dbi-users, why would you direct your question to him, since he'll still be able to see it if you direct to dbi-users??? I don't think anyone on any list likes any direct emails, so please forward all non-personal questions to dbi users list. I just want to know if Perl 5.6 (is there such a version or does this mean its version 5.006?) using DBI v1.13 and DBD:Oracle 1.03 will still all work if I upgrade the Oracle database from v7.3.4 to v8.1.7? It might still work, but it's best to recompile DBD::Oracle. While you are at it, might as well upgrade to the latest releases, plus recompiling with OCI8 will have it's own benefits, like the LOB fetching with LongReadLen. If the answer is no, then what versions of Perl, DBI and DBD:Oracle should I upgrade to so that they are compliant to Oracle8.1.7? You must be a busy man, but I would appreciate it very much if you can reply ASAP. Thanks in advance. Kim Leung Analyst/Programmer _ http://messenger.yahoo.com.au - Yahoo! Messenger - Voice chat, mail alerts, stock quotes and favourite news and lots more! - End forwarded message -
Altering the @INC array
Hi all, Is there a way to to alter the @INC array, the original @INC is: /usr/local/lib/perl5/5.00503/sun4-solaris /usr/local/lib/perl5/5.00503 /usr/local/lib/perl5/site_perl/5.005/sun4-solaris /usr/local/lib/perl5/site_perl/5.005 and I want my script to go to: /export/home/mahdi/perl5/5.00503/sun4-solaris /export/home/mahdi/perl5/5.00503 /export/home/mahdi/perl5/site_perl/5.005/sun4-solaris /export/home/mahdi/perl5/site_perl/5.005 Is this possible, I tried using use lib @my_INC like this, and when printing the @INC it is still the same as before: #!/usr/local/bin/perl -w @my_INC=qw(/export/home/mahdi/perl5/5.00503/sun4-solaris /export/home/mahdi/perl5/5.00503 /export/home/mahdi/perl5/site_perl/5.005/sun4-solaris /export/home/mahdi/perl5/site_perl/5.005); use lib @my_INC; print (\n\n@INC\n\n); use DBI; use DBD::Informix::TechSupport; print_versions(Perl DBI DBD::Informix ESQL/C Licence); ___ Mahdi A. Sbeih Software Engineer IDS Software Systems http://www.idsusa.com ___
RE: Altering the @INC array
This is not related to DBI although you are using this module. It doesn't even look like you made an attempt to look it up in the reference. @INC is an array, so how do you alter/add to an array? I would answer but that would promote OT questions, and now that groups.google.com is available, it's very easy to post to comp.lang.perl.misc. Ilya -Original Message- From: Mahdi A. Sbeih To: [EMAIL PROTECTED] Sent: 6/21/01 9:05 AM Subject: Altering the @INC array Importance: High Hi all, Is there a way to to alter the @INC array, the original @INC is: /usr/local/lib/perl5/5.00503/sun4-solaris /usr/local/lib/perl5/5.00503 /usr/local/lib/perl5/site_perl/5.005/sun4-solaris /usr/local/lib/perl5/site_perl/5.005 and I want my script to go to: /export/home/mahdi/perl5/5.00503/sun4-solaris /export/home/mahdi/perl5/5.00503 /export/home/mahdi/perl5/site_perl/5.005/sun4-solaris /export/home/mahdi/perl5/site_perl/5.005 Is this possible, I tried using use lib @my_INC like this, and when printing the @INC it is still the same as before: #!/usr/local/bin/perl -w @my_INC=qw(/export/home/mahdi/perl5/5.00503/sun4-solaris /export/home/mahdi/perl5/5.00503 /export/home/mahdi/perl5/site_perl/5.005/sun4-solaris /export/home/mahdi/perl5/site_perl/5.005); use lib @my_INC; print (\n\n@INC\n\n); use DBI; use DBD::Informix::TechSupport; print_versions(Perl DBI DBD::Informix ESQL/C Licence); ___ Mahdi A. Sbeih Software Engineer IDS Software Systems http://www.idsusa.com ___
Re: Altering the @INC array
Is there a way to to alter the @INC array, the original @INC is:
/usr/local/lib/perl5/5.00503/sun4-solaris
/usr/local/lib/perl5/5.00503
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris
/usr/local/lib/perl5/site_perl/5.005
and I want my script to go to:
/export/home/mahdi/perl5/5.00503/sun4-solaris
/export/home/mahdi/perl5/5.00503
/export/home/mahdi/perl5/site_perl/5.005/sun4-solaris
/export/home/mahdi/perl5/site_perl/5.005
Just add the extra search paths to your @INC array by doing:
sub BEGIN {
unshift(@INC, qw(
/export/home/mahdi/perl5/5.00503/sun4-solaris
/export/home/mahdi/perl5/5.00503
/export/home/mahdi/perl5/site_perl/5.005/sun4-solaris
/export/home/mahdi/perl5/site_perl/5.005
)
);
}
Or do:
use lib qw(
/export/home/mahdi/perl50/5.00503/sun4-solaris
/export/home/mahdi/perl5/5.00503
/export/home/mahdi/perl5/site_perl/5.005/sun4-solaris
/export/home/mahdi/perl5/site_perl/5.005
);
If you print out the contents of your @INC array it will display
the additional paths.
Have fun ...
Berry
Re: DBI Connect Failure
You should be assigning DBI-connect() to $dbh. I'm not sure what all arguments you need for DBD::Postgresql (run perldoc DBD::Postgress to see), but you should at least include error checking of some sort (run perldoc DBI for examples). -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: Christine Kluka [EMAIL PROTECTED] To: Ronald J Kimball [EMAIL PROTECTED]; Chase Michael A. [EMAIL PROTECTED] Cc: Neil Lunn [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 05:14 Subject: Re: DBI Connect Failure Ron, Michael, Thanks, using option 1, all the syntax errors are cleared up! I'm not too clear on where the print statements are needed, so if you could refer me to some documentation about this, I'd appreciate it. However I still can't connect to my sample Postgres database. On: package PgSQL; use strict; use PgSQL::Cursor; use CGI qw(:standard); my $dbh; $dbh = db_connect(mydb) or die Error: $PgSQL::error; print $dbh; I get: Undefined subroutine PgSQL::db_connect called Thanks again for your help, Christine Ronald J Kimball wrote: On Wed, Jun 20, 2001 at 03:47:31PM +0200, Christine Kluka wrote: Neil, Thanks, I added my to this variable and to the array and hash declarations in my row subroutine -- this eliminated the not imported errors. Now when I execute the script I am prompted for explicit package names for each instance of a scalar, array or hash. I believe that if I declare the fully qualified package name where the database handler is invoked, this should take care of the problem. I've tried several ways of doing this, but they all fail on syntax or for more serious reasons. That's another error that means you haven't declared your variables. When you use strict 'vars', you have three options for each variable. Declare it with my: my $lexical_variable; $lexical_variable = 7; print $lexical_variable; Declare it with use vars: use vars qw/ $global_variable /; $global_variable = 7; print $global_variable; Specify the package name every time you use it: $main::global_variable = 7; print $main::global_variable; Most people prefer the first two options. Ronald
DBIx::AnyDBD
Since my last 2 posts prompted absolutely no replies whatsoever my question is simply this: Has anyone implemented DBIx::AnyDBD? I realize that this isn't specifically a DBI question, but the perldoc documentation for DBIx points to this forum. Jeff
Re: DBD::Sybase, dbiproxy, and the table_info method...
Previously, I wrote: I just finished upgrading a bunch of modules. I upgraded from DBI 1.13 to 1.18, DBD::Sybase 0.21 to 0.91, Net::Daemon 0.29 to 0.35, and Storable 0.6.7 to 1.0.11. I also had to upgrade File::Spec since my File::Spec didn't have the tmpdir method which DBI::ProxyServer.pm now uses. (I'm still using Perl 5.005_03.) I might have been wrong about this working before I upgraded all those messages. I could have sworn that my table_info script used to work via dbiproxy, but I just reverted all of the above modules (except for File::Spec) back to the versions I was using previously, and table_info still isn't working. Unfortunately, I didn't have debug turned on in my dbiproxy logfile, so I can't prove it definitively one way or the other, though I did notice a fair number of 'Can't call method execute without a package or object reference at /usr/contrib/lib/perl5/site_perl/5.005/alpha-dec_osf/DBD/Sybase.pm line 151' errors in my non-debug dbiproxy logfile going back over the past year. Michael Peppler responded: This would mean that the prepare() call in DBD::Sybase's table_info() returns undef - but that *should* only happen if you already have an active statement handle on that connection, and if DBD::Sybase is unable to open a new connection. Michael, does the table_info method work for you via dbiproxy? Any suggestions on how I should proceed to get to the bottom of this?
Mass Update
Hi All,
Got a problem I am trying to figure out the best way to handle, using Perl w/DBI
We have a table with a Password column, that accidentally had all the Password
entered incorrectly. They where suppose to be encrypted before entered into the
table, approximate 540 passwords.
What I need to do is pull all the passwords from the table, all except the very
first row, id #1. The id column is an auto incremented column. So I would need
to do:
SELECT Password FROM Users WHERE id 1
my @password = $sth-fetchrow_array();
Now what I need to do is do a mass UPDATE back into the Users table after
encrypting the password, something like this:
for (my $i; $i @password; $i++) {
# The $salt value is done here
my $pass = crypt($password[$i], $salt);
# Now do the mass Update here back into the Users table with the new $pass
# variable
}
I figure this would be best handle with a place holder or bind_column, but not
real sure the best way to do this, and keep it efficient. Any help would be much
appreciated ;)
TIA,
Mike(mickalo)Blezien
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=
Problems with DBD-Oracle and HP-UX
Hi, After 2 weeks of trying, I decided ask for help. I have many problems to use DBD-Oracle with HP-UX. I have many errors with linking. I try many options of the linker 'ld' but without succes. This is report of my last try : (See attached file: DBD_err.txt) Can you help me. Thanks in advence Rafal Ce message peut contenir des informations confidentielles protegees par le secret professionnel. Si vous avez recu cet e-mail par erreur, nous vous remercions de bien vouloir nous en aviser et de le detruire immediatement. This message may contain privileged or confidential information. If you have received this e-mail by mistake, please immediately notify us and destroy it. Credit Agricole Indosuez == Text - character set unknown
Installation Error
# /usr/ccs/bin/make gcc -c -fno-strict-aliasing -I/usr/local/include -O-DVERSION=\1.18\ -DXS_VERSION=\1.18\ -fPIC -I/usr/local/lib/perl5/5.6.1 /sun4-solaris/CORE -DDBI_NO_THREADS Perl.c sh: gcc: not found *** Error code 1 make: Fatal error: Command failed for target `Perl.o' I hope i find the solution to this error. Thanks Naveen
RE: Max connection of Perl-DBI
Please don't send emails not pertaining to the development of DBI to [EMAIL PROTECTED] If you read the directions before signing up, you would have read the purpose of each list. See comments below... -Original Message- From: Alex Kusuma Tjahjana [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 5:56 AM To: [EMAIL PROTECTED] Subject: Max connection of Perl-DBI Dear all, I have a little problem regarding connection on a Perl-DBI. I already settle a remote database connection from my web server to my database server. After several time, my software and my web server is stop responding requet from clients. My software heavily rely on the database connection. Yes, the traffic between my web and database What database are you using? It's hard to tell from your message:-) connection is very dense. And it seems that after the number of Perl process (about 100 simultaneous processes) on my web server, the software and the database is stop responding. Stops responding? You mean hangs or errors out? PS: the connection has been running well for 1 year and several months and all this time, nothing happened. However, it is true that current load is very peak that usual. My question: Is Perl-DBI have an upper limit of simultaneous database connection? If there is any, what is limit and how much? Your database software should have a limit of simultaneous connections and you will probably need to change that. What is the error message you are getting? Thank you. If there is any further question or information you need to know, do not hesitate to contact me. Yours Truly, Alex Kusuma Tjahjana Phone: +62 +21 +515 3268 / 69 email: [EMAIL PROTECTED]
RE: Installation Error
You either don't have gcc installed or you it's not in your path. Ilya Sterin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 4:43 PM To: [EMAIL PROTECTED] Subject: Installation Error # /usr/ccs/bin/make gcc -c -fno-strict-aliasing -I/usr/local/include -O-DVERSION=\1.18\ -DXS_VERSION=\1.18\ -fPIC -I/usr/local/lib/perl5/5.6.1 /sun4-solaris/CORE -DDBI_NO_THREADS Perl.c sh: gcc: not found *** Error code 1 make: Fatal error: Command failed for target `Perl.o' I hope i find the solution to this error. Thanks Naveen
Re: DBD install
[EMAIL PROTECTED] wrote: Hi, I'm trying to install DBD 1.00 PC1 on my system and I'm stuck, any help would be appreciated. OS: Sun Solaris 5.6 sparc Perl: v5.6.1 built for sun4-solaris I've installed Informix server 7.3.1 + sql 7.30 + esql 5.10 + DBI 5.1 This is an unusual combination of products, to put it politely. Normally, you'd use ESQL/C 5.10 with a 5.10 server; for a 7.31 server, you'd be using some version of CSDK (which contains ESQL/C version 9.x). Since CSDK is a free download from http://www.informix.com/evaluate, I see no reason why I shouldn't send you off to get that, to uninstall ESQL/C 5.10, and then install CSDK (2.70 is probably the latest; anything from 2.30 upwards would be OK). This is by far the easiest solution, and increases the functionality you get to boot -- multiple connections are an option with CSDK but not with ESQL/C 5.10. I've tried to set variables to demo table stores7 as well When I run as root # perl Makefile I get: __ Perl: perl5.006001 sun4-solaris dl_dlopen.xs System: sunos 5.6 generic_105181-11 sun4m sparc sunw,sparcstation-5 Compiler: cc -O -I/usr/local/include -I/opt/gnu/include -D_LARGEFILE_SOURCE -D_F ILE_OFFSET_BITS=64 Using INFORMIX-ESQL Version 5.10.UD1 from /database/informix You need to use a customized ESQL/C compiler script which recognizes the INFORMIXC environment variable. I'll create a local version and ensure that we use it. You may run into problems creating a shared object version of DBD::Informix. If so, try creating a statically linked version instead. Read the Notes/static.build file. Assert macro will be disabled! Testing whether your Informix test environment will work... ESQLTEST Program Running: @(#)$Id: esqltest.ec version /main/20 2000-02-08 16:57:02 $ $DBI_DBNAME set to 'testdb'. $DBD_INFORMIX_DATABASE set to 'testdb@test_rmt'. $DBD_INFORMIX_DATABASE2 unset - defaulting to 'testdb@test_rmt'. $DBD_INFORMIX_USERNAME is set to 'informix'. $DBD_INFORMIX_USERNAME2 is unset - defaulting to 'informix'. $DBD_INFORMIX_PASSWORD is set. $DBD_INFORMIX_PASSWORD2 is unset - defaulting to $DBD_INFORMIX_PASSWORD. Testing connection to testdb@test_rmt DBD_INFORMIX_USERNAME DBD_INFORMIX_PASSWORD are ignored. DATABASE testdb@test_rmt SQL: -409: Sqlexec was not found or was not executable by the current user. Testing connection to testdb@test_rmt DATABASE testdb@test_rmt SQL: -409: Sqlexec was not found or was not executable by the current user. *** Your Informix environment is not usable *** You must fix it before building or testing DBD::Informix If you insist on staying put with ESQL/C 5.10, then you will have to set the SQLEXEC environment variable to sqlrm assuming that $INFORMIXDIR/lib/sqlrm exists. If the sqlrm program does not exist, then you have no choice but to upgrade to CSDK 2.x. With the 5.x servers, there was a program (either sqlturbo for OnLine or sqlexec for SE) that was run by ESQL/C that represented the database server. With the 7.3x servers, there is no equivalent to sqlturbo, but the Relay Module (sqlrm) was provided to allow old programs using 5.x ESQL/C to connect to the server. The sqlrm program is not provided with the 9.x servers; it was provided with the 7.2x server. I don't remember whether it is provided with the 7.3x servers. -- Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED]) Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/ #include disclaimer.h
Re: DBIx::AnyDBD
On Thu, 21 Jun 2001 [EMAIL PROTECTED] wrote: Since my last 2 posts prompted absolutely no replies whatsoever my question is simply this: Has anyone implemented DBIx::AnyDBD? I realize that this isn't specifically a DBI question, but the perldoc documentation for DBIx points to this forum. You might try checking on CPAN. (Hint, the answer is yes). search.cpan.org -dave /*== www.urth.org We await the New Sun ==*/
