Differences

This shows you the differences between two versions of the page.

Link to this comparison view

control_sql_-_reinstall_sql_bridge [2019/01/27 11:29]
 control_sql_-_reinstall_sql_bridge [2019/01/27 11:29] (current)
Line 1: Line 1:
 +
 +
 +
 +
 +==Explanation==
 +
 +
 +
 +It may be necessary to reinstall SQL Bridge to clear up an error within the SQL Bridge Assembly.  There are 3 ways to reinstall SQL Bridge.
 +  - [[page_x-restart_the_sslip|#x-Restart the SSLIP]]
 +  - [[page_x-reinstall_sql_bridge_using_the_sslip_without_restarting|#x-Reinstall SQL Bridge using the SSLIP (without restarting)]]
 +  - [[page_x-reinstall_the_existing_sql_bridge_assembly_in_sql|#x-Reinstall the existing SQL Bridge Assembly in SQL]]
 +
 +
 +
 +==Restart the SSLIP==
 +
 +
 +
 +Every time the SSLIP starts, it will locate the SQLBridge.dll file and install it into the Control SQL Server database.
 +
 +
 +
 + 
 +
 +
 +
 +==Reinstall SQL Bridge using the SSLIP (without restarting)==
 +
 +
 +
 +It is not necessary to restart the SSLIP to install SQLBridge.  When you right click on the SSLIP tray icon, under Administration Tools, there is a button to Reinstall SQL Bridge.  
 +
 +
 +
 +This will perform the same steps that occur when the SSLIP starts up.
 +
 +
 +
 +==Reinstall the existing SQL Bridge Assembly in SQL==
 +
 +
 +
 +There is also a SQL Stored procedure.  The biggest difference with install SQL Bridge this way is that it will not use the SQLBridge.dll file.  Instead it will reinstall the last assembly file that was installed.  Most of the time, this is not an issue.  But if you want to install a new SQL Bridge DLL, then you will have to use one of the first two methods.
 +
 +
 +
 +<code sql>
 +EXEC [SqlBridge.Install]
 +</code>
 +
 +
 +