>
>
> I think the jakarta-tomcat-connectors distributions has an nt service
> installer that, though designed for installing tomcat, works for
> installing other things as services.
The resource kit tool required is SrvAny. Other than that, perlService
(from ActiveState) may do the trick.
Jeff
On Mon, Apr 08, 2002 at 11:01:45AM +0100, Simon Oliver wrote:
> Vassiliy Truskov wrote:
> >
> > I use DBD::ADO to connect to the DB using OLE DB Provider.
> > To generate result form I need some information about columns
> > (likes in DBD::ODBC ColAttributes).
> > Is there is a way to get same in
I think the jakarta-tomcat-connectors distributions has an nt service
installer that, though designed for installing tomcat, works for
installing other things as services.
--
Ian Kallen <[EMAIL PROTECTED]> | AIM: iankallen
On Mon, 8 Apr 2002, Karyn Ulriksen wrote:
> I've read back into the arc
From: "M.W. Koskamp" <[EMAIL PROTECTED]>
To: "Condle, Joseph P" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 13:41
Subject: Re: Web Based Form with DBI
> >Vilolated (DBD ERROR: OCIStmtExecute at insert.pl line 77
> ViLolated? where did that typo come from??
> Check you c
I've read back into the archives and the search engines looking for an
answer to this, but to no avail. So if I missed it in the archives, I
apologize in advance.
My DBIproxy happily runs on my Win2K box and I am able to interact quite
well with my MS SQL server from unix boxes (which was the po
"M.W. Koskamp" wrote:
>
[brought the problem to the point]
> $sth->bind_param(1, $dbh->quote($ssn));
> etc...
but i always thought, the great advantage of bind_param is to handle directly the
desired
values,
so you don't need the quote-method anymore?!
marco
Hi,
I want to make a connection to Oracle when DB is not
open, so I must connect as sysdba.
How can I do that?
Thanks in advance,
Xin
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
ppm install http://theoryx5.uwinnipeg.ca/ppmpackages/DBD-mysql.ppd
Should do.
Ilya
-Original Message-
From: Bob T
To: [EMAIL PROTECTED]
Sent: 4/8/02 3:13 PM
Subject: DBD mysql
WinXp
Crashed my D: drive and I had most everything backup..
So when I reinstalled ActivePerl 5.6.xx I dow
WinXp
Crashed my D: drive and I had most everything backup..
So when I reinstalled ActivePerl 5.6.xx I downloaded via PPM
(perl package installer) the DBI, DBIx::AnyDBD but could not find
DBD:mysql. Where is the package for Windows..
I did find, at CPAN, the mysql.gz.tar version which I use
howdy--
i am using DB2 7.2.3 on RH linux 7.2. i am trying to bind some parameters
to an INSERT statement and getting the following errors:
CLI0125E Function sequence error.
Explanation: This function was called in an invalid sequence.
SQLSTATE=HY010 (which has the following *3* possible meanin
From: "Condle, Joseph P" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 12:27
Subject: Web Based Form with DBI
> I am trying to input data from an html form. I can insert data from a
straight
> dbi script without a problem. I can get data from the form without having
these errors:
>The error_log of the apache web server
>Printf() on closed filehandle JOE at insert.pl line 59.
>Printf() on closed filehandle JOE at insert.pl line 61.
>Printf() on closed filehandle JOE at insert.pl line 62.
>Printf() on closed filehandle JOE at insert.pl line 63.
>Printf() on c
Hello All,
i am trying to select a big chunk of data to archive it into a flat file.
Its a " select * " query which normally returns 1,200,000 records.
1. Is there anything in DBI/DBD that I can use to do the job without
selecting first and then storing it?
2. which method in DBI/DBD should I tr
Can you get a CGI script working by itself, just a little simple select or
something that prints the output? If not, then your environment is not
correctly set up for CGI, which the server runs with the user nobody or
similar. Make sure the user has the right persmissions and that the
LD_LIBRARY
On Mon, 8 Apr 2002 15:27:57 -0400 "Condle, Joseph P" <[EMAIL PROTECTED]> spoke
gently:
> The Errors
> >From the html form netscape Error The document contained no data.
> Try again later, or contact the server's administrator
The code isn't actually printing a web page. Just a header.
> The e
I am trying to input data from an html form. I can insert data from a straight dbi
script without a problem. I can get data from the form without having the dbi piece.
But I can not merge the two and get it to work. When I run the following script I get
the following errors but the record ge
If you're on Oracle, you can do:
SELECT nvl(max(some_item),0)
FROM db
WHERE item = 'something'
That will give you 0 if there are no "something" and will give you the
value.
Paul Rensel wrote:
>Hi there,
>
>I want to use a "select max(some_item) from db where item = 'something"
>query.
>
>How c
you could count the number of records in your table first.
Then if count is greater than 0 you can do your max selection. I assume you are
trying to find the max value stored in a field. Such as, the largest row_id.
Paul Rensel wrote:
>
> Hi there,
>
> I want to use a "select max(some_item)
Hi there,
I want to use a "select max(some_item) from db where item = 'something"
query.
How can i check or test if there is indeed a max(some_item) for a given
'something' selection given and when there's not an max(some_item) ??
I've tried everything like $sth->rows and such but it seems that
I think the question would be, "how often are you going to do this"? Will it be
just once? Once a month? Once a Day? How much performance will you get from
sqlldr? Everything I have read says sqlldr is faster than using Perl. I think
it depends on the environment. Especially how Oracle is se
On Mon, Apr 08, 2002 at 11:01:43AM -0400, Kong, Alan wrote:
>
> I'm using PERL DBI to query the data from Oracle database. In my SQL, there
> is a '&' character in my where clause, so that I can't get my result set.
> Can somebody tell me how can I set the scan off? Thanks.
>
You might try
Any help greatly appreciated!
I'm running Perl 5.00503 on a Solaris 2.6 machine.
I have Microsoft Access Databases that I wish to connect to, these live
on
the same UNIX machine.
I've installed DBI-1.20 and have downloaded DBD::ODBC-0.28. I am getting
a lot
of conflicting advice on exactly what
From: "Stuart Cocks" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 08:41
Subject: Problem installing DBD-Oracle-1.12 under cygwin on Windows 2000
>
> I am having problems installing DBD-Oracle-1.12 in cygwin on a Windows
> 2000 Server machine.
> . . .
> Configuring
This method will work, though you may want to consider this alternative if
you have a lot of rows. Create a flat file of from your Sybase table and
use sqlload to load the records into your Oracle table. Use direct path
loading for better performance.
If you go with the method below, use {AutoC
Wayne,
We went throw a sybase->oracle data conversion a couple of years ago. An
in-house developed perl script went through the following steps to
accomplish the data migration:
- check data types on sybase side
- if table didn't exist on oracle,
- create compatible structure in oracle
- if t
From: "Kong, Alan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 08:01
Subject: Help - Set scan off
> I'm using PERL DBI to query the data from Oracle database. In my SQL,
there
> is a '&' character in my where clause, so that I can't get my result set.
> Can somebody
I am having problems installing DBD-Oracle-1.12 in cygwin on a Windows
2000 Server machine.
I am trying:
perl Makefile.PL
this gives the following output:
--
Using DBI 1.21 installed in
/usr/lib/perl5/site_perl/5.6.1/cygwin-multi/auto/DBI
Configuring D
>
> Thanks! Question: does the Oracle side have to use DBD::ODBC (with Oracle
> ODBC) to work due to the date verses datetime datatype issues? I would
> prefer to just use DBD::ORACLE in hopes of it being faster.
>
You probably do not need DBD::ODBC. You can handle it yourself in a few
ways (fr
I guess that would be DBD::Oracle 1.12 not 1.21. Darn these keyboards. Why
can't they make a keyboard for full figured men.
Ian Harisay wrote:
>
> Hi,
>
> I updated to DBD::Oracle 1.21 and now '/format box' is not working for me in
> dbish (which I would much rather use than sqlplus. call it
Hi,
I updated to DBD::Oracle 1.21 and now '/format box' is not working for me in
dbish (which I would much rather use than sqlplus. call it an attitude.). below
is the error produced.
Use of inherited AUTOLOAD for non-method DBI::SQL_BIGINT() is deprecated at
/usr/lib/perl5/site_perl/5.6.0/i386
Thanks! Question: does the Oracle side have to use DBD::ODBC (with Oracle
ODBC) to work due to the date verses datetime datatype issues? I would
prefer to just use DBD::ORACLE in hopes of it being faster.
-Original Message-
From: Ian Harisay [mailto:[EMAIL PROTECTED]]
Sent: Friday, April
> I'm in the process of running through my alterations to
> DBD::Oracle which fix this (to make sure I haven't done
> anything drastically stupid), if you would like me to submit
> them to you then I am happy to do so.
Am including a diff of the file here
bash-2.03$ diff Oracle.pm Oracle.pm.p
The simplest so solution is to make you dev box look like the prod box,
before you build...
The second simplest solution is to make the prod box look like the dev box.
You can do either of these by using directories and soft links. You do not
have to actually move anything. Just make the paths
Sorry I read my email only after the weekend, I hope better now than never.
Excellent idea to have web-accesible FAQ.
Link to this FAQ site should be added to each email
sent by [EMAIL PROTECTED] manager, IMHO.
PerlMonks site (www.permonks.com) has bunch of DBI FAQ at
http://www.perlmonks.com
Hi,
I'm using PERL DBI to query the data from Oracle database. In my SQL, there
is a '&' character in my where clause, so that I can't get my result set.
Can somebody tell me how can I set the scan off? Thanks.
Alan
Do you have the Oracle client libs installed? If not make sure to install
them and update you LD_LIBRARY_PATH.
Ilya
-Original Message-
From: Yuriy Lebedyev
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 4/8/02 6:43 AM
Subject: bugs
Hello, my name is Yuriy Lebedeyev.
I've tried to i
First you need the Oracle client libs installed on your PC. You can get
that from technet.oracle.com.
Then read perldoc DBI and perldoc DBD::Oracle as well as possibly invest in
the book (Programming the Perl DBI). (hint: Don't use oraperl, use DBI:-)
Ilya
-Original Message-
From: Adr
Hello, my name is Yuriy Lebedeyev.
I've tried to install DBD-Oracle-1.12 but the test is fail, writing
the error like:
PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib
-I/usr/local/lib/perl5/5.6.0/i386-svr5 -I/usr/local/lib/perl5/5.6.0 -e 'use
Test::Harness qw(&runtests $ver
Well, this is only a guess, but I would expect that the ActiveState Perl 5.6.1
for Windows fork() implementation does not support the kind of things that DBI
and DBD::mysql do, storing pointers to C structures in Perl objects. So unless
somebody patches DBI and DBD::mysql to support interpreter
Hello, I am using Active Perl, web-server OmniHTTPD and Windows 2000.
I have to run scripts that communicates with a Oracle database, and the
database is located in other machine in localNet, a Solaris. I have a IP
and a Port and the name of the database I need, like this:
192.168.20.177:1521:Dat
(first off apologies for the huge sig, theres nothing I can do about it)
have been using table_info to get a list of tables (I'll leave the story
behind it out)
Effectively I want a list of all "TABLE", so the code
my %attr = (
TABLE_CAT => undef # String value of the catalog name
Google is your friend.
http://www.google.com/search?hl=en&safe=off&as_qdr=all&q=DBD%3A%3AProxy+bind_param_inout+bunce+patch
Tim.
On Mon, Apr 08, 2002 at 10:17:47AM +0100, Ben Lowe - RMC EMEA - Web Developer wrote:
> Hi,
>
> I have repeated my original post below. Does anyone on here know if it
Hello, I am using Active Perl, web-server OmniHTTPD and Windows 2000.
I have to run scripts that communicates with a Oracle database, and the database is
located in other machine in localNet, a Solaris. I have a IP and a Port and the name
of the database I need, like this: 192.168.20.177:1521:D
Vassiliy Truskov wrote:
>
> I use DBD::ADO to connect to the DB using OLE DB Provider.
> To generate result form I need some information about columns
> (likes in DBD::ODBC ColAttributes).
> Is there is a way to get same information from DBD::ADO?
Until the column_info method is supported you ca
Hi,
I have repeated my original post below. Does anyone on here know if it is
possible to use inout parameters using DBD::Proxy ? Is this a specific problem
with oracle ? What I would like to do is to execute an oracle stored
procedure and return back a primary key or an error message.Has anyon
Hi!
I am running Windows’98 and ActiveState Perl 5.6.1! I am trying to use
forks and DBI and DBD::Mysql modules !
Using just forks is ok , using just DBI and DBD::Myslq modules is ok ,
when I try to use both ( forks and database modules ) I get a nice
Windows error “ This Program has performed
Hi!
I am
running Windows98 and ActiveState Perl 5.6.1! I am trying to use forks
and DBI and DBD::Mysql modules !
Using
just forks is ok , using just DBI and DBD::Myslq modules
is ok , when I try to use both ( forks and database modules ) I get a nice
Windows error This Program ha
47 matches
Mail list logo
