Re: [Haskell-cafe] hdbc-odbc not getting any data using mssql stored procedure

2013-10-10 Thread grant weyburne
Hi Gauthier, that answer was perfect! I just tried it out and It completely solved my problem. Thanks so much! Grant. On Thu, Oct 10, 2013 at 8:58 AM, Gauthier Segay wrote: > Hello Grant, pulling this topic out of the archive as I face similar issue > and found a work around. > > I'm unsure what

Re: [Haskell-cafe] hdbc-odbc not getting any data using mssql stored procedure

2013-10-10 Thread Gauthier Segay
Hello Grant, pulling this topic out of the archive as I face similar issue and found a work around. I'm unsure what's happening in gp_somestoredproc but if using the sql management studio, you see some output such as (X row(s) affected) then you might want to put "set nocount on" before issuin

[Haskell-cafe] hdbc-odbc not getting any data using mssql stored procedure

2013-01-31 Thread grant
Hi, I am trying to call a stored procedure (exec gp_somestoredproc 123,22) using microsoft sql server 2008 R2 using hdbc-odbc. Here is the haskell code: import Database.HDBC import Database.HDBC.ODBC import Control.Monad import Data.Maybe import qualified Data.ByteString.Char8 as B test1 =