DBD::DB2 where to get a client library

2006-06-01 Thread Martin J. Evans
I'm posting this on behalf of a colleague who is struggling to get DBD::DB2 working on a machine remote to the DB2 database. We have DB2 installed and DBD::DB2 working on that machine but where can we download only the DB2 client (or whatever DBD::DB2 needs) to use DBD::DB2 to connect to a remote

Re: Problems with Error Handling

2006-06-01 Thread Tim Bunce
On Wed, May 31, 2006 at 08:57:23PM -0700, Don Mies wrote: Tim, et. al. Following is a small sample program that demonstrates my problem: my $stmtHandle = $dbHandle-prepare ( $insert ); $dbHandle-{AutoCommit} = 0; $dbHandle-{PrintError} = 0; $dbHandle-{RaiseError} = 1;

Re: DBD::DB2 where to get a client library

2006-06-01 Thread Shlomi Fish
On Thursday 01 June 2006 12:08, Martin J. Evans wrote: I'm posting this on behalf of a colleague who is struggling to get DBD::DB2 working on a machine remote to the DB2 database. We have DB2 installed and DBD::DB2 working on that machine but where can we download only the DB2 client (or

RE: perl- dbi

2006-06-01 Thread R, Rajsekar
Hi, I am getting this error . please let me know.. what needs to be done further perl -MDBI -e 'print $DBI::VERSION\n' Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .).

Re: DBD::DB2 where to get a client library

2006-06-01 Thread Dan Scott
Hi Martin: You'll need the Application Development Client, which is a free download from http://ibm.com/db2/udb/support/downloadv8.html. The clients are installed as RPMs on Linux using the db2setup program (part of the client); you might want to check out the DB2 HOWTO

Re: perl- dbi

2006-06-01 Thread Jonathan Leffler
On 6/1/06, R, Rajsekar [EMAIL PROTECTED] wrote: I am getting this error . please let me know.. what needs to be done further perl -MDBI -e 'print $DBI::VERSION\n' Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503

Re: perl- dbi

2006-06-01 Thread Jonathan Leffler
On 6/1/06, Jonathan Leffler [EMAIL PROTECTED] wrote: On 6/1/06, R, Rajsekar [EMAIL PROTECTED] wrote: I am getting this error . please let me know.. what needs to be done further perl -MDBI -e 'print $DBI::VERSION\n' Can't locate DBI.pm in @INC (@INC contains:

Interpreting COLUMN_DEF from column_info

2006-06-01 Thread Daniel Kasak
Hi all. When I'm talking to MySQL, I can easily get the default for a column from the COLUMN_DEF key from column_info. However when I'm talking to SQL Server, it doesn't return an actual value, but a 'create default' statement such as: CREATE DEFAULT dbo.Contacts_Salutations_D AS 'Mr' Is there