Extracting SQL Server image data as strings

2004-01-16 Thread Mark Buckle
Does any-one have any experience in extracting image data as strings ? I'm trying to output the data from a table as a set of insert statements, one of the columns is an image column, and although I can successfully output the data and apparently re-load it, the application that uses it

Re: DBD::ADO and ODBC Information Code

2004-01-16 Thread Steffen Goeldner
Peter Hircock wrote: Thanks, I had a feeling this was not a quick fix. The $dbh-errstr is all from the execute() Umm, maybe I need a trace. But I know you are a courageous boy - thus try this first, please: use Win32::OLE(); my $cxn = Win32::OLE-new('ADODB.Connection');

Binary releases for DBI and DBD:Oracle for ActivePerl Build 808

2004-01-16 Thread Paul Clements
Hi, I have just downloaded 5.8.2 Build 808 from ActiveState and the 5.8.2 branch of DBI and DBD:Oracle from ftp.esoftmatic.com/outgoing/DBI/5.8.2 Unfortunately I get the error The procedure entry point Perl_Glockhook_ptr could not be located in the dynamic link library perl58.dll From

Fw: DBD::INFORMIX

2004-01-16 Thread
-Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Fri, 16 Jan 2004 11:43:18 +0300 Subject: DBD::INFORMIX Dear Jonathan! Please help me, I am beginner in Perl. I run two step for install DBD-Informix-2003.04 : Step 1 : perl makefile.pl 1.txt- OK!

RE: Binary releases for DBI and DBD:Oracle for ActivePerl Build 808

2004-01-16 Thread Jeff Urlwin
Hi, I have just downloaded 5.8.2 Build 808 from ActiveState and the 5.8.2 branch of DBI and DBD:Oracle from ftp.esoftmatic.com/outgoing/DBI/5.8.2 Unfortunately I get the error The procedure entry point Perl_Glockhook_ptr could not be located in the dynamic link library perl58.dll

RE: Binary releases for DBI and DBD:Oracle for ActivePerl Build 808

2004-01-16 Thread Paul Clements
Jeff, Thanks for getting back to me as requested I have appended the results of perl -v are This is perl, v5.8.2 built for MSWin32-x86-multi-thread (with 25 registered patches, see perl -V for more detail) Copyright 1987-2003, Larry Wall Binary build 808

Can't make DBD

2004-01-16 Thread Nigel Henden
Can't seem to get DBD module installed. The DBI module installed fine. Here is as far as I get (the last nine lines), after typing make LD_RUN_PATH=/u01/app/oracle/product/9.2.0.1.0/lib:/u01/app/oracle/product/9.2.0.1.0/rdbms/lib gcc -G -z ignore -z lazyload -z combreloc -L /usr/local/lib

Re: Can't make DBD

2004-01-16 Thread Sean Kelly
Quoting Nigel Henden [EMAIL PROTECTED]: Here is as far as I get (the last nine lines), after typing make [SNIP] ld: warning: option -o appears more than once, first setting taken chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so chmod: WARNING: can't access blib/arch/auto/DBD/Oracle/Oracle.so

RE: Binary releases for DBI and DBD:Oracle for ActivePerl Build 808

2004-01-16 Thread Jeff Urlwin
It sounds like you were running the older .dll from the newer perl. Are you sure you: a) Didn't have the Oracle.dll loaded so that ppm failed to overwrite it? (reboot and re-run ppm should fix it, I would think) b) On one machine, when I overwrote 5.6.1 (build

Re: Extracting SQL Server image data as strings

2004-01-16 Thread Michael Peppler
On Fri, 2004-01-16 at 01:21, Mark Buckle wrote: Does any-one have any experience in extracting image data as strings ? I'm trying to output the data from a table as a set of insert statements, one of the columns is an image column, and although I can successfully output the data and apparently

Re: Can't make DBD

2004-01-16 Thread Tim Bunce
On Fri, Jan 16, 2004 at 02:34:30PM +, Sean Kelly wrote: Quoting Nigel Henden [EMAIL PROTECTED]: Here is as far as I get (the last nine lines), after typing make [SNIP] ld: warning: option -o appears more than once, first setting taken chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so

Re: Can't make DBD

2004-01-16 Thread Sean Kelly
Quoting Tim Bunce [EMAIL PROTECTED]: Please try http://homepage.eircom.net/~timbunce/DBD-Oracle-1.15-rc2-20040112.tar.gz This version does not require me to remove -o build strings from GCC commands - that problem seems to have gone away :) It does not, however, compile cleanly as it's

DBI: Why don't statement handles fail after $dbh-disconnect?

2004-01-16 Thread Jonathan Leffler
Dear Tim, Consider the following test code - using the NullP driver. #!/bin/perl -w # # Test that statement handles from disconnected connections fail! use strict; use DBI; my $table = dbd_tester; my $dbh = DBI-connect('dbi:NullP:immaterial', '', '', {RaiseError=1});

Re: DBI: Why don't statement handles fail after $dbh-disconnect?

2004-01-16 Thread Tim Bunce
On Fri, Jan 16, 2004 at 12:21:38PM -0800, Jonathan Leffler wrote: Dear Tim, Consider the following test code - using the NullP driver. #!/bin/perl -w # # Test that statement handles from disconnected connections fail! use strict; use DBI; my $table = dbd_tester;

Re: DBI: Why don't statement handles fail after $dbh-disconnect?

2004-01-16 Thread Michael Peppler
On Fri, 2004-01-16 at 14:08, Tim Bunce wrote: On Fri, Jan 16, 2004 at 12:21:38PM -0800, Jonathan Leffler wrote: Dear Tim, Consider the following test code - using the NullP driver. #!/bin/perl -w # # Test that statement handles from disconnected connections fail!

Re: Can't make DBD

2004-01-16 Thread Tim Bunce
On Fri, Jan 16, 2004 at 06:17:13PM +, Sean Kelly wrote: Quoting Tim Bunce [EMAIL PROTECTED]: Please try http://homepage.eircom.net/~timbunce/DBD-Oracle-1.15-rc2-20040112.tar.gz This version does not require me to remove -o build strings from GCC commands - that problem seems

Re: Can't make DBD

2004-01-16 Thread Andy Hassall
Sean Kelly wrote: Quoting Tim Bunce [EMAIL PROTECTED]: Please try http://homepage.eircom.net/~timbunce/DBD-Oracle-1.15-rc2-20040112.tar.gz This version does not require me to remove -o build strings from GCC commands - that problem seems to have gone away :) It does not, however,

Re: DBI: Why don't statement handles fail after $dbh-disconnect?

2004-01-16 Thread Jonathan Leffler
Sorry about a top-posted response - Lotus is what it is. So, the DBI code does not track the statement handles associated with a database handle, and does not invalidate them when the connection is disconnected? DBD::Informix has code that invalidates the statement handles when the $dbh itself

Re: [mp2] DBI failing thread test (win32)

2004-01-16 Thread Steve Hay
[I'm posting this to dbi-users for their attention too, since the second test script at least looks like a DBI/DBD problem, definitely not mod_perl.] Hi Kurt, Kurt George Gjerde wrote: Hi, Not really mod_perl but maybe the same issues as the recent Storable. This was experienced on win32

RE: Cygwin/DBD::ODBC issue

2004-01-16 Thread Jones, Tommie
Hello all. Just to conclude this issue. Not only was there a problem with where sqltypes.h file was located. I also had an issue with 4 or 5 types missing. I had to add a few typedefs like UWORD and PTR to sqltypes.h I'm using the most recent version of cygwin 5.0 (I updated it yesterday. Sorry