On Mon, Mar 08, 2004 at 04:31:01PM +, Tim Bunce wrote:
Just a quick question...
Consider this scenario: a table with a timestamp column like this:
CREATE TABLE foo (
int key,
int foo,
timestamp last_update,
PRIMARY KEY (key),
KEY (last_update)
)
Hello...
I have the connection working properly on the local machine:
my $dbh = DBI-connect('dbi:ODBC:DBName', 'name', 'pword');
But I can't figure out the syntax to connect to a MS SQL
database on a remote machine. I've tried:
my $dbh =
I think what you want is 'dbi:ODBC:DSNName', where DSNName is the name
of the DSN you are using to connect to the database. Works for me...
-Original Message-
From: McMahon, Chris [mailto:[EMAIL PROTECTED]
Sent: Monday, March 15, 2004 10:44 AM
To: [EMAIL PROTECTED]
Subject:
The syntax is ...'DBI:ODBC:DSName...' where DSName is the data source
name you previously defined for the ODBC connection. It's under Control
Panel/Administrative tools for XP and various other places for other
OSs. The name or name or IP address of the remote host is specified when
you configure
Friends
I installed DBI::Oracle and DBD::Oracle. The latter required modifying the
Makefile.PL according to the correspondence of Tim et al in this
mail-list, in late February. Essentially, one existing line of the makefile
was changed and one new line was added.
Then the perl Makefile.PL
The system environment for my query about getting DBD:Oracle to work is:
AIX 5.2
Oracle 9.2.0
AIX 6.0 compiler using xlc_r
perl 5.8.0
DBI 1.14
N. Hirsh
Computer SysAdmin
Steel Warehouse
South Bend IN
We have modified our servers to set the maximum packet size to 4096, up from 512. We
did this because the main app (commercial software) we use works MUCH better with it.
This app requires us to set a flag on its command line (the size to use, in this case
4096) to pass down to Sybase in order
On Mon, 15 Mar 2004 17:58:42 -0800, Michael Peppler wrote:
On Mon, 2004-03-15 at 17:28, Matthew O. Persico wrote:
We have modified our servers to set the maximum packet size to
4096, up from 512. We did this because the main app (commercial
software) we use works MUCH better with it. This app
hai, i have change with :
my ($nik, $password, $scode) = @_;
when i execute the scripts, the scripts can't execute
and the error of scripts is :
DBD::mysql::st execute failed: Column 'nik' cannot be
null at insert_sql.pl line 36, line 1.
Unable to execute query:
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.42.tar.gz
size: 348167 bytes
md5: ca8c8a1a4797d98121b41c1d0a5b3b7c
=head1 CHANGES in DBI 1.42 (svn rev 222),12th March 2004
Fixed $sth-{NUM_OF_FIELDS} of non-executed statement handle
to be undef as per the docs (it was 0).
Fixed
I'm having a problem using DBIx::Chart when my table
contains zeros. I am charting a table that contains a
date and 3 integers. A chart is generated OK as long
as none of the integer columns contain a zero. If any
integer has the value of zero, I don't see any error
messages but an empty image
11 matches
Mail list logo
