On Wed, 25 Aug 2004, Registry wrote:
N. B.
my $sth2 = $DBH2 ->prepare( SELECT ...);
my $rv2 = $sth2->execute();
not $DBH
Thank you in advance.
Okay
I am running DBI and if the query doesnt work I want to write the data
from the to one file and the error to another:
E.g.
my $sth;
$sth = $dbh->prepare
(qq(insert into $table
(RecordNum, Src_File, Src_Line, MSW_ID, Status,
Status_Desc, Last_M
re output from
STDOUT to a file:
./file.pl | tee -a err.log
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Joel West [mailto:[EMAIL PROTECTED]
Sent: Monday, August 23, 2004 10:07 AM
To: Reidy, Ron
Cc: [EMAIL PROTECTED]
Subject: RE: Error logs fo
-
From: Joel West [mailto:[EMAIL PROTECTED]
Sent: Monday, August 23, 2004 9:38 AM
To: [EMAIL PROTECTED]
Subject: Error logs for DBI
How do I create log files with just errors?
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or
How do I create log files with just errors?
I found it..duh!
On Fri, 20 Aug 2004, Joel West wrote:
I am much closer than before:
I compiled FreeTDS from source.
tsql connects no problems
DBD::Sybase compiles no problem and no longer causes errors.
BUT
#!/usr/local/perl
#
use DBI;
use DBD::Sybase;
my $server="192.168.100.2"
I am much closer than before:
I compiled FreeTDS from source.
tsql connects no problems
DBD::Sybase compiles no problem and no longer causes errors.
BUT
#!/usr/local/perl
#
use DBI;
use DBD::Sybase;
my $server="192.168.100.2";
my $uid="ss_userid";
my $dbh = DBI->connect("dbi:Sybase:$server", '$uid'
om the unixODBC package
#[MySQL]
#Description= ODBC for MySQL
#Driver = /usr/lib/libmyodbc.so
#Setup = /usr/lib/libodbcmyS.so
#FileUsage = 1
I am still horribly lost.
On Wed, 18 Aug 2004, amonotod wrote:
From: Joel West <[EMAIL PROTECTED]>
Date: 2004/08/18 Wed PM 05
= /usr/lib/libodbcmyS.so
#FileUsage = 1
I am still horribly lost.
On Wed, 18 Aug 2004, amonotod wrote:
From: Joel West <[EMAIL PROTECTED]>
Date: 2004/08/18 Wed PM 05:33:54 GMT
my $dsn = "DBI:ODBC:databasename:ipaddress";
(Assuming you're on Windows...)
my $d
Actually I'm on Linux.
- Original Message -
From: "amonotod" <[EMAIL PROTECTED]>
To: "Joel West" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, August 18, 2004 5:42 PM
Subject: Re: MySQL to MS SQL Server
> > From: Joel West &
Greetings,
I've read what I can so far about the topic and have resisted posting but
I am at a dead end.
I need to move data from a mysql server to an MS SQL server on another
machine. Retrieving the data from the mysql server is easy. I had that
done in a few minutes using DBI.
Now I am attem
11 matches
Mail list logo
