Access Web System from external
Take Equity Collection System as an example, Some other office collegues want to access it from home without VPN, The way to check is:
1. Check if it's limited in network, this needs to confirm with network people
2. If the step 1 passed, get the external IP address of the system, map the system to the domain name, such as Edgar.**.com. Then the domain should can be access from external.
Ïà¹ØÎĵµ£º
ÏÖÏó£º
ESXµÄWEB·ÃÎÊĬÈÏÊǹرյģ¬ÍøÉϺܶàÎÄÕ¶¼ËµÊ¹ÓÃchkconfig vmware-webAccess onÀ´È÷þÎñ×Ô¶¯¿ªÆô£¬²»¹ýÕâÑù²Ù×÷Ö®ºóÖØÆô»úÆ÷£¬WEB·ÃÎÊ»¹ÊÇ»¹»á³ö503ÎÞ·¨·ÃÎÊ´íÎó£¬ESX²»ÖªµÀΪʲô»á×Ô¶¯°Ñvmware-webAccess ¸ø½ûÓõô¡£
½â¾ö·½·¨£º
¾¹ýÎÞÊý´Î³¢ÊÔÖ®ºó·¢ÏÖÁ˽â¾ö·½·¨£¬ÃüÁîÈçÏ£º
cd /etc/init.d
cp vmware-web ......
ÔÚACCESS(2007)Êý¾Ý¿âÖУ¬ÓÐÕâÑùÒ»¸öÄ£ºý²éѯ£¬
select postId,postName,postType,left(postTime,10) as postTimes from PostInfo where postUser like '*ÖÜ·¼*'
ÔÚÊý¾Ý¿â²éѯºó½á¹ûÏÔʾÕýÈ·£¬¿ÉÊÇ·ÅÔÚÏîÄ¿µÄ´úÂëÖУ¬¾ÓÈ»²»ÏÔʾ²éѯµÄ½á¹û¿©¡£¼ì²éÁ˰ëÌ춼ûÓз¢ÏÖ´íÎóÔÚÄÄÀ×îºó²ÅÖªµÀ£¬ÓеÄACCESS¾ÓÈ»²»ÈÏʶͨŠ......
´ÓAccessÊý¾Ý¿âµ¼Èëµ½SQL
·½·¨Ò»:
ÔÚMSsqlÖÐÒª¼òÀúODBC..·½·¨±È½Ï±¿µã..
·½·¨¶þ:
Ö±½Ó´ÓAccessÉýǨµ½MSsql..
ÒòΪAccessÊý¾Ý¿âÓÐÉèÖÃÃÜÂë..»¹Õæ²»ºÃ¸ã..¸ãÁ˺ü¸´Î¶¼Ê§°ÜÁË..
ÀûÓ÷½·¨¶þ..Ò»´Î³É¹¦..
ÓÃÊý¾Ý¿âÉýǨ...¼òµ¥...
½¨ÒéʹÓõڶþÖÖ·½·¨µ¼ÈëACCESSÊý¾Ý¿âµ½MSSQLÊý¾Ý¿âÖÐ..Ê¡ÊÂ!!! ......
µÚÒ»ÖÖ·½·¨£º
<?php
class Access{
function getConn(){
$conn = @new COM("ADODB.Connection") or die ("ADOÁ¬½Óʧ°Ü!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath(__IMP ......