On Fri, 18 Oct 2002 13:30:52 -0600 Greg Baumgartel <[EMAIL PROTECTED]> wrote:
> Made some headway, it does look like something with the Oracle install.
> Basically, the ORA_NLSXX (32 or 33, depending on the original DB version)
> environment variable needs to be set to
> $ORACLE_HOME/ocommon/nls
On 10/18/02 at 1:56 PM, [EMAIL PROTECTED] (Hastie, Christa)
wrote:
> Have you tried just doing something like:
> $dbh->do("CREATE TABLE tablename") or die "ERROR:" . $dbh->errstr;
>
> I think that would work :)
> Let me know...
>
Yes Christa, something like that will work fine. But I'm looking t
On 10/18/02 at 2:43 PM, [EMAIL PROTECTED] (Jeff Zucker) wrote:
> Andrew Brosnan wrote:
>
> Did you try it? This works for me (notice there's no database
specified
> in the connection):
>
> my $dbh = DBI->connect("dbi:mysql:");
> $dbh->do("CREATE DATABASE $new_db");
> $dbh->do("USE $new_d
On 10/18/02 at 4:26 PM, [EMAIL PROTECTED] (Hardy Merrill) wrote:
> What database are you using?
Not sure why it would matter, but MySQL. I'm not talking about
installing a db program here; just exectuing some SQL like I might from
the shell:
CREATE DATABASE DatabaseName;
> Have you installed t
What database are you using? Have you installed the DBI module
and the DBD module for your database? Since you referred to
"datasource", I'm guessing you're on a Windows platform - is that
right?
Some more info would be helpful.
--
Hardy Merrill
Senior Software Engineer
Red Hat, Inc.
Andrew
On 10/18/02 at 2:10 PM, [EMAIL PROTECTED] (Jeff Zucker) wrote:
> Andrew Brosnan wrote:
>
> > On 10/18/02 at 4:26 PM, [EMAIL PROTECTED] (Hardy Merrill) wrote:
> >
> >>What database are you using?
> >>
> > Not sure why it would matter, but MySQL.
>
>
> Yes it matters. This works for me using
Andrew Brosnan wrote:
On 10/18/02 at 4:26 PM, [EMAIL PROTECTED] (Hardy Merrill) wrote:
What database are you using?
Not sure why it would matter, but MySQL.
Yes it matters. This works for me using MySQL:
my $existing_db = $your_old_db_here;
my $new_db = $your_new_db_here;
my
Andrew Brosnan wrote:
On 10/18/02 at 2:10 PM, [EMAIL PROTECTED] (Jeff Zucker) wrote:
> ...
> Yes Jeff, I thought the same thing. But that won't work for me in this
> case. I need to be able to create a new db without assuming that there
> is an existing one (or at least I might not know what it
Wow, thanks Christa. Excellent idea, (and a very thorough response!) The
only problems is it limits things to MySQL. I was hoping the code could
be database independent (excepting of course the driver)
This is great. Such timely feedback late on a Friday! This is my first
post on this list...Thank
What about $dbh->do() ?
Brian McCain
PageMasters Internet Group
- Original Message -
From: "Andrew Brosnan" <[EMAIL PROTECTED]>
To: "Post" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, October 18, 2002 12:24 PM
Subject: Create database
| Hello List,
|
| I'm looking to *create
I don't know why the disconnects wouldn't happen since I am calling
dbh->disconnect(). I should check out the number at whicgh it stopped
though. The ODBC manager from OpenLink is supposed to be for unlimited
connections. I'd like to know if that limit is being reached.
Pete
-Original Messag
Andrew Brosnan wrote:
I was hoping the code could
be database independent (excepting of course the driver)
CREATE DATABASE is not part of either SQL92 or SQL99. They have a
CREATE SCHEMA syntax. But, AFAIK, most implementations do have a CREATE
DATABASE command anyway.
--
Jeff
Made some headway, it does look like something with the Oracle install.
Basically, the ORA_NLSXX (32 or 33, depending on the original DB version)
environment variable needs to be set to $ORACLE_HOME/ocommon/nls/admin/data
However, this can be inconvenient if doing it from a large number of
diff
Hello List,
I'm looking to *create* a database with DBI. I couldn't glean this from
the docs. Seems like you first need to connect to a datasource(database)
to issue statements.
Is there a way to 'CREATE DATABASE DatabaseName;' with DBI?
Thanks,
Andrew
I've been trying to get DBD::Oracle 1.12 working on Solaris 8, with perl
5.8.0, DBI 1.30, and Oracle 9.2.0.1 Unfortunately, the 'make test' is
failing, and even if I ignore that, the same problems show up when I try to
run scripts that work fine on an older environment, namely, the fetch
stat
Jeff Thies wrote:
I'm using a pipe delimited table with Any::Data.
This seems to ignore the limit clause in my SQL:
SELECT field1 FROM some_table limit 0,2
I would have thought this (limit) would have been part of DBI, is this
a function of the driver?
Yes, it's driver and database spec
I'm using a pipe delimited table with Any::Data.
This seems to ignore the limit clause in my SQL:
SELECT field1 FROM some_table limit 0,2
I would have thought this (limit) would have been part of DBI, is this
a function of the driver? Which module would limit be implemented? Or
have I made s
Hi, I had the same error retrieving CLOB data when I set client's NLS_LANG
to AMERICAN_AMERICA.UTF8.
Here is the part of the trace with the error:
OCILobGetLength(026F74D4,026F776C,026F68B4,0140FAC8)=SUCCESS
OCILobRead(026F74D4,026F776C,026F68B4,0140FACC,1,01CE0B04,485,,0
000,0,1)=NEE
> From: "Levine, Peter W" <[EMAIL PROTECTED]>
> Date: Fri, 18 Oct 2002 08:52:03 -0700
> To: "Levine, Peter W" <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED]'"
> <[EMAIL PROTECTED]>
> Subject: RE: Connections happening too fast?
>
>> On our development system (SunOS 5.7) my program would 'hang' on occa
Try http://archive.develooper.com/dbi-users%40perl.org/msg14113.html
Tim.
On Fri, Oct 18, 2002 at 05:39:21PM +0200, Joern Reder wrote:
>
> Hi,
>
> sorry, the mail got long, but it took me some time to reproduce the
> problematic behaviour and I think we need this detail level to
> understand
Thanks very much. I tried your suggestion and it works
On 10/17/02 9:58 PM, "Swen Schillig" <[EMAIL PROTECTED]> wrote:
> Michael
>
> Did you setup your DB2INSTANCE variable properly with
> SetEnv DB2INSTANCE db2inst1
> in the httpd.conf file ?
> Maybe the remote database belongs to another i
Roger,
To offer you a quick summary of my position on this:
1) I can/could offer a workaround, but it breaks other, existing tests,
which lead me to believe it would/could break other's code, since the tests
specifically fix problems people have had -- maybe even one of yours :)
Hi,
No response. Perhaps because I neglected to add the particulars:
Using DBD:ODBC 0.43 with OpenLink ODBC manager and driver for SQL Server
2000.
Pete
> -Original Message-
> From: Levine, Peter W
> Sent: Thursday, October 17, 2002 1:41 PM
> To: [EMAIL PROTECTED]
> Subject:
Thanks.
On Fri, Oct 18, 2002 at 03:14:02PM +, Robert Thompson wrote:
> Hello,
>
> I have been using the great module DBI:Shell via dbish, but I may have come
>across a bug. At the least, it did not behave as I expected.
>
> The problem is that when you type the command prefix an
Hi,
sorry, the mail got long, but it took me some time to reproduce the
problematic behaviour and I think we need this detail level to
understand what's going wrong here...
We're using Perl 5.8.0, DBI 1.30 and DBD::Oracle 1.12, both client and
server on Linux. We just extend our application f
Hello,
I have been using the great module DBI:Shell via dbish, but I may have come
across a bug. At the least, it did not behave as I expected.
The problem is that when you type the command prefix and it's not part of a
command, DBI::Shell treats whatever you type after the pref
On Mon, Oct 14, 2002 at 01:57:28PM +0200, Roger Perttu wrote:
> Thomas A. Lowery wrote:
>
> However nothing(!) seem to work for me with DBD-ADO (Using MS SQL 7.0
> MDAC 2.7 DBI 1.30 Activeperl 631):
>
> my $dbh = newDbh();
Of course my set-up is different, I just tested a remote connect to my l
[EMAIL PROTECTED] wrote:
Ok, I've downloaded the latest DBI and DBD::ODBC for Windows (from
ftp://ftp.esoftmatic.com/outgoing/DBI) and installed that. I now see the problem
you are seeing.
Great, because I have very limited knowledge of ODBC so it's hard for
me to explain what's going on.
If
Hi,
On our development system (SunOS 5.7) my program would 'hang' on occasion
immediately after a call to dbh->connect. This would be after a longish
sequence of connects & disconnects to initialize some data files. By 'hang'
I mean it never returned. A debug statement immediately after dbh->conne
On Thu, 17 Oct 2002 17:18:46 -0700 Limei Zhang <[EMAIL PROTECTED]> wrote:
> Hi, there,
> I am using DB2 UDB workgroup 7.2 on linux redhat 7.3, DBD-DB2 0.73 DBI
> 1.30 Perl 5.
>
> I have no problem to connect to database by runnig the perl program
> containing the following code in a command lin
I have had success with DBI 1.30 and DBD-Oracle 1.12 with 9i on Linux.
There is an issue if you are (or planning) to use the 64bit version of
Oracle
.. event he the article is for sun, it should still apply to Tru64
http://xmlproj.com/fom-serve/cache/122.html
David Crown, MCSE, MCP+I, CCNA
Informa
Hi,
I am unable to execute a db2 export command this way.
@conn_command = ("db2 connect to gtbookdb");
$output = `@conn_command 2>&1`;
@exp_command = ( "db2 export to $textfile of del
select \* from","$table_name");
$output = `@exp_command 2>&1`;
error says the connection not available.
Hi, there,
I am using DB2 UDB workgroup 7.2 on linux redhat 7.3, DBD-DB2 0.73 DBI 1.30
Perl 5.
I have no problem to connect to database by runnig the perl program
containing the following code in a command line:
..
my $dbh = DBI->connect("dbi:DB2:$mydatabase", "$user", "$password");
.
H
I am about to attempt a DBI/DBD for PERL Oracle 9i interfacing, on a Compaq
Dec Alpha Tru64 UNIX machine. I am unsure whether to use DBI-1.25 or
DBI-1.30, before installing DBD-Oracle-1.12.
Also - will the DBD-Oracle-1.12 work with 9i?
Could you advise? Thank you.
Michael
Did you setup your DB2INSTANCE variable properly with
SetEnv DB2INSTANCE db2inst1
in the httpd.conf file ?
Maybe the remote database belongs to another instance !?
Swen
To see if the problem's in the Oracle side or the DBI side, does the SQL
statement run directly from SQL*Plus on the client? Have you tried using
the WE8ISO8859P1 NLS_LANG setting? Don't use the EBCDIC one on HP -- it
won't work.
A few other questions/points. Why are you using TO_CHAR? Or, ins
On Thu, 17 Oct 2002 19:46:09 -0700 Elio Grieco <[EMAIL PROTECTED]> wrote:
> I just spent the last 6 hours trying to figure out why I was not
> receiving any rows back from DBI for SQL queries that returned over a
> hundred rows through the phpMyAdmin interface.
>
> I finally noticed that in all
This issue came up at a client site and we are at a loss to figure out why.
During the make of DBD_ORacle-1.12 we consistently receive this error:
/opt/perl5/bin/perl -I/opt/perl5/lib/5.6.1/PA-RISC1.1
-I/opt/perl5/lib/5.6.1 /opt/perl5/lib/5.6.1/ExtUtils/xsubpp -typemap
/opt/perl5/lib/5.6.
From: "Jeff Urlwin" <[EMAIL PROTECTED]>
To: "Frederik A.A. de Jonge" <[EMAIL PROTECTED]>,
"Jeff Urlwin" <[EMAIL PROTECTED]>
Hi Jeff
I am not a fluent user of these systems, my oversight; I have posted my
2nd email to the list now.
Thanks for your sec
in response to Jeff his first reply
sorry about not sending this immediately to th list
--- Forwarded message follows ---
From: Frederik A.A. de Jonge <[EMAIL PROTECTED]>
To: "Jeff Urlwin" <[EMAIL PROTECTED]>
Subject:RE: insert LONG /
Hello,
Yes, but don't do!!! that make unstable!!
You have to install the gcc 2.95 (download the bin
from sunfreeware, other packets are needed too...)
recompile the perl and then make all the modules
again... or install the cc but i think it is too
cost... i have the same problem with Solari
I just spent the last 6 hours trying to figure out why I was not
receiving any rows back from DBI for SQL queries that returned over a
hundred rows through the phpMyAdmin interface.
I finally noticed that in all the places where no rows were returned I
had used a here document to store the SQL
> Thanks for the reply
Please always keep the dbi-users mailing list on the mails. Others can
learn from what you've done...
> After having sent my email (with some trepidation as I felt
> that I was asking something that seems to be not a new problem)
> I actually did find another of your answ
> "Elio" == Elio Grieco <[EMAIL PROTECTED]> writes:
Elio> I finally noticed that in all the places where no rows were returned I
Elio> had used a here document to store the SQL in a variable before passing
Elio> it to DBI. Does anyone know why using a here document would result in
Elio> the SQ
On Thu, 17 Oct 2002 13:05:54 -0700 (PDT) Naveen Prabhakar <[EMAIL PROTECTED]> wrote:
> I am unable to execute a db2 export command this way.
>
> @conn_command = ("db2 connect to gtbookdb");
> $output = `@conn_command 2>&1`;
>
> @exp_command = ( "db2 export to $textfile of del
> select \* fr
45 matches
Mail list logo
