Hi all,
I'm using PERL and a PERL module called DBI and a sub module called
DBD::ODBC
I'm using Windows 2000 Server, and FileMaker Pro 5 v3
Under the command prompt (logged in as myself) I can connect and pull
and print data out on the DOS shell. However, when I run the script
under the web it
Dong,
I think you're mixing apples and oranges. You can get a local connection
(avoid sqlnet and the listener) in 2 ways (that I know of):
1) $dbh = DBI->connect("dbi:Oracle:",$userid,$passwd);
2) define and entry in your tnsnames.ora like (*note my ORACLE_SID=o817):
LOCAL.world =
(DESCRIPT
BDY.RTF
Description: RTF file
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Wolfgang Weisselberg) wrote:
> > Hi, I am new to this newsgroup, so I hope this is not a bad question.
>
> It's a good question, but I thought it was a mailing list :-)
actually it's both.. point your news reader at nntp://nntp.perl.org
:)
-
I recommend you examine DBI::AnyData as a means toward "support multiple
repositories for
SQL" (like XML, tab delimited, RDBMS).
Good luck...
-Original Message-
From: Jason W May [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 15, 2001 8:52 PM
To: Terrence Brannon; [EMAIL PROTECTED]
[ redirected to dbi-users ]
Sonia Lodovichetti (LMC) writes:
>
> I'm having problems catching the error and error message sent
> by a database trigger using raiserror.
I did a quick test with a simple insert trigger, and I did get the
error in the client.
> Here is my code:
>
>
>
Many thanks to Tim, Scott, and everyone else on the mailing list for helping
me with this!! Figuring this out really made my day.
Becka
>From: Tim Bunce <[EMAIL PROTECTED]>
>To: Becka Louden <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: inserting into CLOB field
>Date: Fri, 16 Nov
...or I could be wrong :-)
> Your DBD::Oracle is built using the Oracle7 OCI API, it doesn't
> know about LOBS.
>
> Tim.
On 16-Nov-01 Scott T. Hildreth wrote:
> Versions do matter, I believe CLOB was fixed in DBD::Oracle 1.09.
> I had emailed Becka yesterday to try the new versions.
>
--
The trouble with the perl I'm using is that it is supplied with the server
OS, as is, by Bull.
This may or may not make a difference.
I very much doubt that it was compiled on this specific server.
The DBI/DBD libraries were compiled on this server by myself.
I do have the same problme with fet
Your DBD::Oracle is built using the Oracle7 OCI API, it doesn't
know about LOBS.
Tim.
On Thu, Nov 15, 2001 at 09:00:16PM +, Becka Louden wrote:
> Hi, I am new to this newsgroup, so I hope this is not a bad question.
>
> I trying to use the Perl::DBI to insert a string value into the Oracle
Versions do matter, I believe CLOB was fixed in DBD::Oracle 1.09.
I had emailed Becka yesterday to try the new versions.
Two things:
1) Wolfgang asked that if table "crr" is a synonym, then try
using the real table name instead
2) Your DBI and DBD::Oracle versions are not current - this
shouldn't(?) matter, but if you can I would try upgrading
those to the recent versions.
DBI - now at version 1
On Fri, Nov 16, 2001 at 12:08:14 -, Mark Buckle wrote:
> From: Mark Buckle [mailto:[EMAIL PROTECTED]]
> > I'm getting this error, presumably from perl itself :-
> > Out of memory!
> The query I am running here should only return a single row,
> so it can't be a genuine out of memory error (
Record update in the PAUSE modules database:
modid: [DBI]
statd: [M] was [a]
stats: [m]
statl: [c]
stati: [O]
statp: [p] was [?]
description: [Generic Database Interface (see DBD modules)]
userid: [DBIML]
chapterid: [ 7]
mlstatus: [list]
Da
Followup
The query I am running here should only return a single row,
so it can't be a genuine out of memory error (I've tested the query in isql)
Mark.
-Original Message-
From: Mark Buckle [mailto:[EMAIL PROTECTED]]
Sent: 16 November 2001 12:04
To: '[EMAIL PROTECTED]'
Subject: Out of me
DBI version 1.20
DBD::Ingres 0.30
on AIX 4.3
I'm getting this error, presumably from perl itself :-
Out of memory!
and things seem to die immediately.
Has anyone seen anything like this before.
Cheers, Mark.
> Mark Buckle, Database Administrator, Implementation - Intech Solutions
> DDI: 01
Hallo,
I am working with Mysql-DB and tables with BLOB-field. Users can put
Images into DB with a formular. I want a picture-manipulation with GD
(Copyright-information in every picturefile)
I have written a subroutine but its not working correct.
##
On Thu, Nov 15, 2001 at 21:00:16 +, Becka Louden wrote:
> Hi, I am new to this newsgroup, so I hope this is not a bad question.
It's a good question, but I thought it was a mailing list :-)
> I trying to use the Perl::DBI to insert a string value into the Oracle
> database. However, I get
On Thursday 15 November 2001 08:31 am, Terrence Brannon wrote:
> On Wednesday, November 14, 2001, at 10:33 PM, Jason W May wrote:
> > The implementation provided by DBIx::Librarian is sufficiently
> > different from other related modules (in particular, SQL::Catalog)
> > that this modu
19 matches
Mail list logo
