JDBC request, ODBC connection, Invalid Fetch Size exception
Hi all,
I'm trying to query a SQL Server table. I believe we're using SQL Server 2008 here.
As suggested in the following post, I'm using an ODBC link through a JDBC Request step to get around Windows authentication issues.
viewtopic.php?f=2&t=7200&p=20949&hilit=odbc&sid=7f6452971ce8851970d60eb537589eb6#p20949
The connection succeeds when tested.
If I'm in the Build Query window, I'm able to return data with any query I've built.
In the request step itself, however, the same query that works in the Build Query windows fails with an "Invalid Fetch Size" exception.
Suggestions? thanks.
I'm willing to try jTDS but it looks like others have had only sporadic success with it.
I'm trying to query a SQL Server table. I believe we're using SQL Server 2008 here.
As suggested in the following post, I'm using an ODBC link through a JDBC Request step to get around Windows authentication issues.
viewtopic.php?f=2&t=7200&p=20949&hilit=odbc&sid=7f6452971ce8851970d60eb537589eb6#p20949
The connection succeeds when tested.
If I'm in the Build Query window, I'm able to return data with any query I've built.
In the request step itself, however, the same query that works in the Build Query windows fails with an "Invalid Fetch Size" exception.
Suggestions? thanks.
I'm willing to try jTDS but it looks like others have had only sporadic success with it.
