yes, I got it fixed.
While installing Msql-Mysql-Modules
I have specified option for --mysql-libdir
perl Makefile.PL --mysql-libdir=/var/lib/mysql
But, do it I installed
MySQL-shared-3.23.44-1.i386.rpm
which I haven't done, earlier.
I don't know, by what got it fixed.
and thanks to mysql.soc
Hello mickalo,
I saw your post regarding the mysql.sock on [EMAIL PROTECTED] list.
But, in my case when perl script to fetch details from mysql database,
DBI:Mysql module checking the mysql.sock in /tmp/mysql.sock.
and getting failed, because, mysql.sock is existing under /var/lib/mysql/mysql.s
Hello Gurus,
I have installed
MySQL-3.23.44-1.i386.rpm
MySQL-client-3.23.44-1.i386.rpm
and
DBI-1.20.tar.gz
Data-ShowTable-3.3.tar.gz
and when I trying to install the
Msql-Mysql-modules-1.2219 getting following error :.'/tmp/mysql.sock' (111)
It's checking for /tmp/mysql.sock, but it's in /va
Hello Gurus,
I have installed
MySQL-3.23.44-1.i386.rpm
MySQL-client-3.23.44-1.i386.rpm
and
DBI-1.20.tar.gz
Data-ShowTable-3.3.tar.gz
and when I trying to install the
Msql-Mysql-modules-1.2219 getting following error :.'/tmp/mysql.sock' (111)
When I checked
%mysqladmin variables
mysql.s
Hello Gurus,
I have installed
MySQL-3.23.44-1.i386.rpm
MySQL-client-3.23.44-1.i386.rpm
and
DBI-1.20.tar.gz
Data-ShowTable-3.3.tar.gz
and when I trying to install the
Msql-Mysql-modules-1.2219 getting following error :.'/tmp/mysql.sock' (111)
When I checked
%mysqladmin variables
mysql.s
Hello Gurus,
I have installed
MySQL-3.23.44-1.i386.rpm
MySQL-client-3.23.44-1.i386.rpm
and
DBI-1.20.tar.gz
Data-ShowTable-3.3.tar.gz
and when I trying to install the
Msql-Mysql-modules-1.2219 getting following error :.'/tmp/mysql.sock' (111)
When I checked
%mysqladmin variables
mysql.sock
In article
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Brad Watts) wrote:
> print header;
> start_html("ATT Canada - (NCMRS) Network Capacity Management Report
> Server");
that should be
print header(),
start_html("ATT Canada - (NCMRS) Network Capacity Management
Report Server");
> ###
Hi, Tim,
Zitiere Tim Bunce <[EMAIL PROTECTED]>:
> Er, why not fix Storable to be thread safe (if it isn't).
> That's bound to be fairly trivial and Storable is many times
> faster than Data::Dumper.
making Storable thread safe is harder than you might
think. I have once sent a patch to Raphael
Hi,
I recently needed the absolute minimum installation of Oracle 8.1.7 which
will would allow me to compile DBD::Oracle version 1.12 on a Solaris 2.7
server (which only has a minimum Oracle client installation). I couldn't
find a good reference in the archives, so I copied a complete Oracle
ins
Hi,
I am having problem passing a blank into a placeholder.
Here are part of the sql and the perl:
-- sql --
$qry = qq {
SELECT
vs.d_vst_id,
vs.d_vst_patid,
FROM
lab_gru_db_rec gr,
dnr_vst_db_rec vs,
..
WHERE
gr.l_gru_instid = ?
AND gr.l_
Hello,
I wrote the following cgi. Everything works perfect except the "LIKE"
clause is not working. Am I doing something wrong here? Aaaahh :-0
The parameters appear to be binding to the select statement, the select
statement is tried tested and true and the -w switch is not telling me
anything
I do not have oracle but I did once do a script that
wporked for a colleague running oracle. The program was
run on a client where the Oracle DB was in a different
machine
with ip address $ip The SID was $sid
In that case
my $dsn="dbi:Oracle:host=$ip;sid=$sid";
my $dbh=DBI->connect($dsn,$user
I'm not sure in DBI, but w/ JDBC, you have what called MetaData, and w/
that you can get info about the fied definition.
HTH
--Yohans
On Wed, 14 Nov 2001, Example user SuSE Linux 6.2 wrote:
> Is it possible to use DBI to get the type of a field in a table?
> If so, how?
>
> The point is that
Just off the top of my head, I'd say your DSN is incorrect -
check the DBD::Oracle documentation by doing
perldoc DBD::Oracle
at a command prompt. There's lots of info in there about
different ways to connect.
HTH.
PS - you didn't mention that you had DBD::Oracle installed -
if you don't ye
On Tue, 13 Nov 2001, Jonathan Leffler wrote:
>CHEN SEI-LIM wrote:
>> Jonathan Leffler wrote:
>> > CHEN SEI-LIM wrote:
>> > > You can make a simple program to try it not only your supposition.
>> > > If I am wrong I will say sorry to everybody.
>> >
>> > Since you're so adamant that it can be done,
Is it possible to use DBI to get the type of a field in a table?
If so, how?
The point is that I want to have a portable script along mysql and
Oracle and
these may have different datatypes. So it might be best to query the
database
what datatype fieldx is, then use it to say create an auxillia
BDY.RTF
Description: RTF file
Simon Oliver writes:
> > It works great as long as you have the freetds (I'm using 0.51) and the
> > 0.91 version of DBD::Sybase. The newest version will NOT work. Once
> > you set up your interfaces file in freetds and everything is compiled
> > and installed, it works like a charm.
>
Is it possible to get the field type of a field in DBI?
for instance I have a table
T(field1 INT(3), field2 VARCHAR(30),...);
is it possible to get the type (i.e. VARCHAR(30) of
field2?
Thanks,
S.Alexiou
On Wed, Nov 14, 2001 at 04:31:44PM +0100, Jochen Wiedmann wrote:
> Zitiere Simon Oliver <[EMAIL PROTECTED]>:
>
>
> > iThreads is supposed to emulate fork on Win32 but this doesn't work for
> > extensions that are not thread safe; this includes "Storable" which
> > happens
> > to be used by the P
Zitiere Simon Oliver <[EMAIL PROTECTED]>:
> iThreads is supposed to emulate fork on Win32 but this doesn't work for
> extensions that are not thread safe; this includes "Storable" which
> happens
> to be used by the PlRPC modules.
It should be comparatively simple to replace Storable
with Data:
I think it's time to end this thread.
Tim.
Is there some way to do this on a connection basis? Is that necessary?
I have some servers that don't use encryption.
-Original Message-
From: Cliff Nadler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 5:57 PM
To: Tim Bunce
Cc: Pepin, Joseph D (Joe), GOVMK; [EMAIL PROTECTED
Here is an example of connecting to an Oracle database with ODBC.
$dbhOracle = DBI->connect( "dbi:ODBC:daily", "userID", "userPassword",
{ RaiseError=> 1, PrintError => 1, AutoCommit => 1 } ) or die "Connection
failed";
An example with DBI
$dbhOracle = DBI->connect( "dbi:Oracle:daily", "
On Tue, Nov 13, 2001 at 05:04:04PM -, Mabley, Paul wrote:
> Hi
>
> I'm trying to write a script that forks child processes and then inserts a
> row into a database (using a prepared statement) when each child has
> completed its task. The insert statement has been failing with the
> followi
Can anyone please help? I am having problems connecting to a remote oracle8
DB from perl running on a server connected to oracle7 DB. have tried the
following procedures:
First example:
my $dbh = DBI->connect("dbi:Oracle:hostname=my_hostname:port
=my_port:dsn=my_dsn", $user, $password, { Prin
Hello:
I can't get the following simple code to work, it gives an error:
!/res/bin/perl
use DBI;
my $dsn="DBI:Oracle:test";
my $user="myname";
my $pw="myname";
my $dbh=DBI->connect($dsn,$user,$pw);
***It gives the following error:
DBI->connect failed: ORA-12705: invalid or unknown NLS parameter
It's on my list to look into soon. Thanks.
Tim.
On Wed, Nov 14, 2001 at 10:45:55AM +0100, Polak Michal wrote:
> Hello,
>
> there is memory leaking somewhere. I think it is in DBI.
> Please, try this source code (replace dbname, username and password,
> please):
> ###
Hello,
there is memory leaking somewhere. I think it is in DBI.
Please, try this source code (replace dbname, username and password,
please):
###
use strict;
use DBI;
my $sql = "INSERT INTO test01 select * from test02 where column01 = ?";
my($database, $us
Hi
I'm trying to write a script that forks child processes and then inserts a
row into a database (using a prepared statement) when each child has
completed its task. The insert statement has been failing with the
following error:
ORA-03113: end-of-file on communication channel (DBD ERROR: OC
Look at the file "README.java" that came with the DBD::Oracle
install. Two of the security drivers that Oracle supports are
written in Java and require multi-threading, which you probably
don't have turned on. "README.java" tells how to remove the
problem security drivers.
paladugu nagendra pra
Jonathan Leffler wrote:
> CHEN SEI-LIM wrote:
>
> > Jonathan Leffler wrote:
> >
> > > CHEN SEI-LIM wrote:
> > >
> > > > You can make a simple program to try it not only your supposition.
> > > > If I am wrong I will say sorry to everybody.
> > >
> > > Since you're so adamant that it can be done,
Old style threads do not work under ActivePerl - only iThreads!
The PlRPC modules (used by Net::Daemon, used by DBD::Proxyserver) only
support, single, fork and old style threads.
iThreads is supposed to emulate fork on Win32 but this doesn't work for
extensions that are not thread safe; this in
> It works great as long as you have the freetds (I'm using 0.51) and the
> 0.91 version of DBD::Sybase. The newest version will NOT work. Once
> you set up your interfaces file in freetds and everything is compiled
> and installed, it works like a charm.
What's wrong with the latest version
Bill Kurland wrote:
> I am trying to use the perl DBI to connect to a product called U/SQL
> that gives
> me SQL like access to a COBOL ISAM database supplied by a VAR. My
> VAR pretty much only sells vanilla so I have been teaching myself how to
> program and was advised that perl was a very
Adam Gomes wrote:
> Anyone happen to know of anyone who might have put together a module or a
> DBD for Lotus Notes, for unix. I know ODBC could work, that requires
> NotesSQL from what I understand, and Lotus only makes a windows version.
> Thanks in advance.
>
>
You could use eval to trap the error - you might be able to get the value of
ERID if you use bind_columns (only guessing). I attached a bit of code to
give you the general idea (untested).
--
Simon Oliver
$dbh->{RaiseError}=1;
$sth = $dbh->prepare("SELECT ERID,ERSDESC FROM EVENTREIHE where
37 matches
Mail list logo
