DBI Number of fields

From: brianj@xxxxxxxxx (Brian Johnson)
Date: Thu, 22 Feb 2007 12:21:53 -0500

Hey Folks -

We are having a problem with a script that uses DBI and ODBC to connect to a MSSQL database. The script was running fine, until we added some fields to a select statement. Now the scripts hangs at that select. The script has multiple fields (as many as 22 fields), multiple joins (5 left joins), and pulls from as many tables.

If we remote any single field, the script works. If we remove one of the joins, the script works.

We have tried to disconnect/reconnect to the database just before this select statement, with the same results. None of the fields are long enough for LongReadLen or LongTrun*** to be the culprits. Does anybody have any ideas?

-------------------------------------
Brian Johnson
Systems Administrator
Work: 248.577.0383 ext 203
Cell: 906.281.0589
e-Mol - Electronic Medical Office Logistics

.

Follow-Ups:
- RE: DBI Number of fields
  - From: Ian Harisay

Prev by Date: Re: How to call DBD::Oracle's dbms_output_get from within a DBIx
Next by Date: Re: How to call DBD::Oracle's dbms_output_get from within a DBIx
Previous by thread: DBD::Informix Test Error On 64bit Linux (RHEL4.4)
Next by thread: RE: DBI Number of fields
Index(es):
- Date
- Thread