The sql shell that comes with DBI (DBI::Shell or dbish) includes a
describe command. The results vary based on the version of DBD::Pg
installed, but it attempts to translate the type value to a name.
(See DBI/Shell.pm for complete code)
Here's how it determines the types:
...
my $sth = $dbh-
I've found these modules work well for creating excel spreadsheets.
Spreadsheet::ParseExcel
Spreadsheet::WriteExcel
I recently wrote a script that converts csv files into worksheets in a
workbook. Makes it easier for a client to review their different
reports.
Tom
On Fri, Jun 27
I'd say you've a bad DBI install. Does this script print the DBI
version number?
#!/usr/bin/perl
use DBI;
print "$DBI::VERSION\n";
@driver_names= DBI->available_drivers();
print "the drivers are : @driver_names";
exit;
perl -w t.pl
1.20
the drivers are : ADO AnyData CSV Chart ExampleP Excel
using DBD::ADO:
set DBI_DSN=dbi:ADO:Provider=SQLOLEDB.1;Persist Security Info=False;Initial
Catalog=pubs;Data Source=STLNTWK1
set DBI_USER=userid
set DBI_PASS=passwd
Modify Data Source to the host machine name.
Tom
On Fri, Dec 14, 2001 at 12:14:20AM -0800, scott.lutz wrote:
> I am looking for
Hello All,
Working on a "load" type function for sql files.
This is a quote from perldoc File::Basename
"You are guaranteed that if you concatenate path, name,
and suffix together in that order, the result will
denote the same file
Here is a simple example using an mdb file and DSN-Less connection:
#!perl
# vim:ts=4:sw=4:ai:aw:
use strict;
use DBI;
# Simple connect and select script using DSN-Less ADO connection.
my $dsn =
q{dbi:ADO:Provider=Microsoft.Jet.OLEDB.4.0; Data Source=.\mytest.mdb};
# User and Password
There are a number of ways: DBI using DBD::ADO or DBD::ODBC,
Win32::ODBC, or Win32::OLE. My personal favorite is DBI using
DBD::ADO.
Tom
On Sun, Oct 28, 2001 at 12:37:46PM -0800, Scott Lutz wrote:
> I am wondering what the best way to connect to a MS Access database table to extract
>email ad
Edd,
One possibility is during the select statement:
select
sysdate
,trunc(sysdate) - 2
,to_date( '28-AUG-2001' ) - (trunc(sysdate) - 2)
,to_date( '27-AUG-2001' ) - (trunc(sysdate) - 2)
,to_date( '26-A
Graham,
I tested DBD::ODBC to FileMaker Pro a few years back on NT. The
solution worked poorly (from what I remember). A instance of the
FileMaker application had to running to connect, but the database
could not be opened in the application.
The FileMak
On Wed, Aug 15, 2001 at 08:07:25AM -0400, Steve Starer wrote:
> I am the perl administrator here, and new to both perl as a programming
> language, and as the site admin. I've got no problem getting modules. My
> question is how do I remove them? In particular, I'm in a Solaris site, and
> had to
On Tue, Aug 14, 2001 at 10:33:31AM -0400, Yacketta, Ronald wrote:
>
> Please be open and honest, I am looking to speed up the script and make it
> more efficient as well
>
> sub get_oracle_time () {
> # Lets get the time it takes to connect to oracle
> my ( $key, $value );
> $orati
On Wed, Aug 08, 2001 at 09:07:31AM -0700, E. Alan Hogue wrote:
> I need to hook up to an Access database running, of
> course, on a win32 system. I am completely new to DBI.
> I found a DBD on CPAN for ODBC, but the documentation
> attached to it only covered using it with Cygwin. I
> would love
12 matches
Mail list logo
