At 22:25 -0400 9/6/02, Rich DeSimone wrote:
>Hi, I am trying to install the Msql-Mysql modules and seem to be
>getting an error. I installed the data-dumper and DBI modules and
>had no problem. This is what I am getting..
>
>[root] (~/Msql-Mysql-modules-1.2219)-> perl Makefile.PL
That's old.
Hi, I am trying to install the Msql-Mysql modules and seem to be getting an error. I
installed the data-dumper and DBI modules and had no problem. This is what I am
getting..
[root] (~/Msql-Mysql-modules-1.2219)-> perl Makefile.PL
Which drivers do you want to install?
1) MySQL only
Hello, I was going through the dbi-users archive looking for an answer to compiling
with dbi because earlier today I kept getting this error
/tmp/ccq7gV8F.o: In function `dl_init':
/tmp/ccq7gV8F.o(.text+0xb6404): undefined reference to `boot_DBI'
collect2: ld returned 1 exit status
But when I
Hi, everyone, we have a PL/SQL function which is defined as follows,
FUNCTION get_all_curr_descs_items
(
o_status OUT sp_error_log.error_id%type,
o_error_mesg OUT sp_error_log.error_mesg%type,
i_metro_idIN traffic_item.metro
> From: "Herbold, John W." <[EMAIL PROTECTED]>
> Subject: RE: Sending DBI data to PDF?
>
> Making a call
> to a database and bringing the report back in PDF should be something that
> has been done.
They only system that I've seen for automating such a thing is Matt
Seargent's AxKit (xml.apache.
[EMAIL PROTECTED] [[EMAIL PROTECTED]] wrote:
>
> The script I'm using is basically this
>
> $dbname = "dbi:Sybase:server=$ENV{SYBASE_DB_SERVER};".
> "database=$ENV{SYBASE_DB_NAME}";
> .
> .
>
> my $dbh=DBI->connect($dbname,$username,$password,
>
Jessee,
I'd research on the sites provided and also, copy dbi-users...
Jeff
> -Original Message-
> From: Jessee Parker [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 06, 2002 3:06 PM
> To: Jeff Urlwin
> Subject: Re: Installation Problems
>
>
> Ok I guess I had a misunderstanding f
Go get unixODBC (www.unixodbc.org) or iODBC (www.iodbc.org) (I think) and
install and *test* them (along with your driver, which you haven't mentioned
yet, either).
*Then* install DBD::ODBC and test it.
Jeff
>
> I'm trying to install DBD::ODBC on our RH Linux 7.3 server and I keep
> getting the
I'm trying to install DBD::ODBC on our RH Linux 7.3 server and I keep
getting the following:
Using DBI 1.30 installed in
/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI
The DBD::ODBC module needs to link with an ODBC 'Driver Manager'.
(The Driver Manager, in turn, needs one or more database s
Did that, you have to position everything with X,Y cords and looping through
the answer set from DBI call would be a pain. And before I take on this
beast, I was hoping that someone else had done this already! Making a call
to a database and bringing the report back in PDF should be something th
On Fri, Sep 06, 2002 at 10:41:26AM -0700, Tony Jin wrote:
> That was because the environment variable
> 'LD_LIBRARY_PATH' was not set.
> 'LD_LIBRARY_PATH' can't be set correctly inside the
> perl script itself.
>
> So you have two ways to make it work:
> 1) set 'LD_LIBRARY_PATH' in the non-oracl
"Tobias, Robert" wrote:
> Solved the problem. When compiling, programs were trying to link to the
> various 'lib' directories under ORACLE_HOME and getting ELFCLASS64 errors
> from ld (this was a 64-bit installation of Oracle 9i 9.2.0). I forced it to
> use the included 32-bit libraries instead
Solved the problem. When compiling, programs were trying to link to the
various 'lib' directories under ORACLE_HOME and getting ELFCLASS64 errors
from ld (this was a 64-bit installation of Oracle 9i 9.2.0). I forced it to
use the included 32-bit libraries instead by running 'perl Makefile.PL' an
That was because the environment variable
'LD_LIBRARY_PATH' was not set.
'LD_LIBRARY_PATH' can't be set correctly inside the
perl script itself.
So you have two ways to make it work:
1) set 'LD_LIBRARY_PATH' in the non-oracle user
profile;
or 2) put the the perl script inside a shell script,
whe
I have a perl script in which I setup the following env. variables:
delete @ENV{qw(ORACLE_BASE ORACLE_HOME PATH LD_LIBRARY_PATH HOME)};
$ENV{'ORACLE_BASE'} = "/fin01/app/oracle";
$ENV{'ORACLE_HOME'} = "/fin01/app/oracle/product/806";
$ENV{'PATH'} =
"/fin01/app/oracle/product/806/bin:.:/usr/bin:/u
I have succesfully downloaded and installed the DBI module (Ver 1.30).
I have also downloaded the DBD module for Ingres (Ver 0.34). I have followed the
installtion steps described in the README file without incident until I reach:
DBI_DSN=testdb make test
At this point I get the followi
I have succesfully downloaded and installed the DBI module (Ver 1.30).
I have also downloaded the DBD module for Ingres (Ver 0.34). I have followed the
installtion steps described in the README file without incident until I attemempt to
test the installation
i.e DBI_DSN=testdb make test
At t
Hi.
In searching around Perl mailing list archives I found a lot of references
to array binds (bulk binds in Oracle). It looks like the functionality has
been in the DBI for a little while. But I cannot find a reference that
tells me whether or not bulk binds have been implemented in DBD-Oracle
Herbold, John W. wrote:
>Has anybody done anything with sending data from DBI calls to PDF files?
>
>Thanks !
>
>John W. Herbold Jr.
>IS Specialist/DBA
>
>
I have done that sucessfully by stuffing data retrieved with DBI into
LaTeX templates and piping the result through pdflatex. Most other
On Fri, Sep 06, 2002 at 10:52:00AM -0500, Herbold, John W. wrote:
> Has anybody done anything with sending data from DBI calls to PDF files?
You could check out PDF.pm.
dd
--
David Dooling
Has anybody done anything with sending data from DBI calls to PDF files?
Thanks !
John W. Herbold Jr.
IS Specialist/DBA
I am trying to connect from Unix to a SQL 7 database on a NT4 server using
dbi:proxy. I can connect to SQL VIA proxy server from a WIN2000 box fine.
But when I run the same script on the Unix box I get the following error.
DBD::Proxy::db STORE failed: Error while writing socket: Invalid argument
Hello,
I'm new to DBI, so please forgive me if this is a stupid question:
how can I get the name of the primary key column of an Oracle table?
Thanks in advance,
Birgit Kellner
check the permissions for the oracle client software home.
> -Original Message-
> From: Seille Amar [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 06, 2002 9:41 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: problem with DBD
>
>
> hello,
> When i try to install DBD
If they have any C code in them, the modules you install need to be built
with the same C compiler that Perl was built with. Solaris comes with
version 5.00503 built using the Sun C compiler. You can spend money
for get the Sun C compiler and install DBI. Then you have DBI working
on an old ver
hello,
When i try to install DBD, in the "make test" step, i
have this error message:
install_driver(Oracle) failed: Can't load
'/usr/opt/perl5/lib/site_perl/5.005/aix/auto/DBD/oracle/Oracle.so'
for module DBD::Oracle: dlopen:
/usr/opt/perl5/lib/site_perl/5.005/aix/auto/DBD/Oracle/Oracle.so:30
/u
You might want to take a look at also explicitly setting the character
encoding in your HTML document, since that is where the javascript is
getting a hold of it.
I am assuming, of course, that the client-side is what you believe is
corrupting your data.
If you're using UTF-8, you can tell perl
This may be off topic, but I need help in determining where to go. I have
set up a java script to insert (and select) from my database, the data in
there contains extended characters, the word is Prénom
When I select via a perl dbi script, the data is already corrupted (its
Prenom).
For referen
The script I'm using is basically this
$dbname = "dbi:Sybase:server=$ENV{SYBASE_DB_SERVER};".
"database=$ENV{SYBASE_DB_NAME}";
.
.
my $dbh=DBI->connect($dbname,$username,$password,
{ RaiseError => 1, AutoCommit => 1})
or die "Couldn't conne
Sorry, I'll have it back up and running today:-) The server is running at a
different location, and must of went down.
Give me until the evening and I'll have it running again.
Ilya
-Original Message-
From: cp
To: dbi users perl.org
Sent: 9/5/02 2:26 PM
Subject: Ilay Sterin's FAQ
On the other hand, if you need to pass connection attributes
(LongReadLen, LongTruncOK, RaiseError, etc) you may need to put in
empty strings for the user name and password:
$dbh=DBI->connect($connect_string, '', '', %attr); Or is it undefs? I
never touch the ODBC stuff myself.
HTH,
jeff
O
you need the optional ( THEY WANT YOU TO SPEND $$ FOR A REAL COMPILER)
compiler.
if you have it, it should be in '/opt/SUNWspro/bin/cc'.
the defualt one in 'usr/ucb/cc' is not ANSI compliant.
> -Original Message-
> From: Gallagher, John (5462) (O&M)
> [mailto:[EMAIL PROTECTED]]
> Sent:
John,
You need to build (compile) DBI / DBD::xxx with the same compiler as was
used to build Perl. The perl on Solaris 2.8 is built using Sun's compiler
(and is old).
I suggest you install perl 5.6.1 (prebuilt from www.sunfreeware.com) gcc
2.95 (ditto) and start again.
This is in a FAQ some
Hi all,
I'm trying to install DBD::Oracle on a Mandrake 8.1, but getting a build error
as follows.
Found header files in rdbms/demo.
Unable to locate an oracle.mk, proc.mk or other suitable *.mk
file in your Oracle installation.
Does this mean that Oracle was installed without support for DB
On Fri, Sep 06, 2002 at 11:27:43AM +0100, Gallagher, John (5462) (O&M) wrote:
> It seems to be complaining about 'language optional software package
> not installed
You are using /usr/bin/perl on Solaris which was compiled with the
Solaris C compiler. You do not have that compiler installed on y
Hi
I have included a build log from an attempted install of DBI module 1.30 on
a Solaris System. It seems to be complaining about 'language optional
software package not installed ( I have included output of perl -V)
Any help given is greatly appreciated.
John
__Script star
Is there any way I can get DBD::Oracle compiled on Solaris 2.5? I have the
install disks for Oracle 8.1.6 (which were used to install the database
server on a different machine), but they require Solaris 2.6.
The main problem appears to be that libclntsh.so can't be built due to a
missing library
Hi
I have included a build log from an attempted install of DBI module 1.30 on
a Solaris System. It seems to be complaining about 'language optional
software package not installed ( I have included output of perl -V)
Any help given is greatly appreciated.
John
__ <>
*
Hello all,
I am using require .
This pm file will be having all sort of functions to be used up in the
perl script
But while i use "require test.pm" and execute a main script that script
stucks up without coming out to the command prompt.
If i remove that require line and execute the script th
On 05-Sep-2002 Levine, Peter W wrote:
> Hi,
>
> Why do I need to supply user name and password with DBI->connect() if I am
> using DBD:ODBC? This information is already supplied in the DSN?
>
> my $DSN="dbi:ODBC:sqlserver_dsn";
> my $DBI_USER="Why do I need this?"
> my $DBI_PASS="Why do I need
40 matches
Mail list logo
