I'm a novice with the DBI and SQL. I'm hoping someone can either give me
some guidance here, or at least point me to some resource that can help.
Let's say I have a table called 'report' that looks like this:
page order text
1 1 'first thing'
1 2 'sec
That capability is on the todo list.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Elena Kolgan" <[EMAIL PROTECTED]>
Read the docs for DBD::Proxy, your connect statment is wrong and never
specified to use ODBC on the server side.
In your connect change
dsn=northwind.mdb
to
dsn=DBI:ODBC:dsn_name
where dsn name is the name of the dsn that you set up on the server ODBC
applet.
If you are connecting from a non win
OK, more confused. Do I need DBD::OBDC to connect remotely or can I just
install DBD::Proxy(which I have) for this to work.
Re: DBD::OBDC
When I try to do make test I get the following error:
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
-I/usr/lib/perl5/5.00503/i386-linux -I/us
Tami King writes:
> Hello,
>
> Is there a limit on the size of a statement that you can 'prepare' or
> 'do' in DBI? I am trying to create a stored procedure on Sybase using
> DBI and DBD::Sybase. It looks a little bit like this:
>
> $rv = $dbh->do(< create procedure sp_myhelp
> \@obj
Hello,
Is there a limit on the size of a statement that you can 'prepare' or
'do' in DBI? I am trying to create a stored procedure on Sybase using
DBI and DBD::Sybase. It looks a little bit like this:
$rv = $dbh->do(
Is there a way to bind (IN and OUT) Perl arrays to PLSQL stored
procedure parameters which are plsql tables?
I'm using DBD-Oracle-1.06
Elena
I think you can use h2ph to convert the header file into something that
perl can use. There's several different ways to mix Perl with C/C++. You
can use one of the embed modules, XS, inline.pm, etc. Look at the Perl
perldoc for a list of appropriate documents on embedding/extending
Perl. If yo
On Thu, 29 Mar 2001, Rajan Sharma wrote:
> Can i use c header file in perl program. Want to use some functions that are
> there in c header file.
>
> I know this is not DBI question. But if you can answer me for it.
> :)
Take a look at the perlxs documentation via perldoc.
-- Brett
Can i use c header file in perl program. Want to use some functions that are
there in c header file.
I know this is not DBI question. But if you can answer me for it.
:)
Thanks
_
Get your FREE download of MSN Explorer at http://exp
I kept looking and the combination of parameters passed to the select that
seems to hang ($sth3) ends up returning NULL when I run it against the
development db. Using
declare @date datetime
select @date = max(date)
from dbo.table3
where a = '020'
and b = '451'
select @date
I've now been wait
I tried wrapping the $sth3 statement handle in a
do {
}while ($sth3->{syb_more_results});
loop. At the line where $sth3->execute() is run I get the error
DBD::Sybase::st execute failed: OpenClient message: LAYER = (1) ORIGIN =
(1) SEVERITY = (1) NUMBER = (16)
Message String: ct_param(): use
I have an application that does a few queries and one insert (via a stored
proc) within a loop that right now should run almost 400 times. When run
against the development server, it runs fine. When run against the
production mirror, it hangs.
I have 3 prepared selects:
$sth1 = $dbh1->prepare(
Roleigh Martin writes:
> We have a DBI perl program that after about 5,000 deletes we get this
> error message -- something similar happened with another program that did
> about 5,000 updates. The update program worked around the problem by
> removing use of the second database handle. The
Hi,
We have a DBI perl program that after about 5,000 deletes we get this
error message -- something similar happened with another program that did
about 5,000 updates. The update program worked around the problem by
removing use of the second database handle. The program logic basically
has a
I could not read the attachment with my mail reader. Can you tell me what
C compiler you are using? Are you using the Perl interpreter supplied by
Sun? If you are, reinstall Perl using the gcc compiler. Then try
installing DBI and DBD* also using gcc. Sun's Perl and C compiler spell
disaster
On Thu, Mar 29, 2001 at 09:24:08AM -0800, Craig Efrein wrote:
> I have a repair to the dump_results sub routine of DBI.pm.
>
>
> Problem:
> Any attempts to send results of table dump to a file fail because of
> call to STDOUT. Replaced STDOUT with Open File command
>
> Offending Code:
> $fh |
In your DBD::Oracle package see the file named Readme.java for the fix.
Ilya Sterin
-Original Message-
From: ad5500
To: [EMAIL PROTECTED]
Sent: 03/29/2001 9:21 AM
Subject: DBD - Oracle installation failed
Hi friends,
I loaded DBI and DBD::Oracle on my Unix user account.But it says that
Install ActivePerl if you don't already have it www.activestate.com
then see docs for ppm utility to install. Use it to install all (most) of
your modules in the future.
Something like this in the command prompt...
>ppm install DBI
and then
>ppm install DBD-Oracle8
Ilya Sterin
-Original
I have a repair to the dump_results sub routine of DBI.pm.
Problem:
Any attempts to send results of table dump to a file fail because of
call to STDOUT. Replaced STDOUT with Open File command
Offending Code:
$fh ||= \*STDOUT; e
Replaced With:
open(FH, ">$fh") || return undef;
$fh = \*FH;
an
While poking about in my favorite MUA
(Pronto; http://muhri.net/pronto)
I discovered what may be a serious bug in DBD::Pg. While attempting
to import some files (email) into the database, the script dumped
core.
Some experimenting shows that smaller files (>100k or so) insert
fine, but larger
Hello,
I am trying to install the DBI module for perl on Sun Ultra 10. I run perl
5.005_03. At the 'make' command, the c compiler fails with an error:
'language optional software package not installed'. I tried to do it on
other machines around and received the very same error.
The complete out
Not only is ActiveState's Perl interpreter an option, you could download
Cygwin and have a UNIX interface with Perl to run on top of Windows. I've
never tried it, but those I know who have love it.
If you go with ActiveState, download DBI and the appropriate DBD drivers
for the databases you will
If you have ActiveState Perl on your system, go to the command prompt and
type "PPM". Then type "install DBI"
You will need to determine which drivers you need to install for your
system, this will depend on the Database you have installed. To determine
which driver you need, type "perldoc DBI"
Hi friends,
I loaded DBI and DBD::Oracle on my Unix user account.But it says that I need a
solaris patch to connect when I try to connect to the Oracle DB using perl
script.
Do I need any other Oracle software module to be installed.
Thanks in advance for your help.
Anil DSouza
Bingo! I just assumed I could use the same syntax at the dbish DSN
prompt. But it works fine if I use that syntax when invoking dbish.
thanks
--Curt
On Thu, 29 Mar 2001, Michael Peppler wrote:
> Curt Russell Crandall writes:
> > Hi,
> >
> > I'm having problems opening a db connection to
Yep.
$ echo $SYBASE
/opt/sccm/oclient
--Curt
On Thu, 29 Mar 2001, Alexander Farber (EED) wrote:
> Curt Russell Crandall wrote:
> > Connecting to 'dbi:Sybase:server=SERVER1 user_name passwd' as ''...
> > DBI->connect failed: server message number=4002 severity=14 state=1 line=8
> > server=SERVE
Curt Russell Crandall writes:
> Hi,
>
> I'm having problems opening a db connection to Sybase using dbish. The
> perldoc says to use the syntax:
>
> dbi:Sybase:server=X [user [password]]
That's on the command line. I looked at the code for DBI::Shell and I
don't see anyway of entering
Curt Russell Crandall wrote:
> Connecting to 'dbi:Sybase:server=SERVER1 user_name passwd' as ''...
> DBI->connect failed: server message number=4002 severity=14 state=1 line=8
> server=SERVER1 text=Login failed.
> OpenClient message: LAYER = (4) ORIGIN = (1) SEVERITY = (4) NUMBER = (44)
> Message
Hi,
I'm having problems opening a db connection to Sybase using dbish. The
perldoc says to use the syntax:
dbi:Sybase:server=X [user [password]]
So, I executed dbish and did the following
Available DBI drivers:
1: dbi:ADO
2: dbi:ExampleP
3: dbi:Oracle
4: dbi:Proxy
5: dbi:Sybase
Enter d
i have windows 98 SE at home. and i wondered how would i install DBI module
and get started with it.
Thanks
Rajan
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
Chris,
Thanks for you help. I almost always see answers on this list that are
either faster, better, or cleaner. And they come fast too. I appreciate
the help that I have seen, received, and the things that I learn from
reading the list.
Gratefully,
Randy Peterman
Alt-N Technologies
www.a
* Randy Peterman ([EMAIL PROTECTED]) [010329 10:02]:
> Perl::DBI Friends,
> In order to make my life somewhat easier (I think), I am using JavaScript to
> fill out an entire form rather than type out all of the array[refs] in the
> values field of each form. I need to get an array of all of the C
On Thu, Mar 29, 2001 at 04:37:08PM +0200, Daniel Heiserer wrote:
> I get a field from my mysql database using perl, but when I
> print that field the $, of $OFS doesn't seem to work.
> The fields are separated with " ":
> while(@r=$cur->fetchrow_array){
> print "---> $#r:@r";
Hi,
I get a field from my mysql database using perl, but when I
print that field the $, of $OFS doesn't seem to work.
The fields are separated with " ":
--- describe y; --
1,2,3,4,5,6
---> 5:id int(11) YES
---> 5:v2 double YES
---> 5:v3 double Y
Perl::DBI Friends,
In order to make my life somewhat easier (I think), I am using JavaScript to
fill out an entire form rather than type out all of the array[refs] in the
values field of each form. I need to get an array of all of the Column
names since they are also identical to the field names
On Wed, Mar 28, 2001 at 12:17:52AM +, Roper, Tracy D. wrote:
> Further research shows that this make command ends with the following
> result:
>
> make -f /u01/oracle/OraHome1/rdbms/demo/demo_rdbms.mk build EXE=DBD_ORA_EXE
> OBJS=DBD_ORA_OBJ.o
>
> Make: Don't know how to make DBD_ORA_OBJ.o.
One has Machine has DBI 1.14 & DBD::Oracle 1.06
The other has DBI 1.14 & DBD::Oracle 1.03
..Guess I forgot to upgrade the other to 1.06.
On 29-Mar-01 Roper, Tracy D. wrote:
> Thanks Scott. I've tried everything else that I can find or think of. So I
> will not mind downloading this version an
Thanks Scott. I've tried everything else that I can find or think of. So I
will not mind downloading this version and seeing what it will do.
Just out of curiousity...what versions of DBI and DBD?
Tracy
-Original Message-
From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]]
Sent: Thursd
Yes, but with older Perls.
Digital UNIX V4.0D (Rev. 878); Sun Dec 19 14:14:20 CST 1999
This is perl, version 5.005_02 built for alpha-dec_osf
Oracle 8.1.6
Digital UNIX V4.0 878 alpha
This is perl, version 5.005_03 built for alpha-dec_osf
Oracle 8.1.5
..I installed these awhile ago, without a
Does anyone have DBD:Oracle installed and running ok on a Dec Alpha Tru64
system with Oracle 8.1.??
Tracy
-Original Message-
From: Roper, Tracy D.
Sent: Wednesday, March 28, 2001 9:09 AM
To: Roper, Tracy D.; '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Oracle Problems
Ok,
41 matches
Mail list logo
