I have a Sql Server 2019 Express database to which i want to create a linked server to Sage Line 50.
Now i have installed the 64 bit ODBC driver for Sage Line 50 (see attached Screenshot) and then proceeded to set up the linked server (see screenshot)
Now i put credentials in but get the following error message
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "SAGELINE50REPORTS". OLE DB provider "MSDASQL" for linked server "SAGELINE50REPORTS" returned message "The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 27.2]". OLE DB provider "MSDASQL" for linked server "SAGELINE50REPORTS" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "SAGELINE50REPORTS" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "SAGELINE50REPORTS" returned message "Cannot find all files in data path". (Microsoft SQL Server, Error: 7303)
what am i doing wrong here?
