Yes, synonyms are very much like views.
Attached is a hacky diff to do synonyms (but not links).
I can't do links here, so I can't test it.
We have Kerberos here and I couldn't figure out how to
properly support a user schema like "[EMAIL PROTECTED]"
Assuming these are merged together, I don't k
Tim Bunce wrote:
>
> On Wed, Apr 11, 2001 at 05:42:03PM -0500, Mark Stosberg wrote:
> > Tim Bunce wrote:
> > >
> > > I suspect you're not really using the version you think you are.
> > > Add warn $DBI::VERSON to the code.
> >
> > I suspected that, too. I verified that it's 1.15. (I ran it in the
Some body can Help ME?
Tanks in Advance
prueba.pl
I suspect you're not really using the version you think you are.
Add warn $DBI::VERSON to the code.
Tim.
On Wed, Apr 11, 2001 at 04:37:38PM -0500, Mark Stosberg wrote:
>
> Hello,
>
> I'm now using and enjoying the new features of DBI 1.15 (Thanks
> everyone!). I have an odd issue with the ne
Sherry, it's your lucky day.
Thanks to John's message I found the patch that Tom Moore sent me
(thanks Tom). It only applies to views but it should be fairly obvious
how to extend it to synonyms (or you could just setup a view that
refers to the synonym).
Volunteers are most welcome to polish up
It's a bug. I can't remember how non-trivial it is to fix, but I'll
certainly be taking a look at it wen I next work on DBD::Oracle.
Tim.
On Wed, Apr 11, 2001 at 03:02:47PM -0400, Sherry Y. Cui wrote:
> Hi,
>
> I need your big help...
>
> The application we are developing for our client is wri
I'll take a look when I get to DBD::Oracle again. Which I'll do after I
get DBI 1.16 out the door. Which I may do this week or next.
Thanks for the clear report.
Tim.
On Tue, Apr 10, 2001 at 09:38:59PM -0500, Stephen Clouse wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> I sent an
Well spotted (that one particular test simply calls die() if it fails).
Fixed in the next release. Meanwhile: don't do that :)
Thanks!
Tim.
On Tue, Apr 10, 2001 at 03:44:02PM -0400, Belinda M. Giardine wrote:
> DBI 1.14
> DBD::Oracle ?
> Oracle 8.0.5
>
> Setting RaiseError to 0 doesn't seem to
"Brett W. McCoy" wrote:
>
> On Wed, 11 Apr 2001, Baxter, Lincoln wrote:
>
> > What are you selecting from? I do not think your select is valid SQL.
>
> Actually, for PostgreSQL, it is a valid statement -- CURRENT_DATE is a
> global variable that always holds the current date. This SQL stateme
On Wed, 11 Apr 2001, Baxter, Lincoln wrote:
> What are you selecting from? I do not think your select is valid SQL.
Actually, for PostgreSQL, it is a valid statement -- CURRENT_DATE is a
global variable that always holds the current date. This SQL statement
should return a single row with 4-11
CURRENT_DATE is a constant in postgres. The select
is valid.
On Wed, Apr 11, 2001 at 05:42:58PM -0400, Baxter, Lincoln wrote:
> What are you selecting from? I do not think your select is valid SQL.
>
> -Original Message-
> From: Mark Stosberg [mailto:[EMAIL PROTECTED]]
> Sent: Wednes
What are you selecting from? I do not think your select is valid SQL.
-Original Message-
From: Mark Stosberg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 5:38 PM
To: [EMAIL PROTECTED]
Subject: can't find selectrow_hashref
Hello,
I'm now using and enjoying the new feat
Hello,
I'm now using and enjoying the new features of DBI 1.15 (Thanks
everyone!). I have an odd issue with the new method selectrow_hashref.
When I to use it, I get the error:
test.cgi: Can't locate object method "selectrow_hashref" via package "DBI
::db" at test.cgi line 32,
I've verifed
hi all,
I have an error installing DBD::Oracle driver
Sun 5.7
DBI 1.14
perl 5.005xx
trying to install, DBD::Oracle 1.06
any thoughts? Thanks in advance! the error looks like
-
install_driver(Oracle) failed: Can't load '/
Hello folks,
I am having a problem that has been reported several times on this list.
I have RTFMed in detail and read through all the the posts on the
DBI-users mailing list archives. But havent found any suggestions or
things to try.
When I get the following error when I run 'make test' for D
You're sharing $sth -- create one for each query instead
(e.g., $sth1 and $sth2).
Each statement being executed at the same time needs its
own handle.
Steve Sapovits
Global Sports Interactive
Work Email: [EMAIL PROTECTED]
Home Email: [EMAIL PROTECTED]
Work Phone: 610-491-7087
Cell:
Either add "{RaiseErrors => 1}" to the connect() or "$dbh -> {RaiseErrors} =
1;" somewhere before your eval{}.
--
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
Hello,
I am trying to use the eval {...} function to do a non-select database
action, then checking the $@ to see if I get an error. If there is an error
then I write a message out to a log file. I have had this work in an earlier
version of DB!.
My current environment is: Solaris 2.8, Oracle 8.
Hi,
I need your big help...
The application we are developing for our client is written in Perl. The
Perl script:
1. Upload image from client
2. Insert the image into Oracle Database xxx SYNONYM yyy BLOB column through
DBi/DBD
There is no error message from the Web Server, there is no complai
On Wed, Apr 11, 2001 at 06:09:09PM +0100, Tim Bunce wrote:
> - Forwarded message from Scanman 20 <[EMAIL PROTECTED]> -
>
> From: Scanman 20 <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: nesting queries?
> Date: Wed, 11 Apr 2001 09:50:28 -0400
> I posed this question to alt.perl
- Forwarded message from Scanman 20 <[EMAIL PROTECTED]> -
X-Originating-IP: [12.126.209.38]
From: Scanman 20 <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: nesting queries?
Date: Wed, 11 Apr 2001 09:50:28 -0400
X-OriginalArrivalTime: 11 Apr 2001 13:50:28.0769 (UTC)
Hi, Any thoughts on this problem...Thanks
-Prasanna
My DBI installation went well. During the 'make test' stage of the DBD::Oracle
installation I am getting an error like this...
-
Sun 5.7
DBI 1.14
---
I tryied again... using DBI too And the problem continues.
- Original Message -
From: "Sterin, Ilya" <[EMAIL PROTECTED]>
To: "'Roberto Slepetys Ferreira '" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 2:08 PM
Subject: RE: PERLCC a
You must use DBI.
Ilya Sterin
-Original Message-
From: Roberto Slepetys Ferreira
To: Sterin, Ilya; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 4/11/01 10:39 AM
Subject: Re: PERLCC and DBI
Hi Sterin,
The problem continues...
I changed the use part to use DBD:mysql - that works fine in
Hi Ronnald,
In fact the error was older than the change. That is: I put the use DBI with
the same error, put use DBD:mysql with the same error, put both and the
error persists...
And the most strange of all:
When I compile through script like:
perl -I/usr/local/lib/perl5/site_perl/5.6.1/i686-l
On Wed, Apr 11, 2001 at 07:53:03PM +0300, N Sikkandar Dulkarnai wrote:
> # echo $ORACLE_HOME
> /data1/u01/app/oracle/product/8.1.5
>
> I added the below line into httpd.conf file under Apacheroot/conf
>
> SetEnv ORACLE_HOME=/data1/u01/app/oracle/product/8.1.5
>
> Is it correct ???
Dunno. It do
On Wed, 11 Apr 2001 13:39:58 -0300, "Roberto Slepetys Ferreira"
<[EMAIL PROTECTED]> wrote:
>>Can't locate object method "connect" via package "DBI" (perhaps you forgot
>>to load "DBI"?) at teste.pl line 9.
>>
>>The script is writen below:
>>
>>#!/usr/bin/perl
>>
>>use CGI qw(:standard);
>>use D
On Wed, Apr 11, 2001 at 01:39:58PM -0300, Roberto Slepetys Ferreira wrote:
> I changed the use part to use DBD:mysql - that works fine in perl, but
> continues to give-me an error with perlcc as below:
>
> Can't locate object method "connect" via package "DBI" (perhaps you forgot
> to load "DBI"
# echo $ORACLE_HOME
/data1/u01/app/oracle/product/8.1.5
I added the below line into httpd.conf file under Apacheroot/conf
SetEnv ORACLE_HOME=/data1/u01/app/oracle/product/8.1.5
Is it correct ???
Thanks
Sikkandar
- Original Message -
From: "Tommy Wareing" <[EMAIL PROTECTED]>
To: <[EMA
Hi Sterin,
The problem continues...
I changed the use part to use DBD:mysql - that works fine in perl, but
continues to give-me an error with perlcc as below:
Can't locate object method "connect" via package "DBI" (perhaps you forgot
to load "DBI"?) at teste.pl line 9.
The script is writen belo
Yes, unsubscribe him.
That would be an appropriate action.
It has been continuing for at least a few days now.
They can always re-subscribe.
-Original Message-
From: Tommy Wareing [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 12:08 PM
To: '[EMAIL PROTECTED]'
Subject: Re: List
Well that is you problem. The linker was not found. You have not
completely set up your env. Did you set up by hand? Or used the VCVARS.bat
or something like that that is included which will set it up for you?
Ilya Sterin
-Original Message-
From: Reuss, Bob
To: '[EMAIL PROTECTED] '
It was not just you.
If you look at the headers on the bounced messages, the actual subscriber
was forwarding to webdeveloper2000 which apparently was over its quota. I
don't think I've received a bounce from the last couple messages I've sent,
so the offending account has probably been removed
I did clean off all the directories that were created. Was there anything
special I need to do to completely clean everything? The answer to the
other question I do have DBI 1.13 installed. I did notice that when running
the makefile, one of the messages that was popped up was:
Linker:
Che
On Wed, Apr 11, 2001 at 09:59:56AM -0600, Sterin, Ilya wrote:
> Have you guys been receiving "Returned mail notification" from
> [EMAIL PROTECTED] address?
Yup, and I'll have just got another one :(
> Should [EMAIL PROTECTED] be unsubscibed from the list.
Dunno.
> Is that mail bouncing back to
Have you guys been receiving "Returned mail notification" from
[EMAIL PROTECTED] address? Everytime I send anything to
[EMAIL PROTECTED] I receive this back. Should [EMAIL PROTECTED]
be unsubscibed from the list. Is that mail bouncing back to just me?
Ilya Sterin
Just to make sure, did you clean everything up after your previous attemps?
Then do you already have DBI installed?
Then run
>perl Makefile.PL
>nmake
>nmake test
>nmake install
>nmake clean
Ilya Sterin
-Original Message-
From: Reuss, Bob
To: [EMAIL PROTECTED]
Sent: 4/11/01 9:52 AM
Subj
Ok, I was able to install Visual studio and set up my path to the cl.exe
file. I ran the makefile again and it began compiling but I ended up with
another fatal error. Below is the error.
Microsoft (R) Program Maintenance Utility Version 1.50
Copyright (c) Microsoft Corp 1988-94. All rights
Mysql server? or DBD::mysql?
Either way we need more info, like the error you are getting and where is
the installation from, your complete environment, etc...
Ilya Sterin
-Original Message-
From: Paul Castiglione
To: [EMAIL PROTECTED]
Sent: 4/11/01 8:45 AM
Subject: Install MySQL
Hello
You don't have to use any of these, but if you would DBD::Mysql would be the
correct one. You must only use DBI and then specify the driver in the
connect statement. You might want to try to also use DBD::Mysql since due
to compilation procedures, it might not be loading the DBD's during
compili
Hello all
I am having trouble install MySQL on my windows 98 machine I follow the step in
the readme but I can not get MySQL to come up. What am I doing wrong?
Paul
Hi Thomas,
I tryied the use mysql, use DBD::mysql, use DBI::mysql without sucess.
The DBD::mysql runs ok in the perl interpreted code, the others give me an
error like:
Can't locate DBI/mysql.pm in @INC
Could you pass me the exactly use sintax ?
Thanks a lot !!
[]s
Slepetys
- Orig
Has anyone here ever used Perl to access an SMS Allegra database? If
you have experience with SMS Allegra but you didn't use Perl, please
drop me a note at [EMAIL PROTECTED]
Thanks,
Phil R Lawrence
On Wed, Apr 11, 2001 at 04:22:55PM +0300, N Sikkandar Dulkarnai wrote:
> Yah, I configured and that error has been fixed, but still the below error
> ...
>
> DBI->connect(test) failed: Error while trying to retrieve text for error
> ORA-12154 (DBD ERROR:
> OCIServerAttach) at /usr/local/apache/cg
Yah, I configured and that error has been fixed, but still the below error
...
DBI->connect(test) failed: Error while trying to retrieve text for error
ORA-12154 (DBD ERROR:
OCIServerAttach) at /usr/local/apache/cgi-bin/test.pl line 11
cannot connect at /usr/local/apache/cgi-bin/test.pl line 11.
set the ORACLE_HOME in your httpd.conf (apache conf file)
SetEnv ORACLE_HOME=/u/app/
--
Martin Hesse[EMAIL PROTECTED]
nova ratio AG
Ransbach-Baumbach
Germany
[EMAIL PROTECTED]
Tel. : 02623 92420
Fax. : 02623 9242100
The information contained in this e-mail and any attachments is s
ERROR:
ORACLE_HOME environment variable not set!
DBI->connect(test) failed: Error while trying to retrieve text for error
ORA-12154 (DBD ERROR:
OCIServerAttach) at /usr/local/apache/cgi-bin/test.pl line 8
cannot connect at /usr/local/apache/cgi-bin/test.pl line 8.
- Original Message -
Fr
Dear Friends,
I am new to perl/cgi and trying to do the following :
I have installed Apache 1.3.19 webserver on Solaris 2.6 machine. What I am trying to
do is, to get the input in web browser and pass this input to Oracle-SQL, get back the
result to the browser. I am trying the below scripts,
Assuming you are using Domino.We had the same problem
If the data is just a view in the database you could try using agents to display the
information as XML and then use perl-XML parser to process the information. The
Solaris machine would get the web page which calls the agent with parameter
Roberto,
It was my message. Like I said many hands on much work.
If you deparately need conenctivity to Progress at least for development
work you may want to look at:
http://www.openlinksw.com
There are some pretty flexible ODBC connection options for just about any
platform.
-Original M
50 matches
Mail list logo