[Haskell-cafe] SQL select for HDBC.ODBC MSSQL driver

27 Oct 2015

      Hello.

I obtain a connection and try to execute a query on MSSQL server with HDBC
  c <- connectODBC "Driver={SQL 
Server};Server=.;Database=Pure_Local;Trusted_Connection=yes;"
  stm <- quickQuery c "select count(*) as cnt from X__FD" []

HDBC obtains the connection but the SQL query raises an exception with the 
following message:
SqlError {seState = "[\"25000\"]", seNativeError = -1, seErrorMsg = 
"disconnect: [\"0: [Microsoft][ODBC SQL Server Driver]Invalid transaction 
state\"]"}

No matter which statement I tried, I always get the "Invalid transaction 
state" message.

[Haskell-cafe] SQL select for HDBC.ODBC MSSQL driver

Anakreontas