Hello
After instaling the package DBI 1.42 on Mac OS X Server version 10.2.4 I have
want to install the package DBD::ODBC 1.09 but I have found thise problems :
-1 after entering the command: Perl Makefile.PL I have obtained the following
message:
-
Useless use of private
Is there a dummy driver for DBI that basically does
nothing? Maybe a set of stubs so I could do something
like this:
use DBI;
my $dbh = DBI-connect(dbi:null, , );
my $sth = $dbh-prepare(SELECT * FROM mytab WHERE id = ?);
$sth-execute(3141);
while (my @vals = $sth-fetchrow_array()) {
...
Is there a version of DBI or DBI/DBD that will connect to a MS-SQL Server
2000 database without using ODBC/DBD-ODBC?
I need to connect to MS-SQL Server from a HPUX 11.00 system that is not
configured to use ODBC data sources.
Thanks in advance..
--
Jeff Hinds - Database Specialist
Middle
On Thu, 2004-05-13 at 16:58, Jeff Hinds wrote:
Is there a version of DBI or DBI/DBD that will connect to a MS-SQL Server
2000 database without using ODBC/DBD-ODBC?
I need to connect to MS-SQL Server from a HPUX 11.00 system that is not
configured to use ODBC data sources.
See FreeTDS -
On 13-May-2004 [EMAIL PROTECTED] wrote:
Hello
After instaling the package DBI 1.42 on Mac OS X Server version 10.2.4 I have
want to install the package DBD::ODBC 1.09 but I have found thise problems :
-1 after entering the command: Perl Makefile.PL I have obtained the
following
message:
Dear all,
After installing DBI, I try to install DBD-Oracle-1.15 in my Sun Solaris
9.0 computer. My oracle is 10.g. Running perl Makefile.pl, I did not
find any special error message. But I got a following message when I run
make and make test. Could you please help out about this issue?
Hi Chrisopher,
Christopher Huhn wrote:
I'm missing the following features using DBD::CSV:
* Selecting constant values isn't working (i.e. SELECT 'xyz' FROM
table). AFAIK that's plain SQL.
Yes, it's plain SQL but not yet supported by SQL::Statement. The syntax
that is supported is
Egan Ford wrote:
This is a parser for simple name=value style Ini files. Soon it will also
handle files with sections.
Is there an update?
I'm attaching a couple of things I've got sitting around but that aren't
ready for release yet that might help you. The first works like this:
my $dbh =
This time, with feeling ... here's the attachments.
--
Jeff
#
package AnyData::Format::Hash;
#
# copyright (c) 2000, Jeff Zucker [EMAIL PROTECTED]
# all rights reserved
Hi All,
I am running perl 5.0.6.1 on Solaris 2.9. I use DB_File v1.807 to access
Berkeley DB (i do not know which version... pl tell me how to get this).
I am using Perl's tie function to tie the DB_File to a hash. The DB_File
(.dbf) is quite a big file approx 10 MB in size with 92000 key value
[EMAIL PROTECTED] wrote:
I am using Perl's tie function to tie the DB_File to a hash. The DB_File
I don't know the answer to your question. But since you cc'd the
dbi-users list, I thought I'd let you know that, as of the most recent
release of DBI (1.42), the DBI distribution now comes with
Guys,
I'm migrating my system from DBI 1.30 to 1.42 but I found onte little problem,
this piece off code used to worked at 1.30 but now it simple don't do this update,
unless I pass the update values directlty on the $query. What is causing this? Anyone
can help-me?
#!/usr/bin/perl
use
What is your error?
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Pedro Anisio [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 12:57 PM
To: [EMAIL PROTECTED]
Subject: Problems changing from 1.30 to 1.42
Guys,
I'm migrating my system
So, does this mean $msg is undef? What is the value of $sth-err or $sth-errstr?
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Pedro Anisio [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 1:02 PM
To: [EMAIL PROTECTED]
Subject: Res: RE:
Sorry for the last faux pas. I misread your code.
Where do you commit? Or, is AutoCommit = 1?
Is the behavior the same with both versions of DBI? Did something else change?
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Reidy, Ron
Sent:
Use trace()
Tim.
On Fri, May 14, 2004 at 04:05:44PM -0300, Pedro Anisio wrote:
Sorry, I didnt send this part of the code
@param = (2, 343520291, 1);
-MENSAGEM ORIGINAL-
De: Pedro Anisio [EMAIL PROTECTED]
Enviada em: Sex, 14 Mai 2004 16:02:14
Assunto: Res: Res: RE: Problems
Delaporte, Olivier wrote:
Here is the set-up:
DBD-Informix-2003.04
INFORMIX-ESQL Version 9.30.HC1 or ClientSDK 2.40
HP-UX 11.11 64 bit
Gcc 3.3.3
Perl -V:
Compiler:
cc='gcc', ccflags ='-D_POSIX_C_SOURCE=199506L -D_REENTRANT
-D_HPUX_SOURCE -fPIC -mpa-risc-1-1 -fno-strict-aliasing
Hi,
I have a really big sql scripts with many select, procedures and spool spool
off statements. I want to know how can i run this sql script with DBI.
With sqlplus, this sql script run correctly. But I don't know how can i run
this script with perl.
Can you help me?
Mathieu,
Sure, you can run the SQL statements in your file with DBI, but you will need to parse
the file to get all the SQL statements and then run them through the DBI interface. I
would suggest that if you need to use Perl/DBI, that you instead look at a different
method than running the
On Wed, 12 May 2004, JupiterHost.Net wrote:
Ronald J Kimball wrote:
JupiterHost.Net [mailto:[EMAIL PROTECTED] wrote:
I found do() and quote() in DBI.pm, prepare() in DBD::mysql, but I
couldn't find execute() - I wanted to see how it does the quoting
exactly (for binary data) -
Thank you so much for your help. It works well after installing the
64-bit perl.
Have a good weekend!
Fei
-Original Message-
From: BLACH Johannes [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 8:41 AM
To: Fei Zhong US-Germantown
Cc: [EMAIL PROTECTED]
Subject: Re: wrong ELF class
Below please find the error message, current path, code, and .pm. I'm
using active perl on win2k. I added threesharp.pm to
C:\Perl\site\lib\AnyData\Format\ with the other .pm files.
I think my path needs help. This is my first attempt at DBI code below.
What should I be looking for to add to the
leegold wrote:
C:\Documents and Settings\Administrator\Desktop\threesharpperl
threesharp.pl
Can't locate object method ad_catalog via package DBI::db at
threesharp.pl line 9.
my $dbh = DBI-connect('dbi:AnyData(RaiseError=1):');
$dbh-ad_catalog( $table_name, 'ThreeSharp', $file_name);
It
.
Can't locate object method ad_catalog via package DBI::db at
threesharp.pl line 9.
my $dbh = DBI-connect('dbi:AnyData(RaiseError=1):');
$dbh-ad_catalog( $table_name, 'ThreeSharp', $file_name);
It sounds like you have an older version of DBI (1.37), for that you
I'm actually looking for the source code for execute() (IE sub execute {
.. }), do() and quote() are in DBI.pm, prepare() is in DBD/mysql.pm but
execute in neither.
The source code for execute is in dbd_st_execute() in dbdimp.c, and if you want
to know how the quoting is done, you will need to
crowja wrote:
Is there a dummy driver for DBI that basically does
nothing? Maybe a set of stubs so I could do something
like this:
use DBI;
my $dbh = DBI-connect(dbi:null, , );
my $sth = $dbh-prepare(SELECT * FROM mytab WHERE id = ?);
$sth-execute(3141);
while (my @vals =
26 matches
Mail list logo
