windowsץȡlinuxÉÏsqlite db問題
´ó¼ÒºÃ, ÉÏÀñ°ÝÓÐÀ´ÎÊ˵ÈçºÎ´ÓlinuxÉÏ·ÖÏí³ösqliteµÄdbÊý¾ÝÈÃwindows²Ù×÷, ºóÀ´Ò»Ö±ÎÞ·¨Ö±½Ó͸¹ýip·½Ê½Äõ½µµ°¸, Ïë˵¸ÄÓÃftp·½Ê½¶ÁµµÐ´Èëºó, ÔÙÉÏ´«»Ølinux server, ÏÖÔÚÓиöÎÊÌâµ±win pc¿ªÆôdbµµ°¸ºó, ºÃÏñ»áËøסËü, µ¼ÖÂÔÙÒ»´ÎÅܲâÊÔ³ÌÐòʱ, ÒòΪ»¹ÔÚ´æÈ¡µÄ¹Øϵ, dbµµ°¸ÎÞ·¨ÖØÐÂÏÂÔØ, µ¥¶Àrun batÎļþ»áÏÔʾʹÓÃȨÏÞ±»¾Ü, ÎÞ·¨¸²Ð´dbµµ°¸, ²»ÖªµÀÕâÊÇʲôÎÊÌâ?
<%
Dim objExecutor
Dim sResult
Set objExecutor = Server.CreateObject("ASPExec.Execute")
objExecutor.Application = "cmd.exe"
objExecutor.Parameters = "/c c:\Inetpub\wwwroot\ftp\test.bat" 'hope your batch file is in c drive.
objExecutor.ShowWindow = False
'Here we execute the app and get the output to this string
sResult = objExecutor.ExecuteWinApp
Response.write "Result: " & sResult & " <p>"
'ÏÈÓÃftp°Ñ檔°¸download»Ø來, ÔÙ開啟db資ÁÏ
Set conn = Server.createObject("ADODB.Connection") '½¨Á¢Ò»個連線
Set rs = Server.createObject("ADODB.RecordSet") '½¨Á¢Ò»個recordset
conn.open "DRIVER={SQLite3 ODBC Driver};Database=C:\Inetpub\wwwroot\ftp\mydb.db"
'conn.open "DRIVER={SQLite3 ODBC Driver};Database=\\192.168.122.4\test\mydb.db" 'Ô±¾ÒªÓõķ½Ê½, ¿ÉÊÇÒ»Ö±無·¨³É¹¦
rs.open "select * from enum",conn,1,3
Ïà¹ØÎÊ´ð£º
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
linux ÏÂusbÉ豸£¬ÔÚrootȨÏÞÏ£¬É豸¿ÉÒÔÕý³£ÕÒµ½Çý¶¯£¬
µ«ÔÚÆÕͨÓû§ÏÂÕÒ²»µ½É豸Çý¶¯£¬
ÔõÑù²Å¿ÉÒÔÔÚÆÕͨÓû§ÏÂʹÓÃusbÉ豸£¿
Çë¸ßÊÖÖ¸½Ì
°ï¶¥Ï¡¢
ûÓöµ½¹ý£¬ÎÒÓõÄfedoraÆÕͨÓû§Ä¬ÈϵÄÒ²ÄÜÓðɣ ......
ÏÖÔÚÐèÒªÔÚÒ»¸öǶÈëʽϵͳÖÐʵÏÖʱ¼äº¯Êý£¬±àÒëÆ÷δÌṩtime¿âº¯Êý£¬ÇëÎÊ´ó¼ÒÈçºÎÓÃcÓïÑÔʵÏÖʱ¼äº¯Êý°¡£¿
ÄêÔÂÈÕʱ·ÖÃë µ½ ÕûÊýÃ루´Ó1970Ä꿪ʼ£© Ö®¼äµÄÏà¹Øת»»°¡
ÀàËÆmktime ºÍlocaltimeµÄ¹¦ÄÜ£¬Ð»Ð»
mktime ......
ÔÚLinuxÖУ¬
Èç¹û¸¸½ø³Ìµ÷ÓÃexit(0)Í˳ö£¬
ÄÇôÓɸýø³Ì´´½¨µÄÁ½¸ö×Ó½ø³Ì»áÁ¢¼´Í˳öÂ𣿣¿£¿
Ï£ÍûΧÈƸÃÎÊÌâ˵Çå³þµã£¬Ð»Ð»ÁË¡£
²»»á
Á½¸ö×Ó½ø³ÌÍÑÀëÁ˸¸½ø³Ì£¬¶ÀÁ¢ÔËÐÐ
¸¸½ø³ÌËÀµôºó£¬ÆäËùÓÐ×ÓËï½ø³Ì±»initÊÕ ......
½«ËùÒª·¢Ë͵Ätcp°ü·ÅÔÚ·¢ËͶÓÁÐÖУ¬Èç¹ûÔÚ15ÃëÄÚûÊÕµ½ACK£¬¾ÍÖØ·¢£¬ÏëÇëÎÊ´ó¼Ò£¬ÕâÑùÊDz»ÊÇÒª¶Ôÿ¸öTCP°ü¼Ó¶¨Ê±Æ÷°¢£¬³ýÁËÓÃalarm,»¹ÄÜÓÃʲôÁË£¿
Äã¸ãÓ¦ÓõĻ°²»ÐèÒª¹ØÐÄtcpÐÒéÕ»ÊÇÔõô´¦ÀíµÄ°¡
tcpÐÒéÕ»ÓÐÖØ· ......