The Now Platform® Washington DC release is live. Watch now!
You can use the ServiceNow ODBC driver in SQL Server (2008 and 2012) as a linked server. This enables the SQL Server to query tables from a ServiceNow instance directly using the ODBC driver. However, if you integrate the ODBC driver with Microsoft SQL Linked Server, you may receive an error containing "MSDASQL" and related to one of the following:
The result is that the ODBC driver is unable to access the application logs or file cache. For a list of exact error message text, see Resolving Linked Server Access Errors with ODBC Driver.
The %LOCALAPPDATA% environment variable is used by the ODBC driver to specify the location of log files and cache. When using the iSQL console, the %LOCALAPPDATA% variable is replaced with the user home directory, for example C:\Users\<user>\AppData\Local. However, when running Microsoft SQL Server, this variable is replaced with C:\Windows\System32\config\systemprofile\AppData\Local. Unlike the user local directory, the System32 local directory requires elevated privileges to access.
ServiceNow offers more information about the ODBC driver and SQL Server:
Using ODBC Driver in SQL Server 2008 and 2012
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.