¹ØÓÚEXTERNAL ACCESS ASSEMBLYȨÏÞÉèÖà ¼±¼±£¡£¡£¡
ÏîÄ¿ÐèÒª´´½¨³ÌÐò¼¯£¬²¢¶Ô¸Ã³ÌÐò¼¯ÉèÖÃEXTERNAL_ACCESSȨÏÞ£¬ÒÔÍê³ÉÍⲿ·ÃÎʹ¦ÄÜ£¬±ÈÈç²ÉÓÃÈçÏÂÓï¾ä£º
create assembly assemblyName(³ÌÐò¼¯Ãû³Æ) from 'D:\dllName.dll' with permission_set = external_access
»á³ö´í£¬ÌáʾÈçÏ£º
Õë¶Ô³ÌÐò¼¯'dllName'µÄCREATE ASSEMBLYʧ°Ü£¬ÒòΪ³ÌÐò¼¯'dllName'δ»ñÊÚȨ£¨PERMISSION_SET = EXTERNAL_ACCESS£©.
µ±·ûºÏÒÔÏÂÁ½¸öÌõ¼þ֮һʱ£¬½«¶Ô³ÌÐò¼¯ÊÚȨ£ºÊý¾Ý¾ÝËùÓÐÕß¾ßÓÐEXTERNAL ACCESS ASSEMBLYȨÏÞ£¬¶øÇÒÊý¾Ý¿âµÄ
TRUSTWORTHYÊôÐÔ´¦ÓÚ´ò¿ª×´Ì¬£»»òÕߣ¬³ÌÐò¼¯Ç©ÃûʱËùʹÓõÄÖ¤Êé»ò·Ç¶Ô³ÆÃÜÔ¿Ëù¶ÔÓ¦µÄµÇ¼Ãû¾ßÓÐEXTERNAL ACCESS
ASSEMBLYȨÏÞ¡£
ÉÏÊöÎÊÌâÀ§ÈÅÎÒÄÑÒÔ½â¾ö£¬Çë¸ßÊÖÖ¸µã£¡£¡£¡
Êý¾Ý¿âËùÓÐÕß¶ÔÓ¦µÄµÇ½ÕË»§¶Ô SQL SERVER ʵÀýÓµÓÐ EXTERNAL ACCESS ASSEMBLY ȨÏÞ£¨GRANT EXTERNAL ACCESS ASSEMBLY TO loginame £©£»½«Êý¾Ý¿âÉèÖÃΪ¿ÉÐÅÈεģ¨ALTER DATABASE dbname SET TRUSTWORTHY ON£©¡£
ͬÒâ1Â¥.
1Â¥£¬¿ÉÒÔÔÙ¾ßÌåµãÂ𣿣¿
»¹Òª¾ßÌ壿
ÔÚ´´½¨³ÌÐò¼¯Ç°£¬Ö´ÐÐÒÔÏÂÓï¾ä£º
GRANT EXTERNAL ACCESS ASSEMBLY TO loginame
ALTER DATABASE dbname SET TRUSTWORTHY ON
£¨dbname Ϊ׼±¸´´½¨µÄ³ÌÐò¼¯ËùÔÚµÄÊý¾Ý¿â£¬loginame Ϊ¸ÃÊý¾Ý¿âµÄËùÓÐÕß¶ÔÓ¦µÄµÇ½ÕË»§£©
¸Ðл¥ÉϵİïÖúÓëÖ¸µ¼£¬ÎÒ°´ÉÏÃæµÄ×öÁË»¹ÊDz»ÐС£
¾ßÌåÊÇÕâÑùµÄ£º
1 ÔÚmasterϵͳÊý¾Ý¿âÏÂÖ´ÐÐ
GRANT EXTERNAL ACCESS ASSEMBLY TO loginame
ALTER DATABASE dbname SET TRUSTWORTHY ON
ÆäÖУ¬loginame Ϊ׼±¸´´½¨µÄ³ÌÐò¼¯µÄËùÓÐÕßaa¶ÔÓ¦µÄµÇ½Ãû
aaÊÇÔÚÊý¾Ý
Ïà¹ØÎÊ´ð£º
н¨µ¥Îĵµ³ÌÐòÑ¡ÔñODBCÖеÄÊý¾ÝԴʱ×ÜÊǵ¯³öÒ»¸öµÇ¼´°¿ÚÒªÊÚȨ¡£¡£¡£»¹ÒªÃÜÂë¡£¡£¡£
ÆäËûµÄµ÷ÓÃODBCÖеÄÊý¾ÝÔ´ÊǾͲ»ÐèÒªÕâ¸ö£¬¿ÉÒÔÔËÐС£
ŪÁ˺ó¤Ê±¼äÁË¡£¡£¡£
ûÓö¼û¹ý£¬¿ ......
¸÷λ´óÏÀ£º
ÔÚ´°ÌåÀïÓÐÒ»Áбí¿ò£¬ÃûÔ»¡°ÉÌÆ·±àºÅ¡±£¬ÐÐÀ´Ô´ÀïµÄÄÚÈÝÓУºÉÌÆ·±àºÅºÍÉÌÆ·Ãû£¨À´×ÔÉÌÆ·±í£©¡£
µ«ÊÇÎÊÌâ³öÏÖÁË£ºÔÀ´ÉÌÆ·±íÀïµÄÉÌÆ·±àºÅÊÇ4λ£ ......
ACCESSÖн¨Á¢Çл»±íµ¥,
µã»÷ ¹¤¾ß/×ÊÁϿ⹫ÓóÌʽ/Çл»±íµ¥¹ÜÀíÔ± ºó
Ìáʾ£ºMicrosoft office accessÎÞ·¨½¨Á¢visual basicÄ£×飡
µ½µ×ÊdzöÁËʲ÷áÎÊÌâÄØ£¿
µÚÒ»´ÎÕâÑù½¨Á¢Çл»±íµ¥ÊÇ¿ÉÒԵ쬵«ÊÇÓÉÓÚÓÐ ......
¸øaccessÊý¾Ý¿â¼ÓÃܵIJ½ÖèÈçÏ£º
£¨1£©´ò¿ªaccessÈí¼þ£¬½çÃæÈçͼ1Ëùʾ
......