Hello,
I'm using DBD::ODBC with unixODBC and FreeTDS from CVS (today's special
blend...)
I have the following code:
$DDI = 1;
$CPIN = 0;
$MPIN = 0;
$Info = " ";
$ResRef = 0;
$ConfRef = 0;
$ActDuration = 0;
$AvailInd = 0;
$rc = 0;
$dbh->do('use BSRes2');
$sth = $dbh->prepare('
declare @DDI
Fix to call finish() automatically if execute is re-called in a loop
(and test in t/02simple.t to ensure it's fixed)
Augmented error message when longs are truncated to help users
determine where
to look for help.
Fixes for build under Win32 with Perl5.8.
The uploaded file
DBD-ODBC
Paul,
FYI this is now fixed in my as yet unreleased 1.02.
Thanks!
Jeff
>
> This is the situation in which I've found the finish() method
> to be required using DBD::ODBC. It appears that every second
> execute statement is dying. I am using: WinXP Perl 5.8.0
> (ActiveState) DBI 1.30 (from
On Mon, 6 Jan 2003 19:41:20 -0500 (EST) Paul Boutros <[EMAIL PROTECTED]>
wrote:
> This is the situation in which I've found the finish() method to be
> required using DBD::ODBC. It appears that every second execute statement
> is dying. I am using:
> WinXP
> Perl 5.8.0 (ActiveState)
> DBI 1.30 (
> Hi,
>
> my $result;
> $result = $dbh->do("INSERT INTO Test (TextCol,DateCol) VALUES
> ('hello','20030106 23:48:01:000')"); # always OK
> if( $result ) {
> print "First INSERT OK.\n";
> }
Rig
This is the situation in which I've found the finish() method to be
required using DBD::ODBC. It appears that every second execute statement
is dying. I am using:
WinXP
Perl 5.8.0 (ActiveState)
DBI 1.30 (from ActiveState)
DBD::ODBC 0.43 (from ActiveState)
Paul
### CODE ##
use strict;
use
I used flag --nocatchstderr on perl make file? and I have received this
results on make:
Dmitry Nikolayev@NICK /cygdrive/e/modul/6
$ make
gcc -c -I/usr/lib/perl5/site_perl/5.6.1/cygwin-multi/auto/DBI -I'/usr/local/
incl
ude/mysql' -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -I/usr/local/include
-
Here is the result of reexecuting of this string(starting with
LD_RUN_PATH ):
dllwrap --dllname mysql.dll --driver-name gcc --dlltool
dlltool --export-all-symbols --as as --output-def libmysql.def --output-lib
libmysql.a \ -s -L/usr/local/lib bdimp.o mysql.o
/usr/lib/perl5/5.6.1/cygwin-multi/CORE/
On Tue, 7 Jan 2003 01:13:05 +0200 Nikolayev Dmitry <[EMAIL PROTECTED]> wrote:
> Sorry, I'm newbie.. so I attached a gif file with the window of cygwin,
> when
> error ocured
> As I understand all is ok with chmod
Except that, according to your .gif image, the file it is trying to
change t
;port=24001;dsn=dbi:ODBC:TESTDB','sa','password',
{ RaiseError => 1, PrintError => 1}) or die $DBI::errstr;
$dbh->do("CREATE TABLE Test ( TextCol VARCHAR(10), DateCol DATETIME )");
my $result;
$result = $dbh->do("INSERT INTO Test
Can anyone help me get DBI installed on my server (Mac OS 10.2.2
running Webstar 5.2.3)? Below is the terminal output which contains
numerous errors. Everything went fine until I got to the MAKE step. I
don't know how to correct this and any help will be appreciated.
Terminal Output
Does anyone know how I can install the
DBD-Oracle module?
ppm install DBD-Oracle
AND
ppm install DBD-Oracle8
does not work as it used to.
Thanks,
Cary
Thank you for your answer, Michael...
Sorry, I'm newbie.. so I attached a gif file with the window of cygwin, when
error ocured
As I understand all is ok with chmod
- Original Message -
From: "Michael A Chase" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Nikolayev Dmitry" <[EMA
On Tue, 7 Jan 2003 00:32:36 +0200 Nikolayev Dmitry <[EMAIL PROTECTED]> wrote:
> Hello!
>
> Somebody, help me!
> I'm using cygwin.
> I had built DBI without any problems, but when I tried to install
> DBD::Mysql I have a few
> perl makefile.pl - no problems
> make
>
> And we have:
Hello!
Somebody, help me!
I'm using cygwin.
I had built DBI without any problems, but when I tried to install DBD::Mysql I have a
few
perl makefile.pl - no problems
make
And we have:
gcc -c -I/usr/lib/perl5/site_perl/5.6.1/cygwin-multi/auto/DBI
-I'/usr/local/include/mysql' -DPE
hi all...
I was wondering if anybody has done any work with nested cursor
references and DBI. something like:
open curref for
'select sysdate,
cursor (select sysdate from dual)
from dual';
from DBI the first cursor reference behaves as expected, but I get a
segfault when t
On Mon, 06 Jan 2003 11:09:14 -0600 Taylor Lewick <[EMAIL PROTECTED]> wrote:
> Yes, I have ORACLE_HOME, LD_LIBRARY_PATH, and SHLIB_PATH all set for
> that user...
>
> How do I turn on/up dbi tracing so I can generate a trace file?
It's in the fine DBI manual, look for 'trace' and 'debugging'.
ht
On Mon, 6 Jan 2003 10:28:17 -0600 (CST) Michael Nhan <[EMAIL PROTECTED]> wrote:
> http://www.rosat.mpe-garching.mpg.de/mailing-lists/dbi/
>
> has a nice searchable archive for the DBI mailing list. Can you also
> post
> the errors you are getting from the web page and from the error logs of
> th
Yes, I have ORACLE_HOME, LD_LIBRARY_PATH, and SHLIB_PATH all set for that user...
How do I turn on/up dbi tracing so I can generate a trace file?
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
"Help Wanted. Seeking Telepath..."
"You Know where to apply."
*
Is your ORACLE_HOME set in that user's environment?
-Joe
Yeah, sorry about that, here are the errors...
>From command line as user www (the owner of the apache web server)
Can't load '/opt/perl5/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBD/Oracle/Oracle.sl' for
module DBD::Oracle: Permission denied at /opt/perl5/lib/5.6.1/PA-RISC2.0/DynaLoader.pm
line 206.
Hi,
http://www.rosat.mpe-garching.mpg.de/mailing-lists/dbi/
has a nice searchable archive for the DBI mailing list. Can you also post
the errors you are getting from the web page and from the error logs of
the webserver, they will allow people to assist you better on the list.
Cheers,
Michael
What was your error message?
-Joe
Okay, sorry to be posting this here. I have read over and studied this problem, and
played iwth it several times, but can't figure out what I am missing/doing wrong.
I have the DBI and DBD::Oralce modules installed on HP-UX. When I run my sample
program as user root from the command line, it run
The latest DBD::Oracle is 1.12 (August 2001).
Check you have that using "perl -MDBD::Oracle=1.12"
For ora_session_mode to work DBD::Oracle must have been compiled use OCI 8.
Check that using "perl -MDBD::Oracle -l -e 'print DBD::Oracle::ORA_OCI()'
Tim.
On Mon, Jan 06, 2003 at 12:45:47PM +0100,
[snip]
>
> BTW, SQLConnect (the ODBC 1.0 function DBD::ODBC can use) has
> a limit on the size of the string you can pass in the first
> argument (I think it is 32). DBD::ODBC used to get around
> this by looking for "DSN=" at the start of the string and
> using SQLDriverConnect instead. I'm n
Folks
Back in Sep 2000 I released a pure Perl program, then called
myadmin.pl, for administration of MySQL dbs. See tut # 35:
http://savage.net.au/Perl-tutorials.html
Here are the features:
# Operating System-level features
# o Runs under Linux
# o Runs under Wi
On 06-Jan-2003 Jeff Thies wrote:
> Jeff Urlwin wrote:
>>
>> That's probably an old bug in DBD::ODBC, and I suspect you're using
>> version 0.28. If so, please upgrade. If not, please post more
>> specifics about your version.
>
> Just installed it last week (ppm) and have been running Access o
28 matches
Mail list logo
