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
