DBI Number of fields

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 LongTruncOk 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

RE: DBI Number of fields

You should first make sure your query runs outside of Perl.

-----Original Message-----
From: Brian Johnson [mailto:brianj@e-mol.com]=20
Sent: Thursday, February 22, 2007 10:22 AM
To: dbi-users@perl.org
Subject: DBI Number of fields

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 LongTruncOk 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