Ron Savage wrote:
On Sat, 08 Mar 2003 22:28:09 -0500, Scott R. Godin wrote:
Hi Scott
I've written a very nice module-reporting script that helps me to
stay on
top of installed modules and easily see when they require updates
from CPAN
for bugfixes.
http://www.webdragon.net/mr/
Great
Hi all,
I am an absolute newbie to DBI and have read the documentation and am
still unsure.
I am attempting to connect to a SQL7 DB that is on a server other than
the webserver. I am unsure as to what the connection string will be?
use DBI;
my $dbh = DBI-connect
Hi,
I'm trying to insert date type values in SQL Server 7.0, but I always
get the next error:
DBD::ODBC::st execute failed: [unixODBC] Msg 8115, Level 16, State 2,
Server PROSDK01, Line 1
The table in SQL Server is defined as:
create table pruebas (char codigo not null, char valor not null,
On Mon, 24 Mar 2003 03:43:20 -0800 Barlow, Neil [EMAIL PROTECTED] wrote:
I am attempting to connect to a SQL7 DB that is on a server other than
the webserver. I am unsure as to what the connection string will be?
Is SQL7 a new name for mSQL?
use DBI;
my $dbh = DBI-connect
On Monday, March 24, 2003, at 08:14 PM, Tim Bunce wrote:
It would be great to have any further Makefile.PL and README.macosx
patches soonish.
I'm working on an updated README.macosx to cover the new install
instructions - which will hopefully be even more simple if I can get
this Makefile
On Mon, 24 Mar 2003 13:18:58 +0100 Illera, Fernando [EMAIL PROTECTED] wrote:
I'm trying to insert date type values in SQL Server 7.0, but I always
get the next error:
DBD::ODBC::st execute failed: [unixODBC] Msg 8115, Level 16, State 2,
Server PROSDK01, Line 1
The table in SQL Server is
Since Neil is running a windows box with IIS (his script is at
Z:\InetPub\scripts\driver.pl), I think it is safe to assume that by SQL7
he meant MS SQL Server 7.
-Josh
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 8:11 AM
To: Barlow,
On Mon, 24 Mar 2003 08:37:18 -0500 Joshua Caesar [EMAIL PROTECTED] wrote:
Since Neil is running a windows box with IIS (his script is at
Z:\InetPub\scripts\driver.pl), I think it is safe to assume that by SQL7
he meant MS SQL Server 7.
In which case he should be using DBD::Sybase or
That's is correct - I am attempting to connect a MS SQL7 DB that is not
located on the Webserver.
Would you have some sample code that illustrates connecting to a remote
DB using either DBD::Sybase or DBD::ODBC?
Thanks for your help
NeilB
-Original Message-
From: Michael A Chase
Thanks Mac.
I have tried as you recommended:
my($now) = time();
my($transaction) = $dbh-prepare(INSERT into PRUEBAS(CODIGO, VALOR,
FECHA) VALUES(?, ?, CONVERT(datetime, ?)));
$transaction-bind_param(1, '10101', {TYPE = SQL_CHAR});
$transaction-bind_param(2, '20202', {TYPE = SQL_CHAR});
Illera, Fernando wrote:
Thanks Mac.
I have tried as you recommended:
my($now) = time();
Here's your problem.
time() returns the number of seconds since the epoch which I think DBMS
will struggle with.
You need to convert that time() value to something more usefull, you might
get away with
On Mon, 24 Mar 2003 05:45:59 -0800 Barlow, Neil [EMAIL PROTECTED] wrote:
That's is correct - I am attempting to connect a MS SQL7 DB that is not
located on the Webserver.
Would you have some sample code that illustrates connecting to a remote
DB using either DBD::Sybase or DBD::ODBC?
There
On Mon, 24 Mar 2003 05:45:59 -0800, Barlow, Neil wrote:
That's is correct - I am attempting to connect a MS SQL7 DB that is not
located on the Webserver.
You could start by using Windows' ODBC Data Sources control panel to
create a (system) DSN. Next, all you have to do is use the DSN name in
On Mon, 24 Mar 2003 14:56:24 +0100 Illera, Fernando [EMAIL PROTECTED] wrote:
my($now) = time();
my($transaction) = $dbh-prepare(INSERT into PRUEBAS(CODIGO, VALOR,
FECHA) VALUES(?, ?, CONVERT(datetime, ?)));
$transaction-bind_param(1, '10101', {TYPE = SQL_CHAR});
$transaction-bind_param(2,
I have switched webhosts. I cannot get DBI and DBD working correctly from
a local directory on that host. (Readyhosting does not have installed --
and will not install -- DBI or DBD:ODBC.)
Hmmm, is the server a windows box?
If it is, just build it on your local box and FTP it up.
Thank you very much, Simon.
The insert transaction has made succesfully after aplying the convert
subroutine you suggested.
Thanks a lot for your help.
Fernando Illera
-Mensaje original-
De: Simon Oliver [mailto:[EMAIL PROTECTED]
Enviado el: lunes, 24 de marzo de 2003 15:35
Para:
I have a Perl cron job that reads emails off a pop server once a
minute and stores them in a MySQL database on a remote machine. I
logged onto the MySQL server today and performed a select * from
messages where received 2003032200; Zero records were
returned.
I did some more
Dear Sirs, could you help me in resolving the following error installing
DBD under Slackware? Here is the error:
bash-2.05a# perl Makefile.PL
Using DBI 1.33 installed in
/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBI
Duplicate specification S=s for option s
Configuring DBD::Oracle
Upgrade to DBD::Oracle 1.13 first, then try again.
Tim.
On Mon, Mar 24, 2003 at 04:57:44PM +0100, Salvatore Sorrentino wrote:
Dear Sirs, could you help me in resolving the following error installing
DBD under Slackware? Here is the error:
bash-2.05a# perl Makefile.PL
Using DBI 1.33
One way to handle this is to validate what you just inserted into the
database. Once you are sure of the success of your insert then delete it
from the pop server. I don't know how light weight you trying to keep
your program. This would certainly add some overhead not only to your
database
I am having a problem getting this to work and the documentation
I have found doesn't seem to be helping, hopefully someone out there
can help me.
I am using MySQL 4.01-Gamma on a Debian Linux box. I have configured
MySQL exactly as the manual shows in Section 4.3.9 - Using Secure
Connections,
All
Before submitting the following issue as a bug report,
I wanted to run it by this list, in order to:
a) Check that I am not missing something.
b) Get an opinion on whether the issue is with DBI or DBD::Sybase.
My toolchain is as follows:
Perlv5.8.0
DBI v1.35
On Sun, 23 Mar 2003 16:37:43 -0500, Scott R. Godin wrote:
Ron Savage wrote:
Hi Scott
Yes, unfortunately there's no default $ENV{TEMP} on unix..
I've been considering using File::Temp, File::MkTemp, or IO::File
instead,
but just haven't gotten around to futzing with it. :-)
OK
File::Spec would
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 4:58 PM
To: [EMAIL PROTECTED]
Subject: OLDB - ODBC
Does this belong in the DBI list? Sorry if the answer is yes.
*
Hi,
We have a problem. We run Perl for Window NT. We
On Mon, 24 Mar 2003 17:12:39 +0100 NYIMI Jose (BMB) [EMAIL PROTECTED] wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 4:58 PM
To: [EMAIL PROTECTED]
Subject: OLDB - ODBC
Does this belong in the DBI list? Sorry if the
On Mon, 2003-03-24 at 11:48, [EMAIL PROTECTED] wrote:
All
Before submitting the following issue as a bug report,
I wanted to run it by this list, in order to:
a) Check that I am not missing something.
b) Get an opinion on whether the issue is with DBI or DBD::Sybase.
select foo from
26 matches
Mail list logo
