1.2 Preview error


#1

I wanted to contribute to the testing of the preview edition (Version 1.2.1047)

After opening a new connection to a SQL Server instance, I was able to navigate a very large list of tables (very nice UX). I picked a table to try out the auto sql write. Nice addition for quickly examing data in the table.
although, when I hit the Preview button I received this error.

Error in new_result(connection@ptr, statement) : 
  nanodbc/nanodbc.cpp:1344: HY090: [Microsoft][ODBC Driver Manager] Invalid string or buffer length

I should note that I had some trouble installing the RSQLite library it was requesting. I could not retreive the error, since the window disappears. Installing through the standard install method succeeded however.

Here are my build details:

Build 1078 (4e29f670)
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) QtWebEngine/5.11.1 Chrome/65.0.3325.230 Safari/537.36

#2

Thanks for taking the time to test!

What driver are you using to connect to your SQL Server instance? Are you using the RStudio Professional Drivers, or other drivers that you have registered?