When I use DBD::Oracle 1.12 with DBI 1.30 (I also saw this on
1.06/1.15) I see two parse_calls for every execute on all selects.
Update/insert/delete just have 1 parse/execute. I have a simple test
script.
#!/usr/local/bin/perl -w
use strict;
use DBI;
my $dbh = DBI-connect(dbi:Oracle:db,
On Wed, October 16 11:51 +0100, Tim Bunce wrote:
Try:
my $sth = $dbh-prepare(SELECT 1 FROM dual, { ora_check_sql = 0 });
Thanks, that did the trick. Thanks also for the detailed explanation
and links.
I believe the parse at execute time is fundamentally an Oracle bug
(and/or isn't a full
, but I wanted to see if anyone else has had the same
issue.
Thanks,
Scott
More info, this error does not occur with DBD::Oracle 1.76.
DBD::Oracle 1.80 => works with 18c client, but fails with 19c.
DBD::Oracle 1.76 => works with all client versions.
On 6/19/20 5:48 PM, Scott wrote:
We have run into an issue when we upgraded to Oracle client 19c. Some
of the
On 6/20/20 1:51 PM, Scott wrote:
More info, this error does not occur with DBD::Oracle 1.76.
DBD::Oracle 1.80 => works with 18c client, but fails with 19c.
DBD::Oracle 1.76 => works with all client versions.
On 6/19/20 5:48 PM, Scott wrote:
We have run into an issue when we up
Here's what doesn't work:
my $dbh=DBI-connect('dbi:ODBC:scottp', 'user', 'pass',
{RaiseError = 1,
AutoCommit = 1}
) || errorhandler("Database connection error: $DBI::errstr");
$sth=$dbh-prepare("SELECT $content_field FROM $content_table WHERE
ata = $sth - fetchrow_array) {
print "@thedata";
}
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 10:59 AM
To: [EMAIL PROTECTED]
Subject: Re: Running a stored procedure
Hi,
Scott Phelps wrote:
I am new to DBI and have
Here's a snippet of my code:
my $dbh = DBI-connect('dbi:ODBC:MYDSN', 'user', 'pass',{RaiseError = 1,
AutoCommit = 1});
$sth = $dbh-prepare
("INSERT INTO ARTICLES (ARTICLE_TYPE, TITLE, SUBJECT, AUTHOR, SOURCE,
SOURCE_URL, COPY, PULLQUOTE) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
$sth-execute
The docs say that those values are for "fetching only", and setting them
seems to have no effect on my insert.
Is there any character limit on an insert?
ScottP
-Original Message-
From: Robert Davis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 12:18 PM
To: Scott
PROTECTED]]
Sent: Thursday, April 12, 2001 1:57 PM
To: [EMAIL PROTECTED]
Subject: RE: Error when inserting large amounts of text (update)
Scott Phelps writes:
I just found the following in an archive (I believe of this list) and it
sounds like my problem exactly (not sure of byte length
Hi all,
I am having great difficulty in getting DBI installed on an AIX 4.3 box.
Basically the Makefile.PL works great, Makefile works fine, but make test
returns a load of No such file or directory errors. from DynaLoader.PM.
Details below - errors in the make test section
Can anyone help
Scott
Pacific Systems Design Technologies
http://www.perldebugged.com
Makefile.PL -g
make
make test
gdb `which perl` core
(gdb) where
(gdb) quit
which perl
perl -V
which perl
sqlplus $ORACLE_USERID
Thanks very much,
Tim Scott
The information transmitted in this electronic mail message may contain
confidential and or privileged materials. For full details and restrictions
It looks like there's some confusion over SQL syntax here. Is there a
database which allows you to effect an insert into a table by doing a
'select ... into ' ?
Oracle certainly doesn't and if Peter's using Oracle then what he suggests
should (and does) work fine. Having said that TIMTOWTDI :)
help me
Pl note : I have installed MySql and it is working ok. Also, i can access
MySql database using DBI:MySql module. I can also log into Oracle database
using scott/tiger@oralin, so this is also ok.
pl. pl. help me
TIA
Denis
Voncent,
You'd be better to setup a tnsnames entry in your Oracle8.1.6 area to point
at your Oracle 7.3.4 database and using this as a connect string.
If you don't do this, you're using Oracle8 function calls from your Perl/DBI
build to try to talk to an Oracle7 database. This is asking for
string (or TWO_TASK) value should be used as the first argument
to DBI-connect.
HTH,
Tim
- Original Message -
From: Vincent Roquencourt [EMAIL PROTECTED]
To: Tim Scott [EMAIL PROTECTED]
Cc: Vincent Roquencourt [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 10:50 AM
Subject: Re
your operation into smaller
queries, or only update one table at a time.
HTH.
Wes
- Original Message -
From: Trevor Webster [EMAIL PROTECTED]
To: Tim Scott [EMAIL PROTECTED]
Sent: Wednesday, May 30, 2001 7:46 AM
Subject: Re: DBI - Access
Tim
I had a similar problem when I first
Some further fiddling found a problem with 'workdate'. I've sorted that, but
it still makes no difference. :((
The values it's passing to '$sth-execute' are:
1531499623, -1516480662, 2001-5-29 00:00:00, 3, May-2001
Help!
Tim
- Original Message -
From: Tim Scott [EMAIL PROTECTED
- Original Message -
From: Tim Scott [EMAIL PROTECTED]
To: DBI Users [EMAIL PROTECTED]
Sent: Wednesday, May 30, 2001 9:43 AM
Subject: Re: DBI - Access
Some further fiddling found a problem with 'workdate'. I've sorted that,
but
it still makes no difference. :((
The values it's passing to '$sth
running DBI 1.18, DBD::Oracle version 1.07 and 8.1.7.
Any help is appreciated.
Anthony Scott
Here is the error messages I get when trying to compile DBI on an SCO
OSR5.0.5 compile of Perl5.005. Does anyone know what I'm missing or how I
can get the DBI module into my Perl install? (Perl and cc info. at end of
message)
Thanks.
Scott.
Output of perl Makefile.PL:
(information
Scott
if I have the following code
sub test {
$dbh =get_dbh;
test1($dbh,$somedata);
close($dbh);
}
sub test1 {
my ($dbh,$data)=@_;
#sql code
}
if the $sql code fails in subroutine test1 does it causes a open process
since I defined $dbh as local?
Anthony Scott
:(
Anthony Scott
Sterin, Ilya wrote:
Not sure what you mean. You are reusing a global handle, if you mean will
there be a memory leak, no since everything is deallocated at end of
execution. Otherwise I am not exactly sure, why you would think that a
different process is created:-?
Ilya
as a
statement handle and therefore the next call to it, will generate a perl
error stating that it can't call a method on an undefined object.
Ilya
-Original Message-
From: Anthony Scott [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 5:49 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL
- install_driver= DBI::dr=HASH(0x8b6cb08)
And then nothing more. When I do a connection before the threading,
There is a huge amount of output. I also don't see the connections
establish with netstat -atn.
Scott
On Mon, 12 Aug 2002 08:06:44 +0100
Tim Bunce [EMAIL PROTECTED] wrote
I got this working finally. I originally grabbed the wrong patch for
DBD::Oracle. The one that I ended up using was at:
http:[EMAIL PROTECTED]/msg01291.html
Thanks for the pointers on where to find what I needed Tim, and thanks
to Gerald Richter for putting the patch together.
Scott
On Fri
but make didn't work and
there were some strange things in the makefile.
Please reply personally.
Scott Smith
NYS Task Force on Reapportionment
_
Surf the Web without missing calls! Get MSN Broadband.
http://resourcecenter.msn.com
() ) {
print row: row\n;
}
### Disconnect from the database
$dbh-disconnect;
exit;
-- end included file query2 --
If anyone can help, I would greatly appreciate it.
Scott
the same script successfully by just
changing the SELECT statement so I am positive that the problem is in the
modules being used somewhere.
Scott
and the speed of it
too!
Scott
, so it won't ever actually run
the code that needs Time::HiRes. Might be worth it to just comment out
the use or that whole section maybe.
5.6.1 in rh7.3 on i686 hardware.
Scott
built for Oracle 7) at ./g
etblob line 23.
###
Thanks,
Scott
#
#! perl -w
use DBI;
# binding parameters to statements.
# binding, placeholders, etc. pseudonames
my $ref = {
PrintError = 0,
RaiseError = 1,
AutoCommit = 0};
my
I am using ActiveState Perl Version v5.6.1 for MSWin32-x86 on my 2000 box.
The dbd was downloaded from active state also.
When I vi the Oracle.pm it says Version = 1.06
I am running the Oracle 8i tools on my PC.
Where should I go from here?
Thanks
Scott
-Original Message-
From: David
select, so it keeps installing 1.06. Any more ideas?
Thanks,
Scott
-Original Message-
From: Sumitro Chowdhury [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 3:32 PM
To: Scott Purcell
Cc: [EMAIL PROTECTED]
Subject: Re: blob error need help
while (my $doc = $sth
:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 3:45 PM
To: Scott Purcell; [EMAIL PROTECTED]
Subject: RE: blob error need help
From: Scott Purcell [EMAIL PROTECTED]
I do not know how to rebuild DBD::Oracle against Oracle 8i libraries
on my 2000 box. I do not think it is possible.
I used
? Or just the usual $SIG{ALRM}/eval
approach?
--
Peter Scott
http://www.perldebugged.com
On Thu, 02 Dec 2004 08:53:38 +0100, Cosimo Streppone
[EMAIL PROTECTED] wrote:
Tim Bunce wrote:
I know what it does, I'm trying to find real examples that demonstrate
why people think it's needed. Nick has provided a good one. Any others?
Something like DBIx::DBH is in use in our
Been working on this for a few days haven't had any luck:
I have read all of the help files searched the internet
I still cannot find out what my problem is.
I am running winxp pro (sp2), vis studio.net, oracle 9i (9.2.0.1)
ActivePerl 5.8., jdk1.5.0
I also ran vcvars32.bat in vis
of fields passed-in and handle boolean values
specially, for instance, in a generic way. We use these and actual
queries to the data dictionary of the given database to make the SQL
writer smart.
Scott Smith
Informatics
Genome Sequencing Center
Washington University School of Medicine
David Dooling wrote
There is an archive of older ActiveState Perl releases at
http://downloads.activestate.com/ActivePerl that includes 5.8.4.
Dan
On Mon, 14 Mar 2005 09:01:24 -0500, Marina Greenstein
[EMAIL PROTECTED] wrote:
Jeff,
Any chance you will update repository with 5.8.6 binaries ? Or please let
anyone help me out?
I just want the info describing the table that I can see in sqlplus.
Mike Scott
QA Software Developer
BBC News Interactive
White City
London
UK
+44 20875 27288
http://www.bbc.co.uk/
This e-mail (and any attachments) is confidential and may contain
personal views which
This is not the mailing list you're looking for. This mailing list is
specifically about using the Perl DBI with the associated database
drivers (for example, the DBD::DB2 driver, as documented at
http://ibm.com/db2/perl/).
If you want help calling Java applications from a shell script, you
would
For the DSN-less connections, see http://www.connectionstrings.com --
great resource.
Dan
On 6/2/05, Martin J. Evans [EMAIL PROTECTED] wrote:
Sharon,
The string after ODBC: is usually a DSN name as in:
DBI-connect(dbi:ODBC:mydsn,...)
or
DBI-connect(dbi:ODBC:DSN=mydsn)
where mydsn
Chris:
This sounds very much like the problem noted under Hints at
http://www-306.ibm.com/software/data/db2/perl/:
Having trouble running perl with DB2 UDB Version 8 64-bit for AIX
5.2? Check out this technote.
On 7/19/05, Keith Jackson [EMAIL PROTECTED] wrote:
I have a project that I need to connect to a DB2 database on an AS400
from a perl application on a Linux box. I've been reading as much as I
can but have a few questions for those with experience in a similar
task.
My options appear to be
Tim Bunce wrote:
On Fri, Sep 02, 2005 at 05:37:57PM -0500, johnn wrote:
Capacio, Paula J wrote:
my $stmt = 'select count(*) from sysibm.badTblnm ';
my $sth = $dbh-prepare($stmt) or die Prepare Failed\n;
DBD::DB2 doesn't seem to return false values for failures.
If that's true then
Alec Brecher wrote:
My DBD-DB2 installation on Fedora Core 3 is failing because it cannot
find libdb2.so.1.
The Application Dev client is installed and works fine. The
DB2_HOME=/home/db2inst1/sqllib
I saw some post from Owen Berry on another list regarding this issue.
His fix: add
Dan Scott wrote:
Alec Brecher wrote:
My DBD-DB2 installation on Fedora Core 3 is failing because it cannot
find libdb2.so.1.
The Application Dev client is installed and works fine. The
DB2_HOME=/home/db2inst1/sqllib
I saw some post from Owen Berry on another list regarding this issue.
His
[EMAIL PROTECTED] wrote:
Hello,
I'm now using Perl 5.005, DBI-1.15, DBD-DB2-0.75 on AIX 4.3.
And like to upgrade them to Perl 5.8, DBI-1.48, DBD-DB2-0.78.
Installation may be ok, but when I INSERT double bytes characters,
I get the following error.
[IBM][CLI Driver] CLI0109E String data
If you're willing to upgrade to Perl 5.8.x, then you can use the
latest available version of DBD-DB2 from
http://ftp.esoftmatic.com/DBI/ (it's okay to install the 5.8.4 version
of DBD-DB2 on Perl 5.8.7).
Dan
On 10/7/05, Trent Ohannessian [EMAIL PROTECTED] wrote:
Hello,
I currently have Perl
DBD::DB2 (http://search.cpan.org/dist/DBD-DB2/DB2.pod) supports
bind_param_inout,
but it would require you to use the DB2 Connect Personal Edition or DB2 Connect
Unlimited for iSeries to access iSeries from your Linux, UNIX, or Windows box.
Dan
On 10/12/05, Stephen More [EMAIL PROTECTED] wrote:
Hi Darren:
I think an update about the recommended minimum database version
levels for your access modules is on-topic for this mailing list, but
suspect that product advertisements are probably off-topic -- personal
opinion, maybe, but I don't want to see this list become a dumping
ground for
Strange -- just tried the exact same commands here and they worked as
expected. Maybe there was a temporary FTP server glitch.
Are you able to see the ftp.esoftmatic.com site?
Dan
On 11/3/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello.
I just installed perl 5.8.7 from active state. (I
On 11/16/05, Rob Craig [EMAIL PROTECTED] wrote:
I am using DBD::mysql and I can get the number of rows by assigning the
result of the execute to a scalar:
my $rows = $sth-execute or die Couldn't execute statement: .
DBI-errstr;
maybe this doesn't work with DBD::Oracle?
Rob
When you
Hi Vincent:
You just need to install the DB2 development headers and libraries
(available with the free to download and use DB2 Application
Development Client) on your Linux box and set DB2_HOME before
compiling DBD::DB2; that will enable you to connect from your Linux
box to a DB2 server running
on
windows box or?
Thanks in advance
On 1/5/06, Dan Scott [EMAIL PROTECTED] wrote:
Hi Vincent:
You just need to install the DB2 development headers and libraries
(available with the free to download and use DB2 Application
Development Client) on your Linux box and set DB2_HOME before
Seems to be working now for me: http://ftp.esoftmatic.com/outgoing/DBI/
Dan
On 31-Jan-2006 10:09:34 CET, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Hello,
I need DBI and DBD-DB2 packages for Activeperl, but esoftmatic server is
unreachable.
Can anybody help me with this problem or send me
This is a nice thought, but the latest release of DBD::DB2 is actually
0.78 (released a long time ago), but ActiveState wasn't interested in
updating their version of the package because DBD::DB2 prereqs the DB2
Runtime Client.
Apparently ActiveState has made it a policy to avoid offering
Hi Martin:
You'll need the Application Development Client, which is a free
download from http://ibm.com/db2/udb/support/downloadv8.html.
The clients are installed as RPMs on Linux using the db2setup program
(part of the client); you might want to check out the DB2 HOWTO
WAG here: will the DBD::DB2 driver implicitly finish the resources if
you try calling $sth-fetchrow_array() again?
I don't know if DBD::DB2 can know whether there are more rows left in
the result set until you try fetching the next row, ergo it keeps the
statement handle active.
Dan
On
On 24/06/06, Jonathan Leffler [EMAIL PROTECTED] wrote:
On 6/23/06, [EMAIL PROTECTED] [EMAIL PROTECTED]
wrote:
snip
If you have a pre-compiled module, then I think your problem is the absence
of DB2 Connect (IIRC) or its equivalent.
snip
The basic connectivity requirement for DBD::DB2 on
How can I list all of the table names in an access database?
Thanks,
Scott Berthold
general shell
session. i.e.
LD_PRELOAD=/usr/lib/special_old_library.so /usr/bin/oldprogram
Scott Smith
Genome Sequencing Center
with this morning off-perl question.
Thanks you very much,
Scott Purcell
[12]','$columns[13]','$columns[14]','$columns[15]',
'$columns[16]','$columns[17]','$columns[18]','$columns[19]',
'$columns[20]'])
}
]
)
);
--
Scott Taylor
Systems Administrator
DCT Chambers Trucking Ltd.
, W2K) for over 2 years.
- Scott
Scott Scecina
In Mind, Inc.
that part, just in case someone has some insight on that.
TIA
Scott
using Activestate Perl 5.6.1 build 626 on Win2k with the latest
MSSQLReporter (1.00) from Activestate's PPM repository against a MS-SQL 7.0
database.
Thanks in advance for any help,
Scott Phelps
[EMAIL PROTECTED]
Webkorner Internet Services
---
[ This E-mail scanned for viruses
There are a number of cpan tools that will do that - you just basically need
anything that will do julian or other time format conversion. I have seen
others use Time::Calc and I tend to prefer Time::Manip.
Scott
--- Charitha [EMAIL PROTECTED] wrote:
Hello all,
Can i find
marks or shell
metacharacters).
--
Peter Scott
Pacific Systems Design Technologies
http://www.perldebugged.com
?) Is there a better solution,
or can someone point me in the correct direction for oci8.c?
I've included a test program that duplicates this problem
in case there's something I'm overlooking.
Thanks.
-- Scott
# Connect, with LongTruncOK set to 0, LongReadLen to 50.
my($sth) = $dbh-prepare( SELECT
since your set trans..
statement with each query, and might result in a snapshot too old error.
I don't know if/how other databases implement this feature, and give it
such a possibly misleading name. Does anyone else?
Scott Smith
Tim Bunce wrote:
I've just added this to the DBI docs
Tim Bunce wrote:
On Fri, May 04, 2007 at 08:15:53AM -0500, Scott Smith wrote:
Doing set transaction read only on Oracle has additional side-effects
besides making the connection unable to write: it switches the read
consistency level from per-statement (the default) to per-transaction
On Thu, 07 Jun 2007 08:47:00 +0200, Dr.Ruud wrote:
Peter Scott schreef:
Is there a simple way to create a new table with the same structure
as a given one in a *different* database? That means the CREATE
TABLE foo AS SELECT * FROM bar WHERE 1=2 method won't work.
I'd need to have two
?
$ ./perl -wle '$q = shift; sub foo { my $x if $q; print $x // $]; \
$x = 42 } foo; $q++; foo' 0
5.009005
42
It looks like it, no?
--
Peter Scott
I'm having trouble building the DBD-ODBC driver on our HPUX server.
Below is the log of me running:
make realclean
perl Makefile.PL
make
Note: unixODBC is version 2.2.12 that I just built today. I have
successfully created a connection with isql.
recall talking to someone about perl having an internal database file
where you could store the data in a file, and access it relatively easily,
without having to set up an interface to an external database server.
Or am I completely wrong, and there isn't such a thing?
Scott Mohnkern
://souptonuts.sourceforge.net/readme_sqlite_tutorial.html
But it kind of lost me.
Scott Mohnkern
on the module.
On Thu, Jun 5, 2008 at 10:44 AM, Jonathan Leffler
[EMAIL PROTECTED] wrote:
On Thu, Jun 5, 2008 at 12:54 AM, Scott Ryan [EMAIL PROTECTED] wrote:
Hi I am struggling to build the DBD-Oracle module on mandriva 2008.1.
It uses perl 5.10.0 and I get the following:
[EMAIL PROTECTED
Oracle's execute immediate to effectively eval the SQL there..
Scott
Dale wrote:
On Tue, Feb 3, 2009 at 8:47 AM, Deviloper devilo...@slived.net wrote:
Hello there!
lets assume that one has a list of tables @db_tables. (For Example one per
Month)
Lets assume one wants to find some data
,
Scott
Brian H. Oak wrote:
I *think* this used to work, but recently stopped working. I have a program
that is designed to work on MS SQL Server. My program prepares an array of
statement handle references by repeatedly interpolating several scalar
variables with placeholders:
for ( 0
255
Thanks for any insight...
Best regards,
Scott...
sys + 0.27
cusr 2.17 csys = 2.72 CPU)
Result: FAIL
Failed 1/21 test programs. 1/445 subtests failed.
make: *** [test_dynamic] Error 255
As always, thanks!
Best regards,
Scott...
Yes.
Thank you again.
Best regards,
Scott...
On Jun 30, 2009, at 11:52 AM, Martin Evans wrote:
Scott Stansbury wrote:
Getting closer :)
I'm trying to connect to a SQL Server 2008 instance from a CentOS5
box:
unixODBC: 2.2.14
FreeTDS:0.82
Easysoft: odbc-sqlserver-1.1.26-linux
,
Scott
Scott Saccone, Ph.D.
Department of Psychiatry, Box 8134
Washington University School of Medicine
660 South Euclid Avenue
Saint Louis, Missouri 63110-1093
Voice: (314) 286-2581
FAX: (314) 286-2577
Email: ssacc...@wustl.edumailto:ssacc...@wustl.edu
? print DBI::errstr=$DBI::errstr\n : print DBI::errstr
is not defined\n;
print Goodbye\n;
exit 0;
OUTPUT:
Successful do operation: INSERT INTO people VALUES (Bob,abc);
DBI::errstr is not defined
Goodbye
--
Scott
-Original Message-
From: David Goodman [mailto:dtzgd...@yahoo.com]
Sent
you created.
(Full disclosure: I wrote the RMI modules. If they break for you please
email me.)
Scott
jeff wrote:
You make an incorrect assumption :-(
Not trying to fool anyone or hide my identity, just hoping for further
input.
If you don't want to answer, then don't
Great. Glad it works for you!
jeff wrote:
Thank you, Scott !
In case anyone else needs this sort of setup: I wanted to share this
quick dirty successful test using Scott's RMI to connect to both
oracle 10 with a wallet and oracle 8 with external authentication - no
user names or passwords
=(CONNECT_DATA=(SERVICE_NAME=edc-dbserver.nais.org))(ADDRESS
=(PROTOCOL=TCP)(HOST=10.166.135.110)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(
HOST=10.166.135.112)(PORT=1521)))
OK (0 msec)
Any help would be greatly appreciated.
E. Scott Stricker
Senior Software Engineer
Northrop Grumman - Information Systems
to XYZ-2 XYZ-10 (edc-dbserver) box
E. Scott Stricker
Senior Software Engineer
Northrop Grumman - Information Systems - C2SD
MailStop 4S02
2340 Dulles Corner Blvd.
Herndon, VA 20171
703-561-3671
703-713-1601 (fax)
From: John Scoles [mailto:byter...@hotmail.com]
Sent: Thursday, April 29, 2010
.
E. Scott Stricker
Senior Software Engineer
Northrop Grumman - Information Systems - C2SD
MailStop 4S02
2340 Dulles Corner Blvd.
Herndon, VA 20171
703-561-3671
703-713-1601 (fax)
-Original Message-
From: Stricker, Scott (IS) [mailto:scott.stric...@ngc.com]
Sent
be incorporated into the DBD::Oracle driver?
Many thanks,
Scott
in .03 seconds. The delays were intermittent but looked like it was
hung.
Just a thought for you to try.
-Scott
On Tue, 7 Oct 2003 [EMAIL PROTECTED]
wrote:
Hi,
wie got a very strange problem here on insertion/update of rows into an
MS-ACCESS 97 DB which gives us a lot of headache
state.
Can anyone give me a hint?
Thanks,
Scott
that don't want to talk SQL. Hence, calling it a SyntaxModel is
somewhat archaic.
Given this, perhaps DBIx::Mechanize would be more appropriate. YMMV.
--
Peter Scott
Pacific Systems Design Technologies
http://www.perldebugged.com/
*** New! *** http://www.perlmedic.com/
ricardo Guerra Flores wrote:
Hi all...
i'm having some problems trying to run a script that uses DBD::DB2 inside
mod_perl and the Apache::DBI module, the program runs right when i execute
it as a stand alone perl program. I've already set the ENV for db2home,
db2instance, etc. in startup.pl
This
Ben:
DB2 automatically takes the user ID you logged in with and uses that
as your default schema.
You can issue the SET SCHEMA statement to change your default schema
if you want it to be different from your DSN user ID. For example SET
SCHEMA rick would automatically prepend 'rick.' to all of
On Mon, 8 Nov 2004 15:17:34 +0100, Miroslav Lau [EMAIL PROTECTED] wrote:
Hi all!
I'm using DBD::DB2 to access remote DB2 database on an AS400 machine. I've
managed it to work from command line.
But when trying to connect to remote database from a mod_perl application the
$DBI::errstr is
1 - 100 of 375 matches
Mail list logo