On 02/11/15 09:56, Ismail Chamseddine wrote:
I did and it didn't work. for more information, the error message is the
following:
failed: [Microsoft][ODBC driver manager] data source name not found and no
default driver specified (SQL - IM002) at line..
Then what drivers are listed in
I did and it didn't work. for more information, the error message is the
following:
failed: [Microsoft][ODBC driver manager] data source name not found and no
default driver specified (SQL - IM002) at line..
> -Original Message-
> From: Peter J. Holzer [mailto:h...@wsr.ac.at]
> Sent: יום ג 29 יולי 2014 11:23
> To: Stuart Cooper
> Cc: Meir Guttman; dbi-users@perl.org
> Subject: Re: Bad error message
>
--
>
> However, not all RDBMSs support proper prepared s
On 2014-07-27 23:07:02 +1000, Stuart Cooper wrote:
> Because of your missing a backquote you effectively got an SQL statement
> with 0 bind variables.
Yes, however:
[...]
> On Sun, Jul 27, 2014 at 7:44 PM, Meir Guttman wrote:
[...]
> my $sql = qq(
> REPLACE INTO `test.`params`
>
Stuart.
On Sun, Jul 27, 2014 at 7:44 PM, Meir Guttman wrote:
> Dear DBI folks,
>
> The other day I had a trivial typo in my DBI SQL query that gave me an
> outlandish error message and grief. So outlandish that I spent two hours
> looking for the culprit.
>
> All it was is
Dear DBI folks,
The other day I had a trivial typo in my DBI SQL query that gave me an
outlandish error message and grief. So outlandish that I spent two hours
looking for the culprit.
All it was is a missing closing back-tic in the db name part of the
`database_name`.`table_name` SQL clause
host;sid=$sid;port=$port", $user, $passwd);"
performs without complaining and then executes SQL and returns the answer set.
-Tony
From: Alexander Foken
To: Tony Byorick ; "dbi-users@perl.org"
Sent: Monday, January 27, 2014 11:04 AM
S
On Jan 27, 2014, at 12:25 PM, Bruce Johnson
wrote:
>
> On Jan 27, 2014, at 12:04 PM, Alexander Foken wrote:
>
>>>
>>> I'm running 64 bit Windows and 64 bit Perl. Is it possible the DBD loader
>>> is failing because it is trying to load a 32 bit version of the Oracle
>>> driver?
>>
>> Yes
On Jan 27, 2014, at 12:04 PM, Alexander Foken wrote:
>>
>> I'm running 64 bit Windows and 64 bit Perl. Is it possible the DBD loader is
>> failing because it is trying to load a 32 bit version of the Oracle driver?
>
> Yes. The "bitness" of Perl and the database libraries must match, not only
the full error message:
Can't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll' for module
DBD::Oracle: load_file:%1 is not a valid Win32 application at
C:/Perl64/lib/DynaLoader.pm line 191. at
C:\go\perl\tracker\pingOracle.pl line 17.
[...]
I'm running 64 bit Windows an
I am trying to configure an Oracle connection from Perl running on a Windows 7
desktop to an Oracle 11g database running on Linux; however the database
connection step is failing.
The following line of perl code fails:
use DBD::Oracle;
Below is the full error message:
Can't lo
of whether data is returned or
not. I searched the internet and apparently this is not an error message as
such, but why has it started appearing? It was not apparent in the old DBD/DBI
modules.
Is there a way I can turn it off?
Any help appreciated.
Thanks and regards
Stuart
Stuart
orming a select operation on a table through the Perl script and I
> am getting following error on the console:
>
> DBD::ODBC::st execute failed: [Oracle][ODBC][Ora]ORA-00942: table or view
> does not exist
> (SQL-42S02) at Test.pl line 67
>
> The error message is well justified as t
> with $dbh->err and the full error message with $dbh-errstr .
>
> for more info:
> http://search.cpan.org/~timb/DBI/DBI.pm#err<http://search.cpan.org/%7Etimb/DBI/DBI.pm#err>
>
> On Mon, Nov 9, 2009 at 5:37 AM, Parag Kalra wrote:
> > Hello All,
> >
> >
t;prepare($select_sql);
$stmt->execute();
while (my @row = $stmt->fetchrow_array()) {
}
};
if ($@) {
# error message, if one occurs, will now be in $@
# for any error thrown by DBI
}
-Original Message-
From: Parag Kalra [mailto:paragka...@gmail.com]
Sent: Monday, Nove
If you have something like $dbh->do(); You can get the error code
with $dbh->err and the full error message with $dbh-errstr .
for more info:
http://search.cpan.org/~timb/DBI/DBI.pm#err
On Mon, Nov 9, 2009 at 5:37 AM, Parag Kalra wrote:
> Hello All,
>
> This is my first post
le or view
does not exist
(SQL-42S02) at Test.pl line 67
The error message is well justified as the table doesn't exist.
However I just wanted to know if there is a way to catch this error message
through some variable so that I can print it in a log file as well.
Cheers,
Parag
Andy,
thanks a lot for this hint and that you really took the time to go
through my lengthy posting!
You were absolutely right, after I corrected the insert statement the
error went away just like that!
Andy Hassall wrote:
You have ARTIKEL in the insert statement, but ARTIKELNUMMER in the table
ROTECTED]> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>
> -Original Message-
> From: Dr. Frank Ullrich [mailto:[EMAIL PROTECTED]
> Sent: 03 August 2004 08:21
> To: [EMAIL PROTECTED]
> Subject: ORA-
Hi,
I've got a mysterious problem with Oracle-DBD (v. 1.12) and DBI 1.32
against an Oracle 8.1.7.3 database.
An execute fails with ORA-904 ("invalid column name") although the
column names are correct and the prepare (it's an INSERT statement)
succeeded!
===
stallation.
>
> I had hoped that someone else might have stumbled onto this before hand.
>
> Any further help available?
>
> Thanks
> Mark Davis
>
> > -Original Message-
> > From: Tim Bunce [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, Septem
the
scripts we are runing gives the following error message:
null: DBD::mysql::st fetch failed: fetch() without execute() at
/usr/local/lib/perl5/site_perl/local/Calendar.pm line 1667.
The really annoying thing is that the error message keeps getting
written to to the error log until it fills up
On Mon, Dec 22, 2003 at 11:05:23AM +0200, Malka Cymbalista wrote:
> We are running Apache 1.3.26 with mod perl 1.26, perl 5.6.1, and mysql
> 3.23.49 on a Sun Solaris machine. Every now and then, one of the
> scripts we are runing gives the following error message:
> null: DBD::mys
We are running Apache 1.3.26 with mod perl 1.26, perl 5.6.1, and mysql
3.23.49 on a Sun Solaris machine. Every now and then, one of the
scripts we are runing gives the following error message:
null: DBD::mysql::st fetch failed: fetch() without execute() at
/usr/local/lib/perl5/site_perl/local
n.
I had hoped that someone else might have stumbled onto this before hand.
Any further help available?
Thanks
Mark Davis
> -Original Message-
> From: Tim Bunce [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 17, 2003 2:16 PM
> To: Mark S. Davis
> Cc: [EMAIL PROTECTED]
On Wed, Sep 17, 2003 at 12:25:12PM -0500, Mark S. Davis wrote:
> Though this problem has been noted by someone else in June (subj: No error
> string and unitialized value in concatenation ), I never saw a solution.
> Some might suggest that I use the debugger to chase
> down the problem. But when I
~~~~~~~~~~~
in debugger - proper error message is displayed
main::(testoracle:6): DBI->trace (5);
DB<1> c
DBI 1.37-nothread dispatch trace level set to 5
-&
Tim Bunce wrote:
> Thanks. Could you retry with DBI 1.37?
Yep, I did and it works as expected. I thought it couldn't be DBI,
because it worked with Oracle, but obviously I was wrong.
So I'm now going to upgrade some production systems... ;)
Thanks,
Joern
--
Joern Reder -- Software Developme
; MySQL is 4.0.13.
>
> With ShowErrorStatement => 1 the statement in the error message belongs
> to the last executed statement, if the actual SQL command is executed
> with DBI->do.
>
> This small script reproduces the error:
>
> --snip--
>
> #!/usr/bin/perl
>
>
Hi,
I found a bug in DBD::mysql 2.1026. I didn't try 2.1027 because,
according to the ChangeLog, it doesn't fix it. My DBI version is 1.30,
MySQL is 4.0.13.
With ShowErrorStatement => 1 the statement in the error message belongs
to the last executed statement, if the actual S
Gary fung wrote:
>
> I am now implementing a Perl program for data-mining. My program includes
> the using of DBI (ODBC). When I used small amount of testing data(within
> hundreds records), the program can run successfully. However, when I tried
> a large amount of data(hundred thousands of reco
I am now implementing a Perl program for data-mining. My program includes the using of
DBI (ODBC). When I used small amount of testing data(within hundreds records), the
program can run successfully. However, when I tried a large amount of data(hundred
thousands of records), it displays a messa
on?
SRH
--
SRH
-Original Message-
From: Neibarger Scott H [mailto:[EMAIL PROTECTED]]
Sent: 28 January 2003 15:48
To: '[EMAIL PROTECTED]'
Subject: [dbi] DBD-Oracle error message
Greetings,
I am encountering a strange problem with DBD-Oracle-1.12 with DBI-1.20, or
DBI-1.32 on Sol
more than a simple "select column from tablename
where column2 = ?" statement, which works fine if I execute it in the main
program, but if the call is made nested elsewhere within the program (via
subroutine), it returns the ORA-01747 error message regarding invalid table,
name, or col
Hi,
I have a problem with the perl module *DBD-CSV-0.2002* installation.
I prepared my debian system with:
- DBI-1.30
- SQL-Statement-1.005
- Text-CSV_XS-0.23
By the way, perl 5.6.1
Now I get this error message, but I don't understand what it really means.
[Debian]:/muh/DB
Hello !
Why I have this message after installing ActivePerl, mysql, and Apache ?
[Tue Dec 03 09:33:13 2002] [error] [client 127.0.0.1] install_driver(mysql)
failed: Can't load 'C:/Perl/site/lib/auto/DBD/mysql/mysql.dll' for module
DBD::mysql: load_file:Le module spécifié est introuvable at
C:/P
Hello,
I'm making progress on trying to install DBD-Oracle. Turns out my
previous problem with the repository errors was because I had a \ at the end
of the URL spec. Now that I've fixed that, I'm onto the next problem which
is the following error I get.
ppm> search DBD-Oracle
Searching in Acti
I also need to catch and
suppress the error messages explicitly so they do not print out?
Robert Kuropkat
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 24, 2002 5:32 AM
To: Robert Kuropkat (MIS Contractor)
Cc: '[EMAIL PROTECTED]'
Subject: R
Can you read these
http://www.google.com/search?q=SUCCESS%5FWITH%5FINFO+DBI+bunce
and send me a summary of what I said :)
Then I can update the docs...
Tim.
On Sat, Mar 23, 2002 at 03:55:56PM -0800, Robert Kuropkat (MIS Contractor) wrote:
>
> What does this mean?
>
> DBD::Oracle::db do f
What does this mean?
DBD::Oracle::db do failed: ORA-0: normal, successful completion (DBD
SUCCESS_WITH_INFO: OCIStmtExecute) at RTE/Schema_Code.pm line 746.
I can't tell if this is saying the DBI call failed or succeeded. The stored
procedure gets created so it does not seem to actually be
In article
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Ilya Sterin) wrote:
> As much as I shouldn't say this, but run the script without the -w to get
> rid of this message, or define a __WARN__ handler.
>
> Ilya
or use
local $^W;
within the loop
--
Scott R. Godin| e-mail
As much as I shouldn't say this, but run the script without the -w to get
rid of this message, or define a __WARN__ handler.
Ilya
-Original Message-
From: Pierre Gilbert
To: [EMAIL PROTECTED]
Sent: 10/24/01 10:20 AM
Subject: Unwanted error message with DBD::CSV
Hello,
fh'});
if (!$fields) {
die "Error while reading file " . $self->{'file'} . ": $!"
if $!;
return undef;
}
}
$self->{row} = (@$fields ? $fields : undef);
The problem appears to be with the undef $!; statement.
Great. Thanks.
Tim.
On Mon, Feb 19, 2001 at 04:23:40PM -0600, Paul Walmsley wrote:
>
> When DBD::Oracle 1.06 fetches a LOB from Oracle that is longer than
> LongReadLen and LongTruncOk is not set, it outputs an error message
> similar to this one:
>
> DBD::Oracle::st fet
When DBD::Oracle 1.06 fetches a LOB from Oracle that is longer than
LongReadLen and LongTruncOk is not set, it outputs an error message
similar to this one:
DBD::Oracle::st fetchrow_array failed: ERROR fetching field 3 of 2. LOB
value truncated from 199800 to 199800. DBI attribute LongReadLen
On Sun, 11 Feb 2001, Dave Rolsky wrote:
> I get a slew of these messages when my code finishes running, but only
> when using Perl 5.6.0 (I also tried 5.6.1 trial1).
So I finally tracked this down to a DBI handle passing through Storable's
dclone function. I made this not happen and the message
I get a slew of these messages when my code finishes running, but only
when using Perl 5.6.0 (I also tried 5.6.1 trial1).
Here's a sample:
SV = RV(0x844c874) at 0x844eb94
REFCNT = 1
FLAGS = (ROK)
RV = 0x8458ae4
(in cleanup) dbih_getcom handle 'DBI::db=HASH(0x8458ae4)' is not a
DBI
47 matches
Mail list logo
