SmartConnect 2014 and GP 10
oscar87 asked 9 years ago
I am new to SmartConnect will be using it with GP 10. I am tyring to get the MSMQ Table Real Time Data Source but unable was getting the following
The MSSQL real time data source assembly does not exist in GP10DEV : Test
The MSSQL real time data source assembly does not exist in GP10DEV : Test
To enable real time data sources please run the script below as a MSSQL system administrator on the GP10DEV server.
USE master
GO
CREATE ASYMMETRIC KEY SmartConnect_Realtime_Key from EXECUTABLE FILE = 'C:Program Files (x86)\eOne SolutionsSmartConnecteOne.SmartConnect.MSSQLServerRealTime.dll'
GO
CREATE LOGIN SmartConnect_Realtime_Login FROM ASYMMETRIC KEY SmartConnect_Realtime_Key
GO
GRANT UNSAFE ASSEMBLY TO SmartConnect_Realtime_Login
GO
USE Test
GO
CREATE USER SmartConnect_Realtime_User FOR LOGIN SmartConnect_Realtime_Login
GO
CREATE ASSEMBLY [eOne.SmartConnect.MSSQLServerRealTime.dll] FROM 'C:Program Files (x86)\eOne SolutionsSmartConnecteOne.SmartConnect.MSSQLServerRealTime.dll'
WITH PERMISSION_SET=UNSAFE
GO
For more information see http://doc.eonesolutions.com/SmartConnect/index.html?smartconnect_data_source_mssql_realtime.htm
Ran the following on the SQL query but getting the following on the last statement
Ran the following on the SQL query but getting the following on the last statement
Msg 6257, Level 16, State 1, Line 2
CREATE ASSEMBLY for assembly 'eOne.SmartConnect.MSSQLServerRealTime' failed because the assembly is built for an unsupported version of the Common Language Runtime.
Are you on a SQL version prior to 2012? If so, see this KB.
KBA-01246-S2V2C3