Installing DBI::Profile on VMS

2004-08-18 Thread Lamb Joseph
I need to manually install DBI::Profile on a VMS server. Will profile work on VMS(v5.6.1 built for VMS_AXP)? Can I copy the following files to VMS from my WIN32 box to get DBI::Profile to work? profile.pm profiledumper.pm profiledata.pm Are = Joseph Lamb

Re: MySQL to MS SQL Server

2004-08-18 Thread Joel West
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 <[EMAIL PROTECTED]> > > Date: 2004/08/18 Wed PM 05:

Re: DBD-ORACLE-1.15 on HPUX 11.23 Itanium

2004-08-18 Thread Tim Bunce
Please retry with http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc6-20040807.tar.gz Tim. On Wed, Aug 18, 2004 at 04:52:30PM +1000, WALKER, Dwight wrote: > > Has anyone got DBD-Oracle 1.15 going on HPUX 11.23 Itanium with Oracle 9.2.0.5?

Re: DBI, Oracle and Pro*C

2004-08-18 Thread Tim Bunce
On Tue, Aug 17, 2004 at 12:26:06PM -0600, Ian Harisay wrote: > I'm working on a PERL project at work, but my boss wants me to do just > enough in Pro*C that it won't integrate with my PERL designs. Why? > Is anyone aware of any PERL/C extentions that allow Pro*C functions to > be called by PERL?

DBD::ADO and CommandTimeout

2004-08-18 Thread David N Murray
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 Catalog=db;CommandTimeout=900"); die "Connect failed: " . $D

Re: MySQL to MS SQL Server

2004-08-18 Thread amonotod
> 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 $dsn = "DBI:ODBC:driver={SQL Server};Server=ipaddress;database=databasename;"; > Joel (Yossel) West HTH, amonotod -- `\|||/

Re: DBD::CSV

2004-08-18 Thread Peter L. Berghold
On Wed, 2004-08-18 at 13:51, Robert wrote: [snip] > my $sel1 = $dbh1->prepare("SELECT * FROM table1"); > my $sel1->execute(); [snip!] > "my" variable $sel1 masks earlier declaration in same scope at test4.pl line 21. > Can't call method "execute" on an undefined value at test4.pl line 21. > You'

RE: :CSV

2004-08-18 Thread Andy Hassall
> my $sel1 = $dbh1->prepare("SELECT * FROM table1"); > my $sel1->execute(); You need to remove the 'my' from the second line. It's declaring a new $sel1, which masks the previous one (hence the first warning) and as it's a new variable it'll be undef, but you're trying to call an execute method o

DBD::CSV

2004-08-18 Thread Robert
Hi list, I can't figure out why this simple code is failing, please help. #!/usr/bin/perl -w use DBI; use strict; use DBI qw(:sql_types); DBI->trace( 1, 'dbitrace.log' ); my $dbh1 = DBI->connect("DBI:CSV:"); $dbh1->{'csv_tables'}->{'table1'} = { 'eol' => "\n", 'sep_char' => "|"

Installing DBD Oracle

2004-08-18 Thread Vinnie Lima
Are you required to have access to Oracle libraries when installing the DBD Oracle perl module in an UNIX machine? Thanks, v. This is a PRIVATE message. If you are not the intended recipient, please delete

Again mod_perl and DBI and DBD-Sybase and a WARNING

2004-08-18 Thread Miguel Covas O'Ryan
After a several months struggling with it I've been able to use DBI with mod_perl on a HP-UX machine and a Sybase server. I had to install DBI 1.43 and DBD Sybase 1.04 There are several issues with this bussines. First of all the question of locating the interfaces file for Sybase. Using mod_perl

MySQL to MS SQL Server

2004-08-18 Thread 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

RE: bind_param place holder

2004-08-18 Thread Reidy, Ron
If you are using Oracle, think temporary table. -- Ron Reidy Sr DBA Array BioPharma, Inc. -Original Message- From: Xinyu Wen [mailto:[EMAIL PROTECTED] Sent: Wed 8/18/2004 9:14 AM To: DBI List Cc: Subject:bind_param place holder I have a query like this: select a fro

bind_param place holder

2004-08-18 Thread Xinyu Wen
I have a query like this: select a from some_table where b in (?); I neet to bind 1000 items for b which likes: select a from some_table where b in ('abc','bcd','acd',x1000); how can I bind this many parameters without actually put 1000 "?" in the sql statement and write 1000 "sth->bind_par

Re: DBD::ADO connect error...

2004-08-18 Thread amonotod
} > From: "Steffen Goeldner" <[EMAIL PROTECTED]> > Date: 2004/08/18 Wed AM 08:25:50 GMT > > Don't know what triggers the 'uninitialized' warning. Line 595 of DBI.PM is where the username and password are passed off to the $drh. Since the password is null (I'm connecting to an Access DB with no

Re: New info on an old Thread: Selecting a record from a table where a column might be null

2004-08-18 Thread Tim Bunce
Very helpful. Thanks Brian. Tim. On Wed, Aug 18, 2004 at 12:34:11AM -0500, CAMPBELL, BRIAN D (BRIAN) wrote: > I recently encountered some new info to add to an old thread to which I contributed. > > > > Old Thread > > > > Briefly I responded to a query someone made about generalizing WHER

Re: DBD::ADO connect error...

2004-08-18 Thread Steffen Goeldner
amonotod wrote: > > From: amonotod <[EMAIL PROTECTED]> > > Date: 2004/08/17 Tue PM 08:25:11 GMT > > > > Use of uninitialized value in subroutine entry at C:/Perl/site/lib/DBI.pm line 595. > > DBD::ADO::dr connect warning: at C:/Perl/site/lib/DBI.pm line 595. > > Sorry, I didn't mean to forget: >

DBD-ORACLE-1.15 on HPUX 11.23 Itanium

2004-08-18 Thread WALKER, Dwight
Has anyone got DBD-Oracle 1.15 going on HPUX 11.23 Itanium with Oracle 9.2.0.5? There is a lot of info re 64bit PA-RISC but very little with Itanium. Most of the info in the README.hpux and the various forums are very misleading as it makes assumptions that HPUX 11i is the PA RISC versions. I