odbc sqlserver notes

Jump to bottom Edit New page

Ryan Culpepper edited this page Mar 19, 2018 · 12 revisions

ODBC SQL Server notes

Setup

I tried installing SQL Server Express.

I eventually gave up.

Setup (Take 2)

install SQL Server Express 2017
- picked Basic, no customization
  - Server=localhost\SQLEXPRESS;Database=master;Trusted_Connection=True;
install SSMS 17.5
turn on protocols

ODBC configuration

Driver = ODBC Driver 13 for SQL Server
Server = localhost\SQLEXPRESS

Issues

Test failures

Several concurrent tests fail with Connection is busy with results for another command (HY000)
Multi-statement string doesn't raise error.
bigint roundtrip causes overflow error (SQLSTATE 22003)
time roundtrip causes error: "unsupported type (typeid: -154)"
- TODO: allow connection to specify blacklisted types; or fetch as string instead?
timestamp test causes error: "Explicit conversion from data type datatime2 to timestamp is not allowed. (SQLSTATE: 22018)"