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.