SQL select for HDBC.ODBC MSSQL driver
            
            
            
                27 Oct
                
                    2015
                
            
            
                27 Oct
                
                '15
                
            
            
            
        
    
                8:34 a.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.
        3661
        
      
          Age (days ago)
        
      
        3661
        
    
          Last active (days ago)
        
        
        
        0 comments
    
    
        
        1 participants
    
    
    
    
    
    
    
    
    participants (1)
- 
                
Anakreontas