- Original Message -
From: "Harry Burgin" <[EMAIL PROTECTED]>
Subject: DBD-Pg-0.98 install problem
I have DBI installed but can't get DBD-Pg to install without error.
1. perl Makefile.PL is ok - runs without error.
2. make then returns the following error:
In file included from Pg.xs:
On Thu, 3 May 2001, Phillip Perkins wrote:
> This may be a stupid question, but what does the (3) mean in something
> like DBI(3) when checking a reference?
It's a reference to man page classification. Section 3 man pages refer to
subroutine and API documentation, i.e., programming information.
Howdy,
I am using DBI.pm and DBD::Oracle for web database apps. We have
international characters supported and working fine inserted and
selected through the standard gui tools and sqlplus. When I have perl do
the same insert through DBI the international characters are being
converted somehow to
How about DBD::Proxy? Could the proxy server run on a Windows box
somewhere and have the client running on the Un*x box talk to the
spreadsheet through the proxy?
Randy
On Wed, May 02, 2001 at 06:56:01AM -0600, Sterin, Ilya wrote:
> Also I would think that this is a big enough issue to address
We've been setting all of our new Raq developers up with Windows PC's for
development. Since I've been throught this process a few times this week I
put together a HowTo on setting up a Win32 box for Raq development:
http://www.emoe.net/whitepapers/raq3win32dev.html
The document covers developm
Alzabo is a program and a module suite, with two core functions. Its first
use is as a data modelling tool. Through either a schema creation
interface or a perl program, you can create a set of schema, table,
column, etc. objects to represent your data model. Alzabo is also capable
of reverse eng
Michael,
No that just gives me the same error message:
Here is my entire program:
#!/usr/bin/perl
use DBI qw( neat_list );
use DBD::DB2::Constants;
use DBD::DB2 qw($attrib_int $attrib_char $attrib_float $attrib_date
$attrib_ts);
use Date::Manip;
use FileHandle;
###
#
# DB2 co
Ronald,
I cannot reproduce your problem, but you might want to try altering the
session date format, rather than using to_date, as in
my $sqld="ALTER SESSION SET NLS_DATE_FORMAT = '-MM-DD'";
$dbh->do($sqld);
and just use a string placeholder ? instead of to_date(?,'-MM-DD') in
the SQL
Thank you.
Arthur Corliss wrote:
> On Thu, 3 May 2001, Phillip Perkins wrote:
>
> > This may be a stupid question, but what does the (3) mean in something
> > like DBI(3) when checking a reference?
>
> It's a reference to man page classification. Section 3 man pages refer to
> subroutine and AP
On Thu, May 03, 2001 at 06:42:43PM -0400, Phillip Perkins wrote:
> This may be a stupid question, but what does the (3) mean in something
> like DBI(3) when checking a reference?
>
That's the memory address that the reference points to.
Ronald
This may be a stupid question, but what does the (3) mean in something
like DBI(3) when checking a reference?
Phillip
I have a problems. I am trying to read data from one data base DB2 and
insert it into an Oracle database. I have got the script that goes off and
discovers the structure of the DB2 database table and creates it in my
oracle database. I am now working on the part that goes off and gets the
data fro
Thank you for setting me straight. As chance would have it, I also had
another set of eyes look at it here and come up with the same
thing... actually, now that I think of it, I did come to this conclusion a
couple of other times but kept forgetting it.
Basically, if I did $outObj->param("\"NULL
Curt Russell Crandall writes:
>
> Now, what has me scratching my head is why when I define an input argument
> to this stored proc as "NULL" the string, it is showing up in the database
> as [NULL]... this is what I want, but I'm wondering why it is working... I
> would think that the databa
I'm royally confused right now. This is something I've looked at on and
off but never followed through with and eventually would always forget
about.
I have several objects that have been created using Class::Struct. The
structure is filled by splitting a tab delimited record and feeding that
to
Philip,
I just scanned through the docs for DBD::Xbase and noticed the last
sentence of the description states:
The DBD::XBase doesn't make use of index files at the moment. If you
really need indexed access, check XBase(3) for notes about support for
variour index types.
If its possible in you
Hi, I am newbie to this mailing list. Please spare me if my question is too
silly. I did search the archive but cannot find the information I need.
I downloaded DataDirect Connect ODBC yesterday and installed on my Redhat
Linux 6.1. I then installed DBI-1.15 and DBD:ODBC 0.28. I tested
successfu
On Thu, 3 May 2001, David H. Silber wrote:
> I've also stumbled upon DBIx::DBSchema, which is supposed to help me
> extract schema information from a database.
>
> Does anyone know how Alzabo & DBIx::DBSchema compare? Or do they
> compare at all?
>
> What I need is to get the complete schema and
See, that's just the thing. There is an index file with a tag reference even on the
field that I'm using in my where clause. However, (I just skimmed over the mod code,
so I don't know how accurate my eval is) it appears that w/ or w/o an index the
DBI::XBase driver will read each record sequent
Phillip,
Probably the best solution would be to create an index on your table, and
use a where clause in your query to restrict the results you return to
just the ones that need to be processed in the current operation. Make
sure that the indexed column is the one that you will be using to refin
I have DBI installed but can't get DBD-Pg to install without error.
1. perl Makefile.PL is ok - runs without error.
2. make then returns the following error:
In file included from Pg.xs:13
Pg.h:17: libpq-fe.h: no such file or directory
Is this a problem with DBD or is my perl or PostgreSQL inst
So, how can I speed up the file read process: get a faster machine? It would
seem to me that a faster way to accomplish this would be to store file positions
in a list for every indexed field that was queried that matched the query.
Then, during the fetch, read the rest of the fields to see if ev
I just tried it and I get:
Bad hash at /usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm line 940,
line 14.
Sherry
Phillip Perkins wrote:
> Have you tried $records_affected = $dbh->do($statement); ?
>
> Sherry Graham wrote:
>
> > I am a newbie to DBI programming with ASA. I can connect to my
Actually most of the drivers work this way. They execute() you query and
set the cursor at the first record and gets ready to fetch() some db's like
Oracle, actually use a buffer and on fetch stores the first X number of rows
in that buffer for more efficient fetching.
Ilya Sterin
-Origina
Have you tried $records_affected = $dbh->do($statement); ?
Sherry Graham wrote:
> I am a newbie to DBI programming with ASA. I can connect to my database
> and make simple SQL queries just fine, but I am unable to call a stored
> procedure. Is there something special that needs to be done?
>
>
Honza Pazdziora wrote:
> On Wed, May 02, 2001 at 06:18:08PM -0400, Phillip Perkins wrote:
> > Tried that...no good. Still took 43 seconds, I think. I've watched it zip
> > through all the records until it gets to the end where fetch returns undef, and
> > that seems to be taking a while.
> >
>
Hi Roland,
I'm using the same versions as you except for Perl - I'm still at
the default Perl that comes with Solaris 8: 5.00503.
Moving from DBI-1.15 to DBI-1.14 fixed my plsql.t problem. I think
the root cause of that problem was announced on this mailing list
and the package's author will tr
On Thu, May 03, 2001 at 10:22:23AM -0500, Bob Gustafson wrote:
> There is an interesting project on sourceforge called Alzabo, which
> provides an html database interface using DBI, Perl with mason and
> mod_perl/apache for both design and browsing of database tables. It uses
> mysql and/or oracle
I am a newbie to DBI programming with ASA. I can connect to my database
and make simple SQL queries just fine, but I am unable to call a stored
procedure. Is there something special that needs to be done?
The error I get is Bad hash at ./program.pl line 427
My stored procedure statements are:
On Thu, 3 May 2001, Bob Gustafson wrote:
> There is an interesting project on sourceforge called Alzabo, which
> provides an html database interface using DBI, Perl with mason and
> mod_perl/apache for both design and browsing of database tables. It uses
> mysql and/or oracle and/or postgresql.
Hi Marc,
I still have the same problem with DBD::Oracle-1.06, Perl-5.6.1, DBI-1.15,
Oracle-8.1.6 under Intel Solaris 8.
I also tried everything in the readme files, but to no avail... Someone
suggested downgrading both DBI and Perl, so to DBI-1.14 and Perl-5.6.0, I
did but to no avail. So I am st
On Wed, May 02, 2001 at 06:18:08PM -0400, Phillip Perkins wrote:
> Tried that...no good. Still took 43 seconds, I think. I've watched it zip
> through all the records until it gets to the end where fetch returns undef, and
> that seems to be taking a while.
>
> I kinda' thought that it might be
Hello
I've installed the openlink ODBC driver on a Solaris 2.8 box, and the broker
on a NT SQL 7 box.
The odbctest app connection works great! Now the next step is loading Perl
DBI and ODBC module to connect
Rational's ClearCase and a SQL 7 database using perl scripts. See below for
problem.
An
There are a few replacements for excel in the Linux world. Gnumeric, Star
Office (which is also free and now opersource), and I believe KDE has their
own version too. The problem is non of these automate the excel to db
process and therefore when a corporation is Windows standard the users
uploa
There is a GNOME tool called GNUmeric which duplicates much of Excel, but
as an opensource project. It will import Excel files.
I have not used it (I don't have much to do with Excel stuff), but it
appears from the documentation to be a viable replacement for Excel (if not
right now, then soon).
There is an interesting project on sourceforge called Alzabo, which
provides an html database interface using DBI, Perl with mason and
mod_perl/apache for both design and browsing of database tables. It uses
mysql and/or oracle and/or postgresql.
It is pretty far along and I have found it to be u
> I am a new to the world of databases and I am having problems trying to
> return the table structure in an mSQL database using the DBI module. If
> anyone could help please. I dont seem to be able even to come up with a
> proper syntax not recognize the right handle or atribute.
You could r
Jeff,
I suspect there could be a problem with your Oracle rollback segments
(the one that your transcation actually uses could have reached its
maximum size). As 1 transaction uses exactly 1 rollback segment there is
no way to escape except to use bigger RB segments or to use smaller
transactions
At 10:58 AM 5/3/2001 +0100, Peter Haworth wrote:
>This is a bug in DBD::Pg 0.98. There is a different bug in 0.96/0.97 which
>dumps core on (at least) Linux. The following patch fixes 0.98, and has
>been sent to Edmund Mergl, so hopefully there'll be a new version soon.
Thanks very much! That
OK Jeff, lets try one more time...
What is the error message you are getting if any? Use trace() (for proper
usage see 'perldoc DBI'), then submit the trace ouput to the list.
Ilya Sterin
-Original Message-
From: jeff knot
To: Sterin, Ilya
Cc: [EMAIL PROTECTED]
Sent: 05/02/2001 10:48 PM
I had the same symptoms testing DBD::Oracle 1.06 and solved the
problem by downgrading to DBI 1.14 - thanks to this list!
Marc
-Original Message-
From: John Botham [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 03, 2001 3:55 AM
To: '[EMAIL PROTECTED]'
Subject: Installation problems (D
Have you tried the Samba tool "smbsh"? It doesn't allow you to mount
shares, but it does allow you to view and work on the WinTel shares.
Dudley
-Original Message-
From: Steve Sapovits [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 03, 2001 5:52 AM
To: Neil Lunn; '[EMAIL PROTECTED]'
Subj
I am a new to the world of databases and I am having problems trying to
return the table structure in an mSQL database using the DBI module. If
anyone could help please. I dont seem to be able even to come up with a
proper syntax not recognize the right handle or atribute.
please advice
[EMAIL
* Steve Sapovits ([EMAIL PROTECTED]) [010503 06:02]:
>
> ...
> why processing on Solaris is preferred. And, although Samba allows
> Windows users to easily see UNIX directories as shared drives for
> free, there is no software for free that goes the other way and
> presents Windows shares as UN
On Wed, 02 May 2001 11:05:10 -0400, Rick Cochran wrote:
> The following code:
>
> $insert_fundsource->execute("$aalias -
> tmp[1]",$tmp[1],$aalias,$tmp[4],$accttypes{$tmp[2]},$tmp[5])
> or carp "Unable to insert fundsource (".$dbh->errstr.")\n";
>
> produces the following error me
In my case, we have so much that exists on Solaris and so little
that exists on Windows in terms of infrastructure code. It's not
all Perl, so it's not a simple matter of duplicating the environment.
And even with the Perl pieces, Windows is brain-dead enough that I
have to drop at least a few
On Thu, May 03, 2001 at 04:48:17AM -, jeff knot wrote:
> I have found that the problem ocuurs in many
> cases. For example, I use
> sqlload userid=scott/tiger control=load log=load.log
>
> to upload my data to the oracle. Once the data file
> is very long. The same problem also occurs: it is
Hi,
I am installing DBD::Oracle in the environment cited in the subject and get
a core dump during the t/plsql tests. I have tried all the make variants
suggested in the README and README.help files but to no avail. The
information suggested by the README is attached, along with the backtrace
gle
48 matches
Mail list logo
