Hello Guru,
I am web programmer using PERL, MySQL.
I need help from you, could you please clarify my doubt?
1. How many methods or functions in PERL-DBI/DBD module
will actually will get communicates with MySQL?
I know one that's $sth-fecth() or $sth-fetchArrayref() after
Adam,
I asked this question about4 months ago and I never got a response.
So, I will ask again.
Using DBD::XBase, when I create tables with floating point columns,
the table has the numbers with the the decimals truncated. I have
created the file using the following command
Jeff, perhaps I have misunderstood what is going on here but it is my
impression that DBD-ODBC is being built against propriety interfaces that look
like an ODBC API library but in fact will only communicate with a specific
DBMS. One such example is SAP-DB.
If this propriety build of DBD-ODBC
Yes Oliver, this is my understanding of the issue. As long as we're
talking specfics, this is a ODBC API for RedBrick, an IBM product
formerly Informix (no DBD-Infomix isn't for the DBMS). I actually
did try iODBC first, but was unsuccessful. Upon asking on the
RedBrick list I was
Hello,
I have to install DBD/DBI modules on a sun machine. I downloaded all I needed on the
Tim Bruce FTP site or something like this. My Perl version is 5.00503 and DBI is 1.20
and DBD is 1.12
I un-gzip, un-tar, launch the command perl Makefile.PL and until here everything is
OK. But when I
Hi guys,
I am writing a Perl program that utilises DBI to perform SQL select
statements to extract information from the database and write them to a
file.
If the database goes down during the process of executing of the SELECT
statements and writing to the file, what happens ?
Does anything
I've tried building DBI-1.20 on NT with VC++ 5, and come up with the
following error (I've mapped copy to cp BTW) :-
$ perl Makefile.PL
*** You are using a perl with experimental threading enabled!
*** You should be aware that using multiple threads is unstable
*** are should NOT be done in
Hi
You can use Exception Handling. the execute statement can be
placed between eval operater
ex::
$sql = INSERT INTO TABLE VALUES(?,?);
$db-prepare($sql);
foreach $ctr(0..$#arr){
eval{
Ho, Tony wrote:
If the database goes down during the process of executing of the SELECT
statements and writing to the file, what happens ?
Make sure that the RaiseError attribute is on for the DBI handle your working
on {RaiseError = 1}. Then execute the SELECT statemts within an eval{} block
-Original Message-
From: Mark Buckle
Sent: 04 February 2002 13:41
To: 'Berger, Daniel'; 'tzonekev'; [EMAIL PROTECTED]
Subject: RE: ActivePerl DBI - can't build DBI1.20
I've tried building DBI-1.20 on NT with VC++ 5, and come up with the
following error (I've mapped copy to cp BTW)
Hi Guys
I've just created a PPM of DBI 1.20. I compiled the code against ActiveState
build 630 using VC++ 6. No problems encountered.
I've done MINOR testing here and the module installs and works so far OK. If
anyone one wants the PPM then let me know (if too many people want it I'll chuck
it
You shouldn't try to build it, just use PPM to install. In command line...
ppm install http://www17.addr.com/~xmlproj/PPM/DBI-1.20.ppd
This would install.
It used to be on www.xmlproj.com, but I'm undergoing a host change, so the
DSN is all screwed up. It should be up in a few days.
Ilya
There is already one on my site, as with DBD::Oracle, etc...
Ilya
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 2/4/02 7:30 AM
Subject: RE: ActivePerl DBI - can't build DBI1.20
Hi Guys
I've just created a PPM of DBI 1.20. I compiled the code against
Perhaps, not, but then I definitely am going to have to try and build
DBD-Ingres, for which there is no PPM module, not even and out of date one .
:-) .
Mark.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: 04 February 2002 15:37
To: 'Mark Buckle '; ''[EMAIL
What OS are you using?
You must also use the same compiler used to compile your Perl.
Ilya
-Original Message-
From: projet gesfi
To: [EMAIL PROTECTED]
Sent: 2/4/02 6:20 AM
Subject: DBI install problem
Hello,
I have to install DBD/DBI modules on a sun machine. I downloaded all I
Definitely, we need more PPMs, since the ActiveState folks are not updating
their stuff:-(
Ilya
-Original Message-
From: Mark Buckle
To: Sterin, Ilya; ''[EMAIL PROTECTED]' '
Sent: 2/4/02 8:36 AM
Subject: RE: ActivePerl DBI - can't build DBI1.20 - and wheres DBD-Ingre s
?
Perhaps,
Simon,
Yes, I understand what you are saying. I hope this will clear it up a bit.
DBD::ODBC *allows* you to build against the proprietary databases. I can
see why some like it, because it's easier to be setup. Yes, it should
probably change it's name to DBD::SAPDB, etc. I'll have to think
Drew,
I think you'd be better off with unixODBC or iODBC and getting the driver
manager to work. It will be better in the long run to get that straight,
then finding out you need to upgrade and having to do the work over again.
Jeff
-Original Message-
From: drewhead [mailto:[EMAIL
It is Solaris 8. And I'm not sure, but I think perl was already compiled...
How can compilation interfer with perl compilation ?
- Original Message -
From: Sterin, Ilya [EMAIL PROTECTED]
To: 'projet gesfi ' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, February 04, 2002 4:40 PM
New features:
work around SQL Server 2000 bug where a column named C (in my tests) creates
havoc for SQLDescribeParam. Changed column names on all test columns to ensure this
does not cause a problem.
Now, the new use of SQLDescribeParam works out of the box for SQL Server
Nick Gorham wrote:
drewhead wrote:
Yes Oliver, this is my understanding of the issue. As long as we're
talking specfics, this is a ODBC API for RedBrick, an IBM product
formerly Informix (no DBD-Infomix isn't for the DBMS). I actually
did try iODBC first, but was unsuccessful. Upon
On Mon, Feb 04, 2002 at 11:05:32AM -0500, Jeff Urlwin wrote:
Simon,
Yes, I understand what you are saying. I hope this will clear it up a bit.
DBD::ODBC *allows* you to build against the proprietary databases. I can
see why some like it, because it's easier to be setup. Yes, it should
Revamped tests to include tests for multiple result sets.
The tests are ODBC driver platform specific and will be skipped
for drivers which do not support multiple result sets.
The uploaded file
DBD-ODBC-0.33_3.tar.gz
has entered CPAN as
file:
Using DBI how do you explicitly start a transaction?
I wish to explicitly 'begin work' to avoid the merging
of separate transactions.
DBI 1.13
Postgres 7.1
Perl 5.005
rob Live the dream.
- Original Message -
From: Rob Ransbottom [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 04, 2002 6:05 AM
Subject: beginning work with DBI
Using DBI how do you explicitly start a transaction?
I wish to explicitly 'begin work' to avoid the merging
of separate
On Mon, 4 Feb 2002, Rob Ransbottom wrote:
Using DBI how do you explicitly start a transaction?
I wish to explicitly 'begin work' to avoid the merging
of separate transactions.
DBI 1.13
Postgres 7.1
Perl 5.005
You should turn AutoCommit off when you create the database handle. Tehn
you
We had a system with Oracle 7.3.4. for Peoplesoft and 7.3.4.4 for our
ERP system (3 Oracle system in ERP). I had DBI-1.2 and DBD-Orace 1.12
working fine on the ERP systems. The program in question contacted the
Peoplesoft system to get HR data for new user creation on the ERP
systems. Recently
The only version of Oracle that matters to a DBI/DBD::Oracle script is the
version of Oracle it was compiled against. Connections to the databases
should go through SQL*Net.
Make sure the session that the DBI script is running in has ORACLE_HOME,
LD_LIBRARY_PATH (if applicable) and other
Using SunOS 5.7 Generic_106541-19 sun4u sparc SUNW,Ultra-2
Using DBI 1.201
Using perl, v5.6.1
Using gcc version 3.0.3
Using cc: WorkShop Compilers 4.2
PATH=/usr/bin:/opt/SUNWspro/bin:/usr/ccs/bin:/usr/ucb:/etc/usr/local/bin:.:/app/oracle/product/8.1.6/bin:
Error text -
If you need to pursue that further here, a snippet of code that demonstrates
the problem along with the exact values in $DBI::errstr and $DBI::err at the
point of failure are necessary. The trace log from DBI-trace(2) might also
help.
--
Mac :})
** I normally forward private questions to the
Hello all,
I am having difficulty connecting to Oracle with DBI. Here is the
background info. I am running Windows 2000 client and server. I am able to
connect fine to the oracle database via sqlplus. A tnsping also comes back
with the proper info. The oracle database also shows up fine
What's in PATH?
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.htm
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
- Original Message -
I found my error, there was a statement setting ORACLE_HOME where it did
not belong. I must have looked past it a dozen times. Thanks for the
help.
On Mon, 2002-02-04 at 16:29, Michael A Chase wrote:
If you need to pursue that further here, a snippet of code that demonstrates
the problem
I knew I would leave out an obvious piece of information...
My path includes c:\oracle\ora9\bin
JF
-Original Message-
From: Michael A Chase
To: Fisher, James; [EMAIL PROTECTED]
Sent: 2/4/02 5:52 PM
Subject: Re: Oracle DBD connection problem...
What's in PATH?
--
Mac :})
** I normally
Do you specify the instance when you connect via SQL*Plus
(Connect/password@mydb)? If not, try SQL*Plus again that way. If that
doesn't work, the problem may be in the tnsname.ora entry.
That '.dA.?A°w' at the front of $DBI::errstr seems rather odd. So is the
value 0 in $DBI::err.
Try
35 matches
Mail list logo