Siegfried Heintze wrote:
Is there an example somewhere of accessing an MSAccess database from a SuSE
or RedHat machine via perl DBI?
Here is what I am presently using with ActiveState Perl to access the
MSAccess database on windows:
my $dbh = DBI-connect(dbi:ODBC:driver={Microsoft Access
On 4/4/06 15:31, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote:
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006 4:20 PM
To: Jonathan Mangin; Garrett, Philip (MAN-Corporate);
dbi-users@perl.org
Subject: Re: Not exactly a dbi
Siegfried Heintze wrote:
Is there an example somewhere of accessing an MSAccess database from a SuSE
or RedHat machine via perl DBI?
Here is what I am presently using with ActiveState Perl to access the
MSAccess database on windows:
my $dbh = DBI-connect(dbi:ODBC:driver={Microsoft Access
Olivier Poulet wrote:
Greetings all,
I have scripts that are running on Win32, with an underlying MDAC/ADO
2.8 RTM version, with MSSQL Server 2000 or 2005 as the database. It is
not possible for us to either update/upgrade MDAC itself, and this
version has a bug in the way it handles the
I am preparing a statement like this:
my $sql=EOF;
UPDATE text_table
SET uni_text = ?
WHERE uni_id = $ {uni_id}
EOF
my $sth = $dbh-prepare($sql);
This runs the following in SQL Server:
SET FMTONLY ON SELECT uni_text FROM text_table SET FMTONLY OFF
Out of curiosity, how can I
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED];
dbi-users@perl.org
Sent: Wednesday, April 05, 2006 2:55 AM
Subject: Re: Not exactly a dbi question
On 4/4/06 15:31, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote:
On Tue, 4 Apr 2006 23:40:27 -0600, Siegfried Heintze wrote:
Is there an example somewhere of accessing an MSAccess database from a SuSE
or RedHat machine via perl DBI?
An Access database is best served on a Windows PC. In my experience, you
don't even need to have Access installed for DBI to be
On 4/5/06 7:35, Jonathan Mangin [EMAIL PROTECTED] wrote:
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED];
dbi-users@perl.org
Sent: Wednesday, April 05, 2006 2:55 AM
Subject: Re: Not exactly a dbi question
On
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 2:55 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
On 4/4/06 15:31, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote:
-Original
On 4/5/06 9:26, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote:
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 2:55 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
On
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 10:41 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
[snip]
Sorry, I've been answering your question while assuming the mysql
driver
If you have changed your Oracle client then you will have to at least
recompile DBD:Oracle for that client. If you are working with 10g client
then I would suggest upgrading to Oracle:dbd to 1.17
cheers
Rolando Arquiza [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
We are running
On 4/5/06 9:46, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote:
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 10:41 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 10:56 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
On 4/5/06 9:46, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote:
On 4/5/06 10:04, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote:
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 10:56 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
On 4/4/06, Gupta, Razat [EMAIL PROTECTED] wrote:
We have a coonection through a NAT IP.
Simultaneously , five or six scripts runs and fetch data from the same
server.
Sometimes we got files successfully while sometimes we are getting
error :
UNEXPECTED EOF FILE ON COMMAND CHANNEL.
Hi, I'm trying to run this Perl script against a remote Oracle 10g R1
database. I'm using WinXP and i already have the oracle client software (
10.2.0)
installed and working.
My Perl version is 5.8.7
DBI version is: 1.50
DBD version is: 1.17
#!perl -w
use strict;
use DBI;
my $dbh =
Louis Gonzales schreef:
As far as I know, MSAccess is an application
and doesn't have the robustness of a Database Server
There is MsAccess and there is the Jet-Engine/Desktop-Engine.
See also the content and links on:
http://en.wikipedia.org/wiki/Microsoft_Jet_Database_Engine
--
Affijn,
Paul DuBois schreef:
UPDATE tbl_name SET col_name = 0 WHERE col_name = 0;
If you've selected the rows-changed count, $sth-rows() will always
return 0, because the statement doesn't actually change any col_name
value from its current value.
That would be an odd optimization. The update
On 4/5/06 14:07, Jonathan Mangin [EMAIL PROTECTED] wrote:
- Original Message -
From: Dr.Ruud [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Wednesday, April 05, 2006 11:53 AM
Subject: Re: Not exactly a dbi question
Paul DuBois schreef:
UPDATE tbl_name SET col_name = 0 WHERE
I just inherited a couple of HP servers that I now have to admin. My
'root' account does not have have ORACLE HOME set since we have an
ORACLE user that has that env variable set. The error is after my sig.
I tried it as ORACLE but it cannot write to the .cpan repository so it
errors out.
login as oracle user
execute - env | grep ORACLE_HOME
remember value
logout
login as root
execute - ORACLE_HOME=/whatever/you/saw/a/few/seconds/ago
execute - export ORACLE_HOME
execute - perl -MCPAN -e install 'DBD::Oracle'
Alexander
On 05.04.2006 19:32, Robert Hicks wrote:
I just inherited a
On 3/25/06 6:24 PM, John Siracusa wrote:
I expect the following two pieces of code to give the same result. One is
SQL, fed directly to Postgres using the psql command-line tool, and the
other is Perl code using DBI. Before I file this as a bug in DBD::Pg, I
want to make sure it's not a
Hi,
We're using oracle 8 and 9. I have code running on different
machines. One machine comes out different warnings as the other. I
want to check the version of DBI.
How do I find out the version of the DBI libraries I'm using?
thanks,
Jie
print $DBI::VERSION,\n;
Date: Wed, 05 Apr 2006 13:43:30 -0700
From: Jie Zhang [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: DBI versiion
Hi,
We're using oracle 8 and 9. I have code running on different machines. One
machine comes out different warnings as the other. I want to check
Michael Nhan wrote:
print $DBI::VERSION,\n;
Of for much more info:
perl -MDBI -e DBI-installed_versions
--
Jeff
Date: Wed, 05 Apr 2006 13:43:30 -0700
From: Jie Zhang [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: DBI versiion
Hi,
We're using oracle 8 and 9. I have code
Alexander Foken wrote:
login as oracle user
execute - env | grep ORACLE_HOME
remember value
logout
login as root
execute - ORACLE_HOME=/whatever/you/saw/a/few/seconds/ago
execute - export ORACLE_HOME
execute - perl -MCPAN -e install 'DBD::Oracle'
Alexander
Thank you very much!
Robert
Thanks! It works.
Jie
Michael Nhan wrote:
print $DBI::VERSION,\n;
Date: Wed, 05 Apr 2006 13:43:30 -0700
From: Jie Zhang [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: DBI versiion
Hi,
We're using oracle 8 and 9. I have code running on different
machines. One machine comes out
I tried perl -MDBI -e DBI-installed_versions
I got :
Can't locate auto/DBI/installed_v.al in @INC (@INC contains:
/home01/rrdev/devel/libebay /home01/rrdev/perllib
/home01/rrdev/perllib/sun4-solaris /home04/ian/gbp/bof .
Jie Zhang wrote:
I tried perl -MDBI -e DBI-installed_versions
I got :
Can't locate auto/DBI/installed_v.al in @INC (@INC contains:
The installed_versions() method was added to DBI in version 1.38,
August 2003 so the fact that you got an error means that you have a
version before 1.38 and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Version 1.48 of DBD::Pg has been released. This is mostly
a bug fix version. Another bytea problem was fixed, as well
as an obscure corner case with begin_work() after an error.
The minimum version required for DBI has been raised to 1.45.
CPAN
Right, the version I'm using is 1.25.
Thank you very much!
Jie
Jeff Zucker wrote:
Jie Zhang wrote:
I tried perl -MDBI -e DBI-installed_versions
I got :
Can't locate auto/DBI/installed_v.al in @INC (@INC contains:
The installed_versions() method was added to DBI in version 1.38,
August
32 matches
Mail list logo