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

SQLiteÓа취͸¹ýÍøÂçÁ¬½ÓÂð?

Ä¿Ç°ÔÚ¹«Ë¾µÄlinux pcÉÏÓÐÒ»¸öSQLite server, ÎÒÏëÓÃÔÚͬ¸öÇø網µ×ϵÄwin pcÈ¥Á¬½ÓSQLite serverÓÃASP進ÐвÙ×÷, ÇëÎÊÓа취°ìµ½Âð? »¹ÊÇSQLite serverÎÞ·¨Ö§³ÖÍøÂçÁ¬½Ó....ÕÒÁËÒ»¸öÏÂÎç


剛²ÅÎÒ×Ô¼º試ÁËÏÂ, µ×ÏÂÊÇÎÒµÄASP code, mydbÄ¿Ç°ÊÇÎÒ×Ô¼ºÔÚ±¾機ÉϽ¨³ö來µÄsqliteÎļþ, Òâ˼ÊÇÖ»Òª°ÑLinuxÉÏÄÇ個dbÎļþ·ÖÏí³ö來, windowsÖ»ÄÜ×¥µ½該檔¾ÍÄÜ進ÐвÙ×÷嗎, ²»ÖªµÀÓÐ沒ÓÐͬ²½ÉϵÄ問題?
<%
Set conn = Server.createObject("ADODB.Connection") '½¨Á¢Ò»個連線
Set rs = Server.createObject("ADODB.RecordSet") '½¨Á¢Ò»個recordset
conn.open "DRIVER={SQLite3 ODBC Driver};Database=C:\mydb"
rs.open "select * from Tab_ID",conn,1,3
Do While not rs.EOF
Response.Write rs("ID") & " <br>" & rs("Name")
rs.movenext
Loop
rs.close '關閉recordset
Set rs = Nothing '將recordset設為nothing
conn.close '關閉連線
%>

};Database=C:\mydb"

ÕâÊÇÄã±¾µØCÅ̵ģ¬µ±È»²»ÊÇLINUXÉϵģ¬LINUXÄãÐèÒªÓÃSAMBAÀ´°ÑÎļþ¹²Ïí³öÀ´¡£

謝謝^^ Ã÷Ììµ½¹«Ë¾試試¿´!


Ïà¹ØÎÊ´ð£º

ÓùýSQLiteµÄÅóÓѺÍÍæ¹ýÅú´¦ÀíµÄÅóÓѽøÀ´¿´Ò»ÏÂ.


    żÏ뱸·ÝÊý¾Ý±í£¬Ð´ÁËÒ»¸öÅú´¦Àí£¬ÓÐÏֳɵÄÊý¾Ý¿â¡£µ«ÊÇÅú´¦Àíдµ½Ò»°ë²»»áÁË£¬»¹Çë°ïæ¿´¿´£¬ÔõôÍùÏ¡£¡£¡£

    @echo off
    echo ÕýÔÚϵͳÊý¾Ý¿â±¸·Ý£¬ÇëÉÔ ......

sqliteÒÆÖ²ÎÊÌâ

ÎÒÏÖÔÚÊÖÍ·ÓÐÕâôһ¸öÎÊÌ⣬ÎÒÏëÈÃÒ»¸ö²Ù×÷sqlite3µÄ³ÌÐòÔÚÒ»¸öARM°å×ÓÉÏÅÜÆðÀ´£¬°å×ÓÉϵÄosÊÇwince5.0¡£
ÎÒÊÇÕâô×öµÄ£¬ÎÒÏÈ´Ósqlite3Ö÷Ò³ÏÂÔØÔ´ÂëÏÂÀ´£¬ÓÐÕâô3¸öÎļþ£ºsqlite3.c¡¢sqlite3.h¡¢sqlite3ext.h £¬ ......

c#Á¬½ÓSqliteÊý¾Ý¿âÎÊÌâ

ÎÒÓÃsqliteadmin½¨ÁËÒ»¸öÊý¾Ý¿âtest.sdb,¿ÉÊÇÔõôҲ´ò²»¿ªÌáʾÈçÏ´íÎó£ºFile opened that is not a database file
file is encrypted or is not a database¡£

ÎÒµÄÁ¬½Ó×Ö·û´®ÈçÏÂÂ¥ÉϵĿɲ»¿ÉÒÔ°ïÎÒ¿´¿´
S ......

Çë½Ì£ºVCÖеÄTree¿Ø¼þÓëSQLiteÊý¾Ý±íµÄʹÓÃÎÊÌâ

ÎÒÒª°ÑÊý¾Ý±íÖеÄÊý¾Ý£¬ÒÔÊ÷µÄÐÎʽÏÔʾÔÚ¶Ô»°¿òÖС£
±ÈÈ磺
Ö»ÒªÊý¾Ý±íÖÐÓÐ3¸ö×ֶΡ¢id¡¢parentid¡¢name
ÇëÎÊÎÒÈçºÎдһЩ´úÂ뽫Êý¾Ý±íÖеÄÄÚÈÝÌîµ½Ê÷¿Ø¼þÖÐÈ¥ 

ÒýÓÃ
Ò»°ãÊÇÓõݹéµÄ·½·¨À´ÊµÏ ......

flex airÁ¬½Ósqlite²éѯ±¨´í£ºno such table

XML code:
<?xml version="1.0" encoding="utf-8"?>
<mx:WindowedApplication xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute">
<mx ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ