hamed-p
پنج شنبه 03 اردیبهشت 1388, 09:28 صبح
با درود
من براي اينكه بتوانم از يك Store procedure خاص، به طور مستقيم Select بگيرم؛ راههاي زير را امتحان كردم ولي پس از اجراي برخي از تنظيمات sql همچنان با errorهاي زير روبهرو هستم:
1- استفاده از OPENQUERY
SELECT * FROM OPENQUERY([172.16.132.45], 'UnitsData.dbo.SP_ConvertColsToRows ''HYD_FM_01'', 1, 5, ''1388/01/29'',''1388/01/29'',''09''')
Error:
Msg 7357, Level 16, State 2, Line 1
Cannot process the object "UnitsData.dbo.SP_ConvertColsToRows 'HYD_FM_01', 1, 5, '1388/01/29','1388/01/29','09'". The OLE DB provider "SQLNCLI" for linked server "172.16.132.45" indicates that either the object has no columns or the current user does not have permissions on that object.
2- استفاده از openrowset
select a.* from OPENROWSET ('SQLNCLI','SERVER=172.16.132.45;', 'SET NOCOUNT ON;SET FMTONLY OFF;UnitData.dbo.SP_ConvertColsToRows ''HYD_FM_01'', 1, 5, ''1388/01/29'',''1388/01/29'',''09''') as a;
Error:
OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Invalid authorization specification".
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "SQLNCLI" for linked server "(null)" reported an error. Authentication failed.
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "(null)".
شاد باشيد.
من براي اينكه بتوانم از يك Store procedure خاص، به طور مستقيم Select بگيرم؛ راههاي زير را امتحان كردم ولي پس از اجراي برخي از تنظيمات sql همچنان با errorهاي زير روبهرو هستم:
1- استفاده از OPENQUERY
SELECT * FROM OPENQUERY([172.16.132.45], 'UnitsData.dbo.SP_ConvertColsToRows ''HYD_FM_01'', 1, 5, ''1388/01/29'',''1388/01/29'',''09''')
Error:
Msg 7357, Level 16, State 2, Line 1
Cannot process the object "UnitsData.dbo.SP_ConvertColsToRows 'HYD_FM_01', 1, 5, '1388/01/29','1388/01/29','09'". The OLE DB provider "SQLNCLI" for linked server "172.16.132.45" indicates that either the object has no columns or the current user does not have permissions on that object.
2- استفاده از openrowset
select a.* from OPENROWSET ('SQLNCLI','SERVER=172.16.132.45;', 'SET NOCOUNT ON;SET FMTONLY OFF;UnitData.dbo.SP_ConvertColsToRows ''HYD_FM_01'', 1, 5, ''1388/01/29'',''1388/01/29'',''09''') as a;
Error:
OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Invalid authorization specification".
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "SQLNCLI" for linked server "(null)" reported an error. Authentication failed.
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "(null)".
شاد باشيد.