Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚ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ÊÇÔÚÊý¾Ý


Ïà¹ØÎÊ´ð£º

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......

ACCESSÊý¾Ý¿âÓëVB¿ª·¢µÄÈí¼þ½øÐл¥Á¬ÍøÁ¬½Ó

±¾À´ÎÒÊÇÓÃACCESS+VB½¨Á¢Ò»¸öÈí¼þ£¨¾ÖÓòÍø£©£¬ÏÖÔÚÓÉÓڰ칫µØµãÓб䶯£¬Ïà»»³ÉINTERNATµÄ£¬ÓÐûÓа취½â¾ö£¬

ÏóÕâÑùµÄÇé¿ö£¬Èç¹ûÊǹãÓòÍø£¬×îºÃ¸Ä³É£ºB\SµÄ
Èç¹ûÊǾÖÓòÍøµÄ£¬×îºÃ¸Ä³É£ºC\SµÄ
http://downlo ......

Access Êý¾ÝÉýǨµ½ SQLServer2005

ÎÒÔ­±¾ÊÇÓÃACCESSµÄÊý¾Ý¿â£¬ÏÖÔÚ¸ÄÓÃSQLServer2005ÁË£¬ËùÒÔÏë°Ñ֮ǰµÄÊý¾ÝÈ«¶¼µ¼µ½SQLSERVERÀïÀ´¡£
ÏÖÓÐÎÊÌâÈçÏ£º

1:¸ÄÓÃSQLserverºó£¬Êý¾Ý¿âµÄ½á¹¹Óи͝¡£Ô­±¾ÔÚaccessÖÐËùÓеĵ¥¾ÝÓÃÒ»¸ö¡°µ¥¾ÝÐÅÏ¢¡±Ö ......

ACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000

  ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......

ÈçºÎΪaccessÊý¾Ý¿â¼ÓÃÜ

¸øaccessÊý¾Ý¿â¼ÓÃܵIJ½ÖèÈçÏ£º

£¨1£©´ò¿ªaccessÈí¼þ£¬½çÃæÈçͼ1Ëùʾ

       

                        ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ