Folks
#!/usr/bin/perl
use strict;
use warnings;
use DBI;
# -
my($dbh) = DBI - connect
(
'dbi:mysql:test', 'user', 'pass',
{
AutoCommit = 1,
PrintError = 0,
RaiseError
On 06-Jan-2003 Jeff Urlwin wrote:
[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
-Original Message-
From: Jonathan Leffler [mailto:[EMAIL PROTECTED]]
Sent: Sat 04/01/2003 07:26
To: Maras Michal
Cc: DBI Users Mailing List
Subject:Re: mod_perl and connect by DBD::Informix
Maras Michal wrote:
I wrote simple Apache::ASP page
---
HTML
BODY
Hello and a Happy New Year,
I'm afraid I have not succeeded in making myself understood. The problem
is neiher selecting from V$... nor determining my own SID, the problem
is that my login is not done as sysdba. Therefore, in particular, I
cannot login if the instance is down to start it up (and
Hi all,
This is really a mysql question rather than a dbi question. So, I
apologize to everyone in advance.
In mysql is it possible to retrieve records 50-75 from your result set?
Say my result set is 20,000 records. I would like to do this and
provide an index for the client to walk thru. I
Is it possible to use dbi + dbd-odbc to manipulate a paradox database on a linux box?
What drivers are available to use on a linux box?
Thank You.
Don
Hello,
Im having a problem when I'm trying to use the DBI from an embperl page
(otherwise it is working).
I get the following error:
[16868]ERR: 24: Error in Perl code: DBI object version 1.32 does not
match $DBI::VERSION 1.15 at
/usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 188.
Tim,
We started using DBI/DBD-Oracle (on 8i databases) last year and now as we
are starting to introduce 9i databases into our environment we are faced
with some new challenges. We have over 300 databases in our environment
and run many databases on a given server. We use perl for all of our
On Mon, 06 Jan 2003 09:59:41 -0700, Ian Harisay wrote:
In mysql is it possible to retrieve records 50-75 from your result set?
Yes. Add a LIMIT clause to your SELECT statement.
SELECT * FROM table LIMIT 50,25
It works well from within DBI (but don't append the semi-colon at the
end of
Mon, Jan 06, 2003 ve 10:05:18PM -0500 Thomas A. Lowery napsal(a):
# Well, I haven't downloaded dbMan, however reviewing the docs I'd say NO.
#
# But I don't wish dbMan's using in military sector (army, NATO etc.). You can't
# use dbMan if you are from U.S.A., Germany or Israel (due to their
Hi Tim,
Someone uploaded a module called 'DBI::Simple' to CPAN.
I believe you don't want the DBI:: namespace to be used by other
modules, and have created DBIx:: for that reason.
I also sent a message to the author.
Because DBI::Simple is broken, I think its existence could damage the
This distribution has been tested as part of the cpan-testers
effort to test as many new uploads to CPAN as possible. See
http://testers.cpan.org/
Please cc any replies to [EMAIL PROTECTED] to keep other
test volunteers informed and to prevent any duplicate effort.
--
This is an error report
On Mon, 6 Jan 2003 12:45:47 +0100 Georg Botorog [EMAIL PROTECTED] wrote:
I'm afraid I have not succeeded in making myself understood. The problem
is neiher selecting from V$... nor determining my own SID, the problem
is that my login is not done as sysdba. Therefore, in particular, I
cannot
Check out 'LIMIT' in the MySQL docs. It should be able to handle exactly what you want.
http://danconia.org
On Mon, 06 Jan 2003 09:59:41 -0700, Ian Harisay [EMAIL PROTECTED] wrote:
Hi all,
This is really a mysql question rather than a dbi
On Mon, 6 Jan 2003 15:07:11 -0500 oren [EMAIL PROTECTED] wrote:
Hello,
Im having a problem when I'm trying to use the DBI from an embperl page
(otherwise it is working).
I get the following error:
[16868]ERR: 24: Error in Perl code: DBI object version 1.32 does not
match $DBI::VERSION
On Mon, 6 Jan 2003 15:28:02 -0500 Robert Hansen [EMAIL PROTECTED] wrote:
There is no need to write Tim directly.
We started using DBI/DBD-Oracle (on 8i databases) last year and now as we
are starting to introduce 9i databases into our environment we are faced
with some new challenges. We
On Tue, 7 Jan 2003 09:29:09 -0500 Robert Hansen [EMAIL PROTECTED] wrote:
Thanks for the reply. It is certainly possible to do what you have
suggested and in fact we have tested this out and it works fine. However,
we were hoping for a cleaner solution. We currently cycle through the
oratab
Dne po 6. leden 2003 18:56 jste napsal(a):
Is it possible to use dbi + dbd-odbc to manipulate a paradox database on a
linux box?
What drivers are available to use on a linux box?
Thank You.
Don
Yes, if you have ODBC driver for Paradox.
Basicaly install on Windows:
Perl 5.6.1 build 633
On Tue, 7 Jan 2003 11:28:19 -0500 oren [EMAIL PROTECTED] wrote:
I was trying to remove the DBI.so from the perl normal installation
tree, but it didn't work.
I also tried to use the DBI files from the Apache tree in the Perl
normal location and that didn't work too.
The DBI.pm and DBI.so
I cannot get a script to run from a browser. I've added the ORACLE_HOME
environment variable, but it doesn't seem to help. With it or without it,
the message is the same. The error message is:
Can't connect ORA-12640: Authentication adapter initialization failed
(DBD: login failed).
Hello,
I am having some difficulty getting the latest version of DBD::Informix compiled on my
hpux server. I am running 64 bit Hpux 11i, and trying to compile DBD::Informix v.
1.0.4. I believe to have successfully compiled the latest version of the DBI Mod
(1.32) , though I had some test
On Tue, Jan 07, 2003 at 10:22:19AM -0500, [EMAIL PROTECTED] wrote:
Dear Tim Bunce:
I've been porting a number of my company's apps from Sybase to Oracle,
using DBI as the primary database interface, and ran into a problem I hope
you can help me with; I haven't gotten useful answers on the
On Tue, Jan 07, 2003 at 09:28:19AM -, [EMAIL PROTECTED] wrote:
On 06-Jan-2003 Jeff Urlwin wrote:
[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
Thanks for the test case. I'll look into it.
Tim.
On Tue, Jan 07, 2003 at 07:54:16PM +1100, Ron Savage wrote:
Folks
#!/usr/bin/perl
use strict;
use warnings;
use DBI;
# -
my($dbh) = DBI - connect
(
'dbi:mysql:test', 'user', 'pass',
{
Hello,
Can anybody tell me how to install DBI into
non-default directory? Basically I don't have
root permission to the Linux machine on which
I am trying to use DBI. The Perl bin is in /usr.
But I can't install the DBI module into
that directory since that would require root
permission. Can
On Tue, 7 Jan 2003 14:33:26 -0800 (PST) Gary Zhang [EMAIL PROTECTED] wrote:
Can anybody tell me how to install DBI into
non-default directory? Basically I don't have
root permission to the Linux machine on which
I am trying to use DBI. The Perl bin is in /usr.
But I can't install the DBI
The prefix directive will help you for installing DBI wherever you need it
to go. Who knows, you might be able to get through it without resorting to
manually editing the Makefile.
When you're done with the install, you'll also need to tell your scripts
where to find DBI. I did this with the
The only situation I've seen that can be a little confusing is this:
DBI-connect('dbi:ODBC:dsnname', 'dbuser', 'dbpass')
works
and
DBI-connect('dbi:ODBC:DSN=dsnname', 'dbuser', 'dbpass')
fails with whatever message the database engine returns for invalid
Hi,
I need to set up a DSN on the Linux machine before I can attempt to run the
following command.
dsn=dbi:ODBC:YourDSN'
How can I do so?
Example code from http://dbi.perl.org
use DBI;
use Data::Dumper;
my $dbh = DBI-connect(
'dbi:Proxy:hostname=YourMSHostName;port=1234;dsn=dbi:ODBC
:YourDSN'
29 matches
Mail list logo