InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 00:17:32 GMT20http://www.sqlservercentral.com/Forums/Topic1409260-391-1.aspxYou could also consider switching to use a Linked Server to connect to a remote SQL Server instead of using the OLE Automation routines.Sun, 20 Jan 2013 08:08:36 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1409260-391-1.aspxHave you enabled the OA in the server? Please check this via sp_configure:sp_configure 'show advanced options',1GOreconfigure GOsp_configure 'Ole Automation Procedures'You should see the run_value as 1. If not - set it to 1 and check the code one more timeSun, 20 Jan 2013 05:30:37 GMTDamian Widera-396333http://www.sqlservercentral.com/Forums/Topic1409260-391-1.aspxhello all.I use this: declare @h int,@objDBC int EXEC sp_OACreate 'ADODB.Connection', @objDBC OUT --------@objDBC =16711422 EXEC @h=sp_OASetProperty 16711422, 'ConnectionString', 'Driver={SQL Server}; Server=WIN-00UO3RQ0BM3;Database=MaliGilan; trusted_Connection=Yes' EXEC @h=sp_OAMethod 16711422, 'Open' print @hthis have to returns zero but returns -2147467259.please tell me why this dosen't return zero?Sun, 20 Jan 2013 02:23:47 GMTelham_azizi_62