Re: Connecting from Linux onto MS-SQL-Server

not the fastest solution. But hey, it's free! Alexander On 10.06.2006 14:58, Tom Schindl wrote: Hi, I read the POD of DBD::ODBC but there's only the commercial from http://www.openlinksw.com mentionned, isn't there an open version available? I only need read access from Linux to MS-SQL. Tom

Re: Connecting from Linux onto MS-SQL-Server

Hi Dean, thanks that sounds promising, I'll give it a try. Many many thanks Tom Dean Arnold schrieb: On 10.06.2006 14:58, Tom Schindl wrote: Hi, I read the POD of DBD::ODBC but there's only the commercial from http://www.openlinksw.com mentionned, isn't there an open version available

Connecting from Linux onto MS-SQL-Server

Hi, I read the POD of DBD::ODBC but there's only the commercial from http://www.openlinksw.com mentionned, isn't there an open version available? I only need read access from Linux to MS-SQL. Tom signature.asc Description: OpenPGP digital signature

Re: insertion through dbi

Baserdem, Mehmet wrote: Hi all, I am trying to insert 16K records into some table through DBI. But my script only inserts the last record. I check the array size and the sql return values. Everything seems normal. Any ideas? Regards, Mehmet Baserdem Here is the my script:

Re: does disconnect() actually commits transaction even if the connect is made using autocommit=0

man DBI: ---8--- ... The transaction behaviour of the disconnect method is, sadly, undefined. Some database systems (such as Oracle and Ingres) will automatically commit any outstanding changes, but others (such as Informix) will rollback any outstanding changes.

Re: does disconnect() actually commits transaction even if the connect is made using autocommit=0

Well I was already familiar with this behaviour because it's the same with JDBC-Drivers. Tom Martin J. Evans wrote: On 07-Apr-2006 Jie Zhang wrote: Hi, If I initiate a connection using autocommit=0 in DBI and I don't do a explicit connection-commit(), should transactions automatically

Re: DBI::ODBC in a web application

Well I think that you problem is a environment problem as already outlined. If you need to have access to ENV-Variables you must forward them explicitly to the cgi because they are not passed by default because of security risks. For more information see:

Re: mysql problem

The statement has to look like this: SELECT * FROM logs where datetime like ? Tom Jason Friedman wrote: my $sth = $dbh-prepare(SELECT * FROM logs where datetime like '?') or die $dbh-errstr; print Enter datetime: ; while ($datetime = ) {

Re: Convenience function selectall_hasharrayref

Tim Bunce wrote: On Tue, Jan 10, 2006 at 12:47:54PM +0100, Peter J. Holzer wrote: or selectall_arrayhashref? Anyway, I rather frequently find that the most natural way to represent a query result is an array of hashes: Each row is hashref, but the the rows are in an array(ref) so that the

Re: Convenience function selectall_hasharrayref

and here's the proposed patch hopefully my english is good enough. Tom Index: DBI.pm === --- DBI.pm (Revision 2381) +++ DBI.pm (Arbeitskopie) @@ -4014,7 +4014,17 @@ In which case the array is copied and each value decremented before

Re: Connection pooling in Apache2.2

Tim Bunce wrote: On Mon, Dec 05, 2005 at 11:01:33AM +0100, Tom Schindl wrote: Hi, I've already asked at the mod-perl-list about the new connection pooling provided by Apache2.2 with http://httpd.apache.org/docs/2.1/mod/mod_dbd.html but they redirected me to this mailling list. Has anybody

Connection pooling in Apache2.2

Hi, I've already asked at the mod-perl-list about the new connection pooling provided by Apache2.2 with http://httpd.apache.org/docs/2.1/mod/mod_dbd.html but they redirected me to this mailling list. Has anybody taken already a look at this. I think I don't have enough knowlegde about the