David N Murray wrote:
Hi all,
I'm having a heck of a time querying a large table. What I'm trying to do
is:
#!/usr/bin/perl -w
use DBI;
use strict;
$|++;
my $dbh = DBI-connect(dbi:ADO:Provider=SQLOLEDB;Integrated Security=SSPI;Data
Source=(local);Initial
On Wed, Aug 18, 2004 at 01:49:03PM -0400, Vinnie Lima wrote:
Are you required to have access to Oracle libraries when installing the
DBD Oracle perl module in an UNIX machine?
This information is in the README file distributed with DBD-Oracle:
Install enough Oracle software to enable
On Wed, Aug 18, 2004 at 04:25:14PM -0700, Lamb Joseph wrote:
I need to manually install DBI::Profile on a VMS server.
Why manually?
It should have been installed when the DBI was installed on that VMS server.
If there's no DBI on that server, or the DBI doesn't include DBI::Profile,
then just
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Could you also tell us a bit about the issue of installation on windows
- will DBD::Pg be able to find the libraries it needs and compile on
windows? will there also be binary versions available for download?
Many people are using DBD::PgPP
I run DBD::Pg 1.22 on a windows host successfully. I initially tried
DBD::PgPP and found it buggy. The Pg installation took a fair amount of
fussing but runs very well. -Alec
Could you also tell us a bit about the issue of installation on windows
- will DBD::Pg be able to find the libraries
I tried the below on the RedHat box I am on and got a different error:
DBI connect('driver={SQL
Server};Server=ipaddress ;database=databasename','userid',...) failed: [unixODBC][Driver Manager]
Data source name not found, and no default driver specified (SQL-IM002)(DBD: db_login/SQLConnect
From: Joel West [EMAIL PROTECTED]
Date: 2004/08/19 Thu PM 12:24:30 GMT
Server};Server=ipaddress ;database=databasename','userid',...) failed:
[unixODBC][Driver Manager]
Data source name not found, and no default driver specified (SQL-IM002)(DBD:
db_login/SQLConnect err=-1) at
dump1.pl
On Aug 19, Steffen Goeldner scribed:
David N Murray wrote:
Hi all,
I'm having a heck of a time querying a large table. What I'm trying to do
is:
[snip my sample code]
Does this
my $dbh = ...
$dbh-{ado_commandtimeout} = 0;
my $sth = ...
print
I tried the below on the RedHat box I am on and got a different error:
DBI connect('driver={SQL
Server};Server=ipaddress
;database=databasename','userid',...) failed:
[unixODBC][Driver Manager] Data source name not found, and no
default driver specified (SQL-IM002)(DBD:
Alec Brecher wrote:
I run DBD::Pg 1.22 on a windows host successfully. I initially tried
DBD::PgPP and found it buggy. The Pg installation took a fair amount of
fussing but runs very well. -Alec
Whoa, you are a better man than I am, Alec :-). I was never able to get
past the fussing stage.
Jeff Zucker wrote:
Alec Brecher wrote:
I run DBD::Pg 1.22 on a windows host successfully. I initially tried
DBD::PgPP and found it buggy. The Pg installation took a fair amount of
fussing but runs very well. -Alec
Whoa, you are a better man than I am, Alec :-).
Oops, I take it back :-). I
I am trying to get DBD::JDBC running on my Linux box - OpenBase 8.0.3 b4
I have successfully downloaded and installed
DBI
Convert::BER
DBD::JDBC
The files dbd_jdbc.jar and OpenBaseJDBC.jar both reside in the
directory /home/OpenBase/Java/Extensions
I am using the following command to start the
Task: Set the number format to 16 decimal positions for Oracle DBI session.
Versions: Perl 5.6.1, DBI 1.42, DBD::Oracle 1.14, Oracle 8.1.7 on Solaris.
I guess Oracle doesn't have 'ALTER SESSION' command for setting Number
Format at session level.
Basically how can i set those SQLPLUS options (
The SQL*Plus 'set' commands are used for display purposes only to STDOUT. To get the
correct formatting of variables, use 'sprintf()'.
See perldoc -d sprintf.
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Ravi Kongara [mailto:[EMAIL PROTECTED]
I won't be able to use sprintf( ), b'coz column type is not known. Query
includes both
numeric and character columns. I may have to check for each column
whether it's a NUMBER or not, and then apply
sprintf, which i'm not in favour of. Instead if a set number format (
like date format) at
Ravi,
Why not try something like testing the var using Posix functions to determine if it is
a number and then sprintfing ?
Ravi Kongara wrote on 8/19/2004, 6:25 PM:
I won't be able to use sprintf( ), b'coz column type is not known. Query
includes both
numeric and character columns. I
You are right, but my intention is to avoid the Test itself.
Ravi
Chuck Fox wrote:
Ravi,
Why not try something like testing the var using Posix functions to determine if it is
a number and then sprintfing ?
Ravi Kongara wrote on 8/19/2004, 6:25 PM:
I won't be able to use sprintf( ), b'coz
Look at the type_info() sub routine.
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Ravi Kongara [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 19, 2004 4:53 PM
To: Chuck Fox
Cc: DBI-Users
Subject: Re: how to format query results
You are right,
So
I compiled FreeTDS from souce.
tsql - The FreeTDS utility connects okay.
unixODBC would not compile so I am using iODBC
DBD::Sybase compiles lovely and gives the following error if used:
[EMAIL PROTECTED] joelonx]# perl -w
use DBD::Sybase;
Can't load
19 matches
Mail list logo