You need an ODBC manager with the freetds driver. I suggest unixODBC.
One issue you may run into is that when a query fails to prepare, you
may only receive a prepare failed... message without additional
information as to why it failed. Also, I've had problems with place
holders not
Mark Vaughan wrote:
Amonotod,
Yes, that helped tremendously.
Now I've moved on to the next problem.
I installed unixODBC and the tsql command worked (no errors), although
it replied with a 1 prompt and didn't seem to do anything unless I
typed 'quit', in which case it did just that.
I was able to
That's hasn't
From: Thomas A. Lowery [EMAIL PROTECTED]
And the maintainer has made any time to provide any updates or new features.
Tom
I'm interested in seeing this application. We may want to discuss
creating a plug-in to work with DBI::Shell.
On Fri, Jan 23, 2004 at 03:11:12PM -0500, Eric Lenio wrote:
Currently I am re-writing the app from the ground up as I have learned quite a
bit more about DBI and Curses in the past 8
On Tue, Jan 13, 2004 at 10:13:44AM -0800, Randal L. Schwartz wrote:
Tim == Tim Bunce [EMAIL PROTECTED] writes:
Tim On Mon, Jan 12, 2004 at 04:00:28PM -0800, Randal L. Schwartz wrote:
Is there any way to enter a / that's part of the SQL,
and not taken as a delimiter?
I'm staring at
We've been reviewing ADS at work. Other than it's not open source, the
product is solid and provides very useful features. We're considering
the purchase of a few commercial licenses.
Tom
On Tue, Nov 11, 2003 at 02:14:11PM +, Tim Bunce wrote:
http://www.aquafold.com/
Aqua Data
Thanks. This problem seems to have re-appeared with perl 5.8.0.
If anyone has a suggestion and/or solution please let me know.
Tom
On Mon, Nov 10, 2003 at 02:39:32PM -0500, Scott R. Godin wrote:
...
PERL_DL_NONLAZY=1 /usr/bin/perl -MExtUtils::Command::MM -e
test_harness(0, 'blib/lib',
On Wed, Oct 22, 2003 at 02:28:52PM -0500, Kuang, Jeff - Raleigh, NC wrote:
OS: NT4 SP6
$dbh = DBI-connect('$dns','$user_name','$password') or die Didn't make
it\n$DBI::errstr\n;
The single quotes cause the variable to be seen as literal. So instead
using of the value of $dns to establish
On Wed, Oct 22, 2003 at 03:04:18PM -0500, Kuang, Jeff - Raleigh, NC wrote:
I already tried both. The variables, $dns, $user_name, and $password,
are just to show you what I put in my code. They are not actually used.
What do you use for dns then?
When I ran the following codes,
On Wed, Oct 22, 2003 at 01:19:09PM -0700, A L wrote:
#!/usr/bin/perl
use DBI;
...
if ($date ne $update){
#update the table1
my $update_table1=$dbh1-prepare(qq{UPDATE table1
SET name=?,desc=?,type=?,update=?,count=?
On Fri, Oct 17, 2003 at 04:22:24PM +0100, Simon Taylor wrote:
I am trying to create a module that sets ups environment variables from
another module, creates a database handle and passes it back to the calling
script.
I understand that an object exists as long as there is a reference to it but
Ron,
Are you looking for something that does this for you?
Take a look at DBIx::AnyDBD. IIRC, DBI was scheduled to merge
the DBIx::AnyDBD functionality to allow easier subclasses.
Tom
On Tue, Sep 30, 2003 at 08:15:26PM +1000, Ron Savage wrote:
Hi Folks
I've been
As long as RaiseError is turned OFF ($dbh-{RaiseError} = 0),
you may trap the errors without evals. The error message will change
based on the database.
PostgreSQL Example:
#!/usr/bin/perl -w
#
#
use strict;
use warnings;
use DBI;
my $dbh = DBI-connect() or die $DBI::errstr;
# To trap
Could someone please post a simple Perl code snip example of a rollback
Important to remember that the database has to support transaction.
#!/usr/local/bin/perl -w
use strict;
use warnings;
use DBI;
# Connect, disable AutoCommit for transaction control.
my $dbh = DBI-connect( dbi:Oracle:,
Jeff,
Have you posted the errors (didn't find anything searching mail
for this month)?
Give us the output of perl -V and the results of make.
Tom
On Tue, Sep 16, 2003 at 09:58:31AM -0500, McDonald, Jeffrey wrote:
I have also been unable to use or rebuild the DBD(version
It would appear that you didn't actually install the newer version of
DBI. Possibly just copied the DBI.pm and/or have PERL5LIB/-I/use lib
pointing to the newer version.
To use the newer version do a
cd /place/you/have/dbi/source perl Makefile.PL make make test install
I recommend using
cd
try ppm install DBI
On Wed, Sep 13, 2000 at 11:24:37AM +0500, Farhan wrote:
hello.
Which DBI module will work with my perl.. Version is.. perl, v5.8.0 built for
MSWin32-x86-multi-thread. i'm on win2000. i'm asking this because when i try to
install the DBI.ppd which i have the eror
Looks like gcc isn't in your path, also did you read README.hpux?
Warning: If you have trouble, see README.hpux...
you may have to build your own perl, or go hunting for libraries
Please CC the dbi-users list (reply-all).
On Wed, Sep 03, 2003 at 08:51:43AM +, mustapha zaakoun wrote:
the
use Data::Dumper;
Quoting Thomas A. Lowery [EMAIL PROTECTED]:
On Mon, Sep 01, 2003 at 09:38:04PM +0300, [EMAIL PROTECTED] wrote:
The case of the column is correct.
This does work when i use $results=$sth-fetchrow_arrayref;
only $results=$sth-fetchrow_hashref has the problem
Two things, use [EMAIL PROTECTED] for support instead of writing Tim
directly.
Second:
The ORACLE_HOME environment variable must be set.
It must be set to hold the path to an Oracle installation directory
on this machine (or a machine with a compatible architecture).
See
On Mon, Sep 01, 2003 at 09:04:11PM +0300, [EMAIL PROTECTED] wrote:
I have a simple query
--
$sth=$dbh-prepare(SELECT column FROM table WHERE columnid=1);
Is there data in table table for columnid 1?
$sth-execute();
$results=$sth-fetchrow_hashref;
print
On Fri, Aug 29, 2003 at 12:16:35PM -0500, Peter Fleck wrote:
We seem to get an attempt to connect to the database but then this error:
Database connection not made: OR
A-06401: NETCMN: invalid driver designator (DBD ERROR:
OCIServerAttach) at /var/www/cgi-bin/pftester.cgi line 27. at
On Tue, Aug 26, 2003 at 09:33:58AM -0700, Jeff Zucker wrote:
Thomas A. Lowery wrote:
know if you have other ideas that wouldn't break existing scripts.
What was I thinking ... break every CSV process in the world using
DBD::CSV. sigh
DBD::CSV expects by default. You need to either add
Attachments didn't make it.
On Thu, Aug 28, 2003 at 03:40:35PM +0400, Dmitriy Kovalev wrote:
Hi,
I got problems with installing DBD::Oracle-1.14
I've attached 2 listings with: 'perl Makefile.PL' 'make' commands I
did
Probably, you'll suggest me something.
Thank you.
Dmitriy Kovalev
Larry,
Including a snip or two of code helps.
An example of a connection:
If using sqlplus you do: sqlplus scott/[EMAIL PROTECTED]
then for dbi you do:
my $dbh = DBI-connect( q{dbi:Oracle:db}, q{scott}, q{tiger},
{RaiseError = 1} ) or die Unable to connect $DBI::errstr\n;
On Mon, Aug 25, 2003 at 04:40:07PM +0530, Parmod Chander Goyal wrote:
Further debugging with
USE DBI;
USE DBD::ORACLE;
Does not including the use DBD::ORACLE cause the same error?
(which other most circumstances isn't needed. Also if it is needed it's
use DBD::Oracle ... case sensitive)
Jeff,
I'm adding more support for csv in DBI::Shell. However, I'm
seeing some odd results.
If I use this connection string and query. 0 Rows are fetched.
(some code removed for brevity)
my $dbh = DBI-connect(DBI:CSV:f_dir=.)
...
my $sth = $dbh-prepare(select
On Mon, Aug 25, 2003 at 09:30:44PM +0100, Tim Bunce wrote:
I installed DBD::Oracle 1.14 and DBI 1.37, but
I receive the following warning in test.pl:
Is this a bug ??
my $dbh = DBI-connect('dbi:Oracle:',
shift||'',
shift||'',
'Oracle',
Remove the extra string
On Sun, Aug 24, 2003 at 09:34:57PM +0530, Parmod Chander Goyal wrote:
My perl script looks like
use DBI;
my $dbh = DBI-connect('dbi:Oracle:prod', 'user', 'password');
DBI is not returining any value here, I have also tried to use RaiseError
but to no use.
Add this after
OK, tests fixed, new version is available.
http://stlowery.net/DBD-ADO-2.7.tar.gz
On Sun, Aug 24, 2003 at 01:53:25AM +0530, Parmod Chander Goyal wrote:
I am new to perl and facing a problem in existing setup.
My perl executable .pl file is not giving any error. I have debugged it and
found that @dbh=DBI-connect() is not working (these were working for last 1
year).
DBD::ADO Release 2.7 is available from http://stlowery.net/DBD-ADO-2.7.tar.gz
As soon as I can connect with PAUSE, I'll upload for release on CPAN.
Changes Version 2.7: Thu Aug 21 23:10:50 EDT 2003
Bug fix from Yimin Zheng regarding undef/null values passed as
parameters to
On Thu, Jul 31, 2003 at 06:22:34PM -0400, Ed Patterson wrote:
I receive the above error when attempting to execute the code below. I have
installed DB_File and out of desperation Tie-DB_File-SplitHash.
Am I missing a module or is my typing really that bad?
From page 33 of _the_ book
Do we need to re-register to contribute?
On Tue, Jul 22, 2003 at 03:02:08AM -0400, Ilya Sterin wrote:
In the midst of learning Combust (the new perl.org development
framework), so that I can get the dbi.perl.org site up and running
fairly quickly, I took an evening to set up the DBI FAQ, that
On Wed, Jul 16, 2003 at 09:07:39PM -0700, Michael Kovalcik wrote:
i have a postgresql database created with over 20,000
rows. i'm trying to pull all the information via dbi
and it always stops at 268 rows (it works great for
the information it does send). is there a load issue
with the way
Not sure if this is a better idea or faster, but
I'd look into using rand() function and limit ... (not tested)
select X from Y where int(rand()*5) = 1 limit 1
On Wed, Jul 02, 2003 at 07:32:13PM +0400, ??? ?? wrote:
Hello.
I have big table (50 000 records, 100 Mb), and want to
)?
ie. Should I use DBD::Pg 1.13 if I don't use PostgreSQL7.3?
--
Thomas A. Lowery
See DBI/FAQ http://www.xmlproj.com/cgi/fom.cgi
://tlowery.hypermart.net/faq_examples/information_about_ado_and_dsn.htm
$sql=q{insert into tracking (lstord,time_stamp)values(?,?)};
$sth=$db-prepare($sql);
$sth-execute($lstord,$time_stamp) or die Cannot execute:
$DBI::errstr\n;
Tom
--
Thomas A. Lowery
See DBI/FAQ http://www.xmlproj.com/cgi
).
Tom
On Tue, Dec 17, 2002 at 02:16:04PM +0100, [EMAIL PROTECTED] wrote:
this is a bit offtopic: I don't want to run to the server each time I want
to check contents of some table: Is there a sqlconsole where I can just
connect to the server via ODBC and do some SQL statements?
--
Thomas
version tonight.
Tom
--
Thomas A. Lowery
See DBI/FAQ http://www.xmlproj.com/cgi/fom.cgi
other.
I've fixed your Shell.pm for 1, but no for 2 and I'm asking if you are
planning to make a new release with something like this.
Patches are welcomed!
Thomas
--
Thomas A. Lowery
See DBI/FAQ http://www.xmlproj.com/cgi/fom.cgi
of accessing databases uses the
Win32::ODBC module instead of DBI.
--
Thomas A. Lowery
See DBI/FAQ http://www.xmlproj.com/cgi/fom.cgi
the table names?
Thanks in advance.
Brad Smith
--
Thomas A. Lowery
See DBI/FAQ http://www.xmlproj.com/cgi/fom.cgi
['a']
always test your code using perl -w, in fact the first few lines of every perl
scripts should be
#!perl -w
use warnings;
use strict;
--
Thomas A. Lowery
See DBI/FAQ http://www.xmlproj.com/cgi/fom.cgi
.
--
Thomas A. Lowery
See DBI/FAQ http://www.xmlproj.com/cgi/fom.cgi
See FAQ:
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
On Sun, Dec 01, 2002 at 12:01:50PM -0600, Mike(mickako)Blezien wrote:
I'm sure this must have been discussed many time in the past, but I just
need to get some refresher information or directions. I believe data can be
--
Thomas
entered by: TLOWERY (Thomas A. Lowery)
Request entered on: Sun, 10 Nov 2002 14:04:20 GMT
Request completed: Sun, 10 Nov 2002 14:06:07 GMT
Virtually Yours,
Id: paused,v 1.81 2002/08/02 11:34:24 k Exp k
version today.
Thanks,
Tom
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
with LYCOS MAIL PLUS.
http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
/\\$prefix/$prefix/g;
+$sh-{current_buffer} .= $stmt\n;
+}
$cmd = 'go' if $cmd eq '';
my args = split ' ', $args_string||'';
--
Thomas A. Lowery
On Mon, Oct 14, 2002 at 01:57:28PM +0200, Roger Perttu wrote:
Thomas A. Lowery wrote:
However nothing(!) seem to work for me with DBD-ADO (Using MS SQL 7.0
MDAC 2.7 DBI 1.30 Activeperl 631):
my $dbh = newDbh();
Of course my set-up is different, I just tested a remote connect to my local
Ilya,
Would you make a PPM from the current version DBD-ADO and add it to the
standard site please?
Tom
On Tue, Oct 08, 2002 at 02:01:59PM -0600, Sterin, Ilya wrote:
That's fine, we can do that:-)
that I know of.
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
::SQL_UNKNOWN_TYPE not allowed while strict subs in use at
D:/Perl/site/lib/DBD/ADO.pm line 213.
BEGIN not safe after errors--compilation aborted at D:/Perl/site/lib/DBD/ADO.pm line
462.
Compilation failed in require at (eval 1) line 3.
How do I fix this?
--
Thomas A. Lowery
See DBI/FAQ http
alternate way of finding out column widths
using DBI (or SQL perhaps)?
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
idea why and how the load time can be improved? The current
delay is causing a lot of complaints from users of a program which
uses the above.
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
DBD::ADO or DBD::ODBC or DBD::Sybase
On Tue, Jul 09, 2002 at 10:29:56AM -0400, Mark Nadel wrote:
What is the currently recommended way to connect from Perl to a Microsoft
SQL Server?
Thanks,
Mark Nadel
U. S. Genomics
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin
install dbiproxy on Win2000. I'm running Activate State
Perl and I'm not familiar with the Activate State environment on
Windows; I'm more of a perl -MCPAN -e 'install something' type
person. Please advise.
Tom
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
suggestions are greatly
appreciated. Thanks.
Nick Hendler
[EMAIL PROTECTED]
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
work.
Tom
On Sat, Jun 15, 2002 at 03:00:29PM -0700, Douglas Wilson wrote:
From: Thomas A. Lowery [EMAIL PROTECTED]
Would you make a ppd of the current DBD::ADO (2.5) and post it to
your site please? The DBD::ADO does not appear to be available
from ActiveState.
I was wondering about
it was a number and didnt quote it (i used bind values)
is this a bug or a feature ??
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
Ignore them, known failures. I believe Jeff is working on them.
Tom
On Mon, Jun 10, 2002 at 08:23:00AM -0600, Greg Davis wrote:
t/04execute.FAILED tests 5-7
Failed 3/10 tests, 70.00% okay
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
and CREAT_DB are not interpolated.
What's passed to the function is DSN=$dsn not DSN=Test_DSN.
Tom
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
to connect to remote without using
tnsnames.ora?
Thanks,
Roger Patrick.
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
message about not able to find DBI ...
Also:
perl -MDBI -e print $DBI::VERSION;
Gives the currently installed version.
Tom
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
, these are the latest available versions.
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
of as a
reality check.
Removing the my's from the mysql bindings , or reversing the order of
the bind_params
has no effect on bindings to postgreSQL.
On Sunday, June 9, 2002, at 07:49 PM, Thomas A. Lowery wrote:
Bill,
Reverse the order of the bind_params and see if it fails on mysql
Ilya,
Would you make a ppd of the current DBD::ADO (2.5) and post it to
your site please? The DBD::ADO does not appear to be available
from ActiveState.
Tom
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
: 2c85f225cb4dfa335775a32a29ec024f
No action is required on your part
Request entered by: TLOWERY (Thomas A. Lowery)
Request entered on: Thu, 06 Jun 2002 02:11:02 GMT
Request completed: Thu, 06 Jun 2002 02:12:13 GMT
Virtually Yours,
Id: paused,v 1.80 2002/03/10 06:40
on
track:\n . $sth-errstr;
}
close A;
print \nfinished\n;
close STDERR;
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
;
push $result,
{ NAME= $col_name,
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
*** Pg.pm.orig Fri May 31 22:11:21 2002
--- Pg.pm Tue Jun 4 20:23:58 2002
***
*** 11,17
require 5.004;
! $DBD::Pg::VERSION = '1.13
error or a bug in DBI?
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
= '' unless $constraint;
# Check to see if this is the primary key
! my $is_primary_key = scalar(grep { /^$col_name$/i } $pri_key) ? 1 : 0;
push $result,
{ NAME= $col_name,
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org
all of those capabilities available
as pure Perl.
This is the goal ... I'm not sure if I have all the SQL*Plus options.
Tom
On Wednesday 17 April 2002 17:54, Thomas A. Lowery wrote:
Well, it's not officially released, but there is a module with
DBI::Shell called DBI::Shell::SQLMinus
Around line 187 in the DBD::ADO driver is this line:
my $name = Microsoft ActiveX Data Objects 2\\.\\d+ Library
I'd attempt to change this to 1.0 or 1.5 instead of 2\\.\\d+
see if that solves the problem. You'll find the ADO.pm in the site
directory. Use find file to locate it. You may have
I'm in the process of moving to a house, so I'm not available to review/fix
the problem with DBD::ADO for a week or so.
Tom
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
is undefs. Does this not work right under DBD::Pg?
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
retrieve second?
Thanks.
Vasily Popov.
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
be emailed or sent to a
printer.
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
is the err code. ONE time I did get the right
string, but for the life of me, I can't figure out why I
can not get now.
Any ideas?
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
On Mon, Apr 15, 2002 at 08:28:24PM -0500, GB Clark wrote:
On Mon, 15 Apr 2002 19:10:22 -0400
Thomas A. Lowery [EMAIL PROTECTED] wrote:
snip
On Mon, Apr 15, 2002 at 04:18:08AM -0500, GB Clark wrote:
Any time I call errstr either as a method or variable
all I get is the err code. ONE
--no output ever seen
make: *** [test_dynamic] Error 29
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
it doesnt seem to
be right
--
Thomas A. Lowery
Hello Ian,
Replace /usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI/Format.pm
with the attached file.
Hopefully I can get a newer release of dbish done soon.
Tom
On Mon, Apr 08, 2002 at 09:40:16AM -0600, Ian Harisay wrote:
I guess that would be DBD::Oracle 1.12 not 1.21.
) {
...
}
}
With bind columns and placeholders, it's not as clunky. It's not
fast, but will do what you want.
Again, depending on the requirements and table sizes, you could do the
above once adding the rows to a flatten table stored in one databases.
Tom
--
Thomas A. Lowery
--
Thomas A. Lowery
.
Hopefully, time permitting, I can contribute to the FAQ effort.
Tom
On Tue, Mar 19, 2002 at 01:26:55PM -0700, Sterin, Ilya wrote:
Another update to the FAQ proposals list.
http://xmlproj.dyndns.org/dbi/faq.html
Ilya
--
Thomas A. Lowery
password, if the offer is still open.
wish, upload, etc... Up to you, even if you just need some extra server
space, I'll be glad to provide it.
Thanks for the help.
Ilya
-Original Message-
From: Thomas A. Lowery [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 24, 2002 8:19 PM
where CategoryId=?': -2147217904: OLE exception from Microsoft OLE DB
Provider for ODBC Drivers:
[Microsoft][ODBC SQL Server Driver]Champ COUNT incorrect
Win32::OLE(0.1502) error 0x80040e10
in METHOD/PROPERTYGET Execute
-2147217904: at tmp.pl line 11.
Thanks
--
Thomas
the script to bail out on
an error?
Oravle system tables.
table tha
--
Thomas A. Lowery
See DBI/FAQ http://tlowery.hypermart.net
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Hello Mark,
No, it didn't make it into the code yet. Next release. (Hopefully
a new release over the weekend.)
Thanks for the reminder!
Tom
On Thu, Dec 06, 2001 at 08:24:23AM +, Mark Smucker wrote:
Hi,
I was wondering if the proposed change for commandtimeout
This is too off topic.
Tom
--
Thomas A. Lowery
See DBI/FAQ http://tlowery.hypermart.net
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
, Dan Horne wrote:
I know the definitions, syntax are in the doco, but can someone send me some
concrete examples of type_info being used?
--
Thomas A. Lowery
See DBI/FAQ http://tlowery.hypermart.net
_
Do You Yahoo!?
Get your free
-fetchrow_array()) {
print OUT @row\n;
}
Tom
--
Thomas A. Lowery
See DBI/FAQ http://tlowery.hypermart.net
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
ConnectTimeout and CommandTimeout.
Tom
On Thu, Oct 25, 2001 at 06:06:30PM +0200, Konstantin Berman wrote:
How to set timeout unlimited in DBD::ADO connection?
Thanks in advance
--
Thomas A. Lowery
See DBI/FAQ http://tlowery.hypermart.net
($x = $sel-fetchrow)
{
print .;
}
$sel-finish;
$dbh-disconnect;
---
After about 21.5 million entries read, the Memory-Usage for the process
exceeds the 1GB-Limit (defined at the machine) and the process is killed
with Out of memory.
Any help ?
--
Thomas A. Lowery
See
--
Thomas A. Lowery
See DBI/FAQ http://tlowery.hypermart.net
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
:
$ado_consts-{adVarWNumeric}= undef
If I comment it out warning disappears... I've checked ADO documentation -
there is no such type as adVarWNumeric. Where is the problem?
--
Thomas A. Lowery
See DBI/FAQ http://tlowery.hypermart.net
I've CC'd the dbi-users mail list. The list contains many people who
are much more knowledgeable that myself in SQL Server and ADO.
On Mon, Oct 08, 2001 at 07:27:37PM +0200, Djordje Djokic wrote:
I know that it is not a common thing and that you have tones of
questions like this, but since I
1 - 100 of 136 matches
Mail list logo
