SQL select for HDBC.ODBC MSSQL driver

27 Oct
2015
27 Oct
'15
12:34 p.m.
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.
3541
Age (days ago)
3541
Last active (days ago)
0 comments
1 participants
participants (1)
-
Anakreontas