Skip to content
+1-888-319-3663

COMMUNITY FORUM

SmartConnect 2014 and GP 10

oscar87 asked 7 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
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 

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.
 

jsnider replied 7 years ago

Are you on a SQL version prior to 2012? If so, see this KB.

KBA-01246-S2V2C3


If you would like to submit an answer or comment, please sign in to the eOne portal.