DBI 1.15 test warning (with patch)

2001-05-11 Thread David Dyck
On Fri, 30 Mar 2001, Tim Bunce wrote: > It gives me great pleasure to announce the arrival of DBI 1.15: When I installed this, I got the following warning during make test: t/examp.ok 103/122The stat preceding lstat() wasn't an lstat at blib/lib/DBD/ExampleP.pm line 130. Here's

RE: Problem connecting Oracle database

2001-05-11 Thread Sterin, Ilya
The TNS name for that database was never set up. tnsnames.ora file keeps that info. Since you are on wintel, you might want to try ODBC. Set up a DSN to your database and use dbi:ODBC:dsn_name convention. Ilya Sterin -Original Message- From: VIDYASAGAR R NALLU [mailto:[EMAIL PROTECTED

RE: remove me

2001-05-11 Thread Sterin, Ilya
Try [EMAIL PROTECTED] might work better. Ilya Sterin -Original Message- From: Rajanath Tadikonda [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 6:03 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: remove me Try this. To remove your address f

Re: DBI 1.15 test warning (with patch)

2001-05-11 Thread Tim Bunce
Thanks. (I'd already fixed that one, but thanks anyway.) Tim. On Fri, May 11, 2001 at 03:18:18PM -0700, David Dyck wrote: > > > > On Fri, 30 Mar 2001, Tim Bunce wrote: > > > It gives me great pleasure to announce the arrival of DBI 1.15: > > When I installed this, I got the following warnin

RE: Problem connecting Oracle database

2001-05-11 Thread McLennan,Neil [PYR]
Check your ensure that MyOraDb exists in your tnsnames.ora file or alternatively if using Oracle Names that it is in the Names database. Then check the syntax of the tnsnames.ora to make sure everything is OK and that the host name and port number for this database are correct. The ensure that

Problem connecting Oracle database

2001-05-11 Thread VIDYASAGAR R NALLU
Hi all, I wrote a program to connect to Oracle database with the following statement: my $dbh = DBI->connect("DBI:Oracle:MyOraDb","scott","tiger") or die "Error: $DBI::errstr"; but i'm ended up with the following error message: DBI->connect(MyOraDb) failed: ORA-12154: TNS: could not resolve se

Re: remove me

2001-05-11 Thread Rajanath Tadikonda
Try this. To remove your address from the list, just send a message to the address in the ``List-Unsubscribe'' header of any list message. If you haven't changed addresses since subscribing, you can also send a message to: <[EMAIL PROTECTED]> or for the digest to: <[EMAIL PROTECTED]> -

remove me

2001-05-11 Thread Bob . Wilson
Could I be removed from this email list?? I will check the archives from here on in for issues I may have. Thank you. Sincerely, Bob Wilson.

remove me

2001-05-11 Thread sara starre
can someone tell me how to get off of this list please? Thank-You. >From: Vivek Kakade <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: DBI Module.. >Date: Fri, 11 May 2001 14:43:34 -0500 > >Hi > >I am trying to use DBI module from CPAN, which is installed on Apache web >server 1.3.12, to c

RE: DBI Module..

2001-05-11 Thread Sterin, Ilya
Means that it can't find the DBI module anywhere in the @INC. Are you using mod-perl? Either way, if everything is installed well, but you installed in a non @INC directory you can use BEGIN{push(@INC, /directory/goes/here);} or use lib /directory/goes/here; use DBI; Ilya Sterin -Or

DBI Module..

2001-05-11 Thread Vivek Kakade
Hi I am trying to use DBI module from CPAN, which is installed on Apache web server 1.3.12, to connect to MySQL Database (on another server) . The Apache web server is installed on Linux. But I am constantly getting the folllowing error ... Can't locate loadable o

RE: [DBD::Oracle] Client installation on Suse

2001-05-11 Thread Sterin, Ilya
You need to install the Oracle client for Linux, from http://technet.oracle.com, to be able to compile DBD::Oracle. Ilya Steirn -Original Message- From: Nico van Leeuwen To: [EMAIL PROTECTED] Sent: 05/11/2001 12:45 PM Subject: [DBD::Oracle] Client installation on Suse Hi, I have been

[DBD::Oracle] Client installation on Suse

2001-05-11 Thread Nico van Leeuwen
Hi, I have been using DBI with Mysql for some time and am quite familiar with the module and its installation. Now I have to work with Oracle. I have installed DBD::Oracle on a machine that has the Oracle Database on it. This worked well, no problems there. However this is not what I need. I n

RE: passing an ORA_RSET into an Oracle stored procedure?

2001-05-11 Thread Eric Riggers
Thanks Tim and Michael! Yes, it seems that DBD::Oracle doesn't yet support that type of data structure. I rewrote the PL/SQL to a more conventional style and switched to standard prototyping, iterate bind_param() over all 30 fields, everything works great... -Original Message- From: Tim

RE: running php script from withing file to get variables

2001-05-11 Thread Dave VanAuken
Let me clarify (at the risk of going up in flames) prior to ending the thread. The client in question has 3 "developers" who toute thier knowledge of ASP, and are esentially using Ftontpage and other MS based apps to deliver thier web based solution. For some reason they have an inkling of PHP,

RE: Problem with DBI and Access newbie

2001-05-11 Thread Sterin, Ilya
Try updating/reinstalling windows ODBC software and possibly DBD::ODBC. Seen this error quite a few times, but never a solution, other than recommended reinstalation. Ilya Sterin -Original Message- From: Trevor Webster To: [EMAIL PROTECTED] Cc: dbi-users Sent: 05/11/2001 9:16 AM Subject:

Re: Problem with DBI and Access newbie

2001-05-11 Thread Trevor Webster
Thanks Phil for your help in this. Having implemented the suggested changes I was still getting the same error response: DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) at c:\inetpub

RE: DBI 1.5

2001-05-11 Thread Kim, Laurent
/usr/ucb/cc is just a placeholder for a compiler it's nothing more than a simple shell script. You might want to try gcc... -Original Message- From: Monahan, Brendan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 8:40 AM To: '[EMAIL PROTECTED]' Subject: DBI 1.5 I am attempting

Re: DBI 1.5

2001-05-11 Thread Mike Lacey
Brendan, Is it that you haven't bought the ANSI C compiler from Sun? On some versions of UNIX (HPUX, for instance) the cc supplied with the box is not ANSI compatible. Regards Mike Mike Lacey www.tek-tips.com -- a friendly, flame free, environment for computer professionals and students Perl

Re: Problem installing DBD-Oracle

2001-05-11 Thread Julio Santiago
You need to have BDI installed before installing DBD. if you are using ActivePerl the take advantage of the PPM. Open a MSDOS window at command prompt type >ppm install nameofthemodule Cheers Julio Santiago >From: VIDYASAGAR R NALLU <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Proble

DBI 1.5

2001-05-11 Thread Monahan, Brendan
I am attempting to run make for the DBI module after initiating the "perl Makefile.PL" command. I receive the following error from the sun solaris os see below in bold Any help is greatly appreciated Brendan Monahan VP ORACLE engineering lab12a-orcl:/app/oracle/DBI-1.15 > make

RE: running php script from withing file to get variables

2001-05-11 Thread Sterin, Ilya
>like it or not, not many do the Perl thing any more Who are you refering to by **many**. You have statistics? Perl powers more web sites/servers than any other language. You just don't hear about it as much since it's an open source technology and they don't have the money, will, and reason t

RE: running php script from withing file to get variables

2001-05-11 Thread Curt Russell Crandall
> > 2) documentation (saves me explaining PHP AND Perl:DBI in the > emergency documentation should I keel over and die tomorrow and take > the Perl:DBI knowledge with me. like it or not, not many do the Perl > thing any more) > Huh? Are you just talking about at your own shop... I know very f

Re: ODBC connects, but queries fail.

2001-05-11 Thread Jack McKinney
Big Brother tells me that Nick Gorham wrote: > > Have you tried creating a ODBC trace of what is going on, that may help (send me > a copy if you want.) Yes. There are two copies in the original email: one for isql and one for Perl/DBD::ODBC. Both show a lot of SUCCESS results. If you nee

Re: ODBC connects, but queries fail.

2001-05-11 Thread Nick Gorham
[EMAIL PROTECTED] wrote: > Big Brother tells me that Neil Lunn wrote: > > > > Umm Jack. The main point was to see if there was a difference between isql > > and DBD::ODBC. > > isql should allow you to use the same connect string that you are suppling > > to DBD::ODBC, so if you can supply a DSN'l

Re: ODBC connects, but queries fail.

2001-05-11 Thread Jack McKinney
Big Brother tells me that Neil Lunn wrote: > Actually just a thought. Is there a possibilty that iodbc was installed on > this machine. The driver manager found should have been reported by > Makefile.PL. I remeber Nick providing patches explicitly so that UnixODBC > wasn't reported as something

Re: ODBC connects, but queries fail.

2001-05-11 Thread Jack McKinney
Big Brother tells me that Neil Lunn wrote: > > I agree with Ilya, even what was published as the content from the odbc.ini > seemed a little too slim for the connection. > > ie from the UnixODBC (hope I got that right Nick!) docs. > > [Stuff Deleted] > I based my odbc.ini on this part of

Re: ODBC connects, but queries fail.

2001-05-11 Thread Jack McKinney
Big Brother tells me that Neil Lunn wrote: > > Umm Jack. The main point was to see if there was a difference between isql > and DBD::ODBC. > isql should allow you to use the same connect string that you are suppling > to DBD::ODBC, so if you can supply a DSN'less connect to isql, the same > strin

Re: ODBC connects, but queries fail.

2001-05-11 Thread Jack McKinney
Big Brother tells me that Sterin, Ilya wrote: > But what driver are you using, ODBC is a layer on top of other drivers, like > Access, SQL Server, Oracle, etc..., I don't think /usr/local/lib/odbc-i02.so > qualifies as a driver. You might want to check your ODBC documentation. Yes. It is th

Re: passing an ORA_RSET into an Oracle stored procedure?

2001-05-11 Thread Tim Bunce
On Thu, May 10, 2001 at 04:29:04PM -0700, Eric Riggers wrote: > Hi, > I'm trying to call a stored procedure that needs a "record type paramater". > I'm unclear as to how to pass the record data. The record data is a hash; I > believe i need to pass in just the values of the hash, as a flattened l

Re: passing an ORA_RSET into an Oracle stored procedure?

2001-05-11 Thread Michael A. Chase
How many arguments does proc_name() take? You need to supply a separate placeholder for each argument to the procedure. If this section in the fine manual (perldoc DBI) is not clear, please suggest alternate wording. = Also, placeholders can only represent single scalar values. For example,