Closed StefanVriend closed 10 months ago
We currently use a SQL driver to access the AnE bud burst data in R:
DBI::dbConnect(drv = odbc::odbc(), .connection_string = "Driver={SQL Server};...")
This driver may cause some issues when loading particular long columns (i.e., columns that allow values with a lot of characters). This can be easily solved by using a different driver:
DBI::dbConnect(drv = odbc::odbc(), .connection_string = "Driver={ODBC Driver 17 for SQL Server};...")
To use this driver, first install from here: https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16#version-17
We currently use a SQL driver to access the AnE bud burst data in R:
This driver may cause some issues when loading particular long columns (i.e., columns that allow values with a lot of characters). This can be easily solved by using a different driver:
To use this driver, first install from here: https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16#version-17