Re: DBIx::Recordset struggles to pass tests

2003-11-11 Thread Jeff Zucker
Terrence Brannon wrote: . There's no free version of Oracle for Windows is there? I run Cygwin. Actually there is a free version for personal use on windows: http://otn.oracle.com/software/products/8i_personal/index.html

Re: DBIx::Recordset struggles to pass tests

2003-11-11 Thread Terrence Brannon
Michael Gray wrote: Hs anyone had any luck getting DBIx::Recordset to pass its tests using recent versions of perl, DBI and DBD::Oracle? Angus Lees and myself have several patches for Recordset, most are archived in the embperl mailing list. Gerald was supposed to have a subversion repositor

Re: Fw: Compile of DBD Solid

2003-11-11 Thread Joe Slagel
[EMAIL PROTECTED] wrote: > The libsolodbc.so file was created with a link to file that was in the tar > ball : soch1x30fe.sl. Someone else who did get this to compile stated > that the soft link was needed to compile the DBD. > > I thought the below may have something to do with the type of fi

Re: SQL_IDENTIFIER_QUOTE_CHAR and DBD::mysql

2003-11-11 Thread Ron Savage
On Tue, 11 Nov 2003 15:41:13 -0800, Jeff Zucker wrote: Hi Jeff OK. Thanx for the clarification. -- Cheers Ron Savage, [EMAIL PROTECTED] on 12/11/2003 http://savage.net.au/index.html

Re: SQL_IDENTIFIER_QUOTE_CHAR and DBD::mysql

2003-11-11 Thread Jeff Zucker
Ron Savage wrote: Further news on SQL_IDENTIFIER_QUOTE_CHAR. When you call $dbh -> get_info(29) V 2.1026 V 2.9003 undef ` (backtick) Although, if the mysqld is started with --ansi, double quotes are accepted as SQL_IDENTIFIER_QUOTE_CHAR in addition to backticks. Similarly,

Re: [perl #24463] DBI tests fail with perl 5.8.2 and -Duseithreads -Dusemultiplicity -Duse64bitint

2003-11-11 Thread Tim Bunce
On Mon, Nov 10, 2003 at 11:10:06PM -, [EMAIL PROTECTED] (via RT) wrote: > > DBI 1.38 (and probably other versions) fail tests on a perl 5.8.2 > configured with -Duseithreads -Dusemultiplicity -Duse64bitint > > t/05thrclone...Usage: DBI::_clone_dbis() at t/05thrclone.t line 32. > # Loo

SQL_IDENTIFIER_QUOTE_CHAR and DBD::mysql

2003-11-11 Thread Ron Savage
Hi Folks Further news on SQL_IDENTIFIER_QUOTE_CHAR. When you call $dbh -> get_info(29) (Yes it's all documented in DBI.pm) here are the results returned for DBD::mysql: V 2.1026 V 2.9003 undef ` (backtick) I found this out when Compress::ZLib failed to install, but in doing to mana

Re: nmaking dbd-mysql errors

2003-11-11 Thread Ron Savage
On Sun, 9 Nov 2003 14:56:28 -0800, Howard Fuchs wrote: Hi Howard > Please see snippet below. Perhaps someone could advise me where to > go from here? > > OS is Win2K Use ppm. Set your location to: http://theoryx5.uwinnipeg.ca/ppms/ -- Cheers Ron Savage, [EMAIL PROTECTED] on 12/11/2003 http://s

Re: Oracle dbi ?

2003-11-11 Thread Michael A Chase
On Tue, 11 Nov 2003 07:44:16 -0800 Kevin Moore <[EMAIL PROTECTED]> wrote: > Since I've got no experience with OCI and not much play time right > now I'm going to ask this question. Can you execute a command line > shell script using OCI? If so there is no reason you cannot invoke > sqlplus and sta

Re: Compile of DBD Solid

2003-11-11 Thread Tim Bunce
On Tue, Nov 11, 2003 at 11:53:00AM -0700, Jim Cromie wrote: > [EMAIL PROTECTED] wrote: > > >Here is the error I am getting when I run the make: > > > ># make . > > > >In file included from Solid.h:57, > >from Solid.xs:7: > >/usr/solid/include/sqlext.h:398: warning: `SQL_INTERVA

Fw: Compile of DBD Solid

2003-11-11 Thread Patricia . Markiewicz
The libsolodbc.so file was created with a link to file that was in the tar ball : soch1x30fe.sl. Someone else who did get this to compile stated that the soft link was needed to compile the DBD. I thought the below may have something to do with the type of file since it seemed to be the

Re: Compile of DBD Solid

2003-11-11 Thread Jim Cromie
[EMAIL PROTECTED] wrote: Here is the error I am getting when I run the make: # make . In file included from Solid.h:57, from Solid.xs:7: /usr/solid/include/sqlext.h:398: warning: `SQL_INTERVAL_YEAR' redefined /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/dbi_sql.

Re: Aqua Data Studio?

2003-11-11 Thread Tim Bunce
On Tue, Nov 11, 2003 at 12:15:25PM -0500, Thomas A. Lowery wrote: > We've been reviewing ADS at work. Other than it's not open source, Ah. I saw it on freshmeat.net. I wish they flagged non open source projects more loudly. Oh well. Thanks. Tim.

Re: DBI::Shell producing errors during test on RedHat 9

2003-11-11 Thread Thomas A. Lowery
Thanks. This problem seems to have re-appeared with perl 5.8.0. If anyone has a suggestion and/or solution please let me know. Tom On Mon, Nov 10, 2003 at 02:39:32PM -0500, Scott R. Godin wrote: ... > PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" > "test_harness(0, 'blib/lib',

RE: Aqua Data Studio?

2003-11-11 Thread Veera Prasad
Looks like the tool is good enough to see what is there in the databases . It would be nicer if the tool allows to create new tablespaces or devices for sybase and stuff like that... -Original Message- From: Thomas A. Lowery [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 12:15

DBIx::Recordset struggles to pass tests

2003-11-11 Thread Michael Gray
Hs anyone had any luck getting DBIx::Recordset to pass its tests using recent versions of perl, DBI and DBD::Oracle? DBI 1.38 seems okay, no need to mess there. Platform is Red Hat Linux 9, but with perl built locally. Oracle client is 9.2.0.1.0. DBIx::Recordset is 0.24. I can get DBIx::Rec

Re: Aqua Data Studio?

2003-11-11 Thread Thomas A. Lowery
We've been reviewing ADS at work. Other than it's not open source, the product is solid and provides very useful features. We're considering the purchase of a few commercial licenses. Tom On Tue, Nov 11, 2003 at 02:14:11PM +, Tim Bunce wrote: > http://www.aquafold.com/ > > "Aqua Data

Re: Oracle dbi ?

2003-11-11 Thread Kevin Moore
Jared, Since I've got no experience with OCI and not much play time right now I'm going to ask this question. Can you execute a command line shell script using OCI? If so there is no reason you cannot invoke sqlplus and startup or shutdown an Oracle database. Kevin Jared Still wrote: The pro

RE: Oracle dbi ?

2003-11-11 Thread Gold, Samuel (Contractor)
I have called oracle and ask them if they would provide the shutdown functionality in OCI and there answer was no. The reason they gave was: "OCI does not provide the functionality to start and stop the database. Doing so requires access to a lower level API which is not exposed to OCI." That is

RE: Aqua Data Studio?

2003-11-11 Thread shildreth
No, but I am going to try it, thanks for the link. On 11-Nov-2003 Tim Bunce wrote: > http://www.aquafold.com/ > > "Aqua Data Studio is a database query and administration tool that > allows developers to easily create, edit, and execute SQL scripts, > as well as browse and modi

Aqua Data Studio?

2003-11-11 Thread Tim Bunce
http://www.aquafold.com/ "Aqua Data Studio is a database query and administration tool that allows developers to easily create, edit, and execute SQL scripts, as well as browse and modify database structures. Aqua Data Studio provides an integrated database environm

Re: DBD?$B!!OCI8 compilation error

2003-11-11 Thread Tim Bunce
http://www.mail-archive.com/[EMAIL PROTECTED]/msg17558.html Tim. On Tue, Nov 11, 2003 at 06:50:24PM +0900, Yasuyuki Hiramatsu wrote: > Dear everbody > > Please givi me help. > I can't install DBD::Oracle1.14, but I can't understand the cause. > > I attached command logs. > > # perl Makefile.PL

DBD$B!!(BOCI8 compilation error

2003-11-11 Thread Yasuyuki Hiramatsu
Dear everbody Please givi me help. I can't install DBD::Oracle1.14, but I can't understand the cause. I attached command logs. # perl Makefile.PL -v <<03MakePL.log>> # make <<03make.log>> # perl -V <> With my best regards Yasuyuki Hiramatsu Shionogi & CO., LTD 03MakePL.log