DBI ODBC select statement length
- From: brianj@xxxxxxxxx (Brian Johnson)
- Date: Wed, 29 Aug 2007 14:16:07 -0400
Hey folks -
We have written an app that makes a connection to a MSSQL server using ODBC. It works great as long as the length of our select statement is 668 characters or less. As soon as it hits 669 characters, it hangs forever doing the execute. It also fails if we use $dbh->do() instead of $dbh->prepare() and $dbh->execute.
I have googled like crazy trying to find some direction, but have come up empty. Has anybody seen this before? Or is this something obvious and I should be hit with a rolled up news paper for not figuring it out?
Thanks.
-Brian
.
- Follow-Ups:
- Re: DBI ODBC select statement length
- From: Christopher Sarnowski
- Re: DBI ODBC select statement length
- Prev by Date: Re: Number of row fields inconsistent with NUM_OF_FIELDS, NUM_OF_FIELDS updated
- Next by Date: DBI.pm and libc.so.6 (Linux)
- Previous by thread: DBI:Sybase connect error
- Next by thread: Re: DBI ODBC select statement length
- Index(es):
Relevant Pages
|
|
