Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ......

ODBC Microsoft accessµÇ¼ʧ°Ü

н¨µ¥Îĵµ³ÌÐòÑ¡ÔñODBCÖеÄÊý¾ÝԴʱ×ÜÊǵ¯³öÒ»¸öµÇ¼´°¿ÚÒªÊÚȨ¡£¡£¡£»¹ÒªÃÜÂë¡£¡£¡£
      ÆäËûµÄµ÷ÓÃODBCÖеÄÊý¾ÝÔ´ÊǾͲ»ÐèÒªÕâ¸ö£¬¿ÉÒÔÔËÐС£
  ŪÁ˺ó¤Ê±¼äÁË¡£¡£¡£
ûÓö¼û¹ý£¬¿ ......

ACCESSÖн¨Á¢Çл»±íµ¥Ê±Óöµ½ÎÊÌâ ÔÚÏßµÈ

ACCESSÖн¨Á¢Çл»±íµ¥,
µã»÷ ¹¤¾ß/×ÊÁϿ⹫ÓóÌʽ/Çл»±íµ¥¹ÜÀíÔ± ºó
Ìáʾ£ºMicrosoft office accessÎÞ·¨½¨Á¢visual basicÄ£×飡
µ½µ×ÊdzöÁËʲ÷áÎÊÌâÄØ£¿
µÚÒ»´ÎÕâÑù½¨Á¢Çл»±íµ¥ÊÇ¿ÉÒԵ쬵«ÊÇÓÉÓÚÓÐ ......

µ¼Èëexcel±í¸ñµ½accessºó²úÉúµÄÎÊÌ⣿

ϵͳÿÌì²úÉúÒ»¸öexcelÎļþ£¬¸ñʽÏàͬ£¬ÄÚÈÝÓÃÎļþÃû£¨ÓòúÉúµÄʱ¼äÃüÃû£©Çø·Ö¡£ÎÒ×öÁËÒ»¸öaccessÊý¾Ý¿â£¬µ¼ÈëexcelµÄÊý¾Ý£¬ÎÒÏë¼ÓÒ»Ïî¼Í¼ÎļþÃûÀ´Çø·ÖÄÚÈÝ£¬¿ÉÊÇÔõô×öÄØ£¿ÓÖ»òÕßÓÃʲôÆäËû·½·¨¿ÉÒÔ°ìµ½£¿Ð»ÁË
Äã ......

ACCESSÆøËÀÎÒÁË£¬MD£¬×Ö¶ÎÖµ²»¶Ô

ÎÒÒª´ÓACCESS²éѯһÐÐÊý¾Ý,Êý¾Ý¿âÀïÓÐ ip£º192.168.2.71£¬192.168.2.55
SELECT COUNT(*) AS num from TreeNode WHERE ([ip]='192.168.2.55')£¬ÄÜÑ¡³öÊý¾ÝÀ´
SELECT COUNT(*) AS num from TreeNode WHE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ