c#Á¬½ÓSqliteÊý¾Ý¿âÎÊÌâ
ÎÒÓÃsqliteadmin½¨ÁËÒ»¸öÊý¾Ý¿âtest.sdb,¿ÉÊÇÔõôҲ´ò²»¿ªÌáʾÈçÏ´íÎó£ºFile opened that is not a database file
file is encrypted or is not a database¡£
ÎÒµÄÁ¬½Ó×Ö·û´®ÈçÏÂÂ¥ÉϵĿɲ»¿ÉÒÔ°ïÎÒ¿´¿´
System.Data.SQLite.SQLiteConnection conn =new System.Data.SQLite.SQLiteConnection();
System.Data.SQLite.SQLiteConnectionStringBuilder connstr
= new System.Data.SQLite.SQLiteConnectionStringBuilder();
connstr.DataSource = datasource;
connstr.Password = "admin";//ÉèÖÃÃÜÂ룬SQLite ADO.NETʵÏÖÁËÊý¾Ý¿âÃÜÂë±£»¤
conn.ConnectionString = connstr.ToString();
conn.Open();
string datasource = @"e:\data\test.sdb";
ÓÐûÓÐÈ˰¡£¬ÎÒÏÖÔÚ¿ÉÒÔÔÚ³ÌÐòÖн¨Ò»¸ö.sdbµÄÊý¾Ý¿âÒ²¿ÉÒÔÏòÀïд¶«Î÷¡£¿ÉÊÇÓÃSqlite AdministratorÈ´´ò²»¿ª³öÏÖÌáʾ£ºqAdmin£ºcannot perfrom this operation on a closed data test £¬ÓÐûÓиßÊÖÖªµÀÊÇʲôÎÊÌâÂð
Ïà¹ØÎÊ´ð£º
£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......
Cµ÷ÓÃc#µÄweb service£¬ËÒªºÃ·½°¸ËµËµ£¿ÈçºÎµ÷Óã¡Ô½¾ßÌåÔ½ºÃ£¡
ÕâÊÇËÏëµÄÖ÷Ò⣿
ÒýÓÃ
ÕâÊÇËÏëµÄÖ÷Ò⣿
ÏÖʵ¾ÍÊÇÕâô²Ð¿á£¬ÖÕ¶ËÆ½Ì¨POS»úÄÇÖÖÍøÂç²¼¾Ö¡£´ó¼ÒÓк÷½°¸¾Í¶à¶àÌṩ¡£
ÓÃc#µ÷ÓÃ×ö³É¶ ......
ÈçÌ⣬ÓÃC#ʵÏÖ£¬ÑéÖ¤ÂëÊÖ¹¤ÊäÈë!ÎÒ»¹ÓÐ30·Ö£¬¶¼¸ø´ó¼ÒÁË?
¹Ø×¢
¼ÌÐøÎÊ?
´ó¼Ò¸øÒâ¼û°É!
ºÜÄÑʵÏÖ¡£
ѧϰ
ºÜÄÑʵÏÖµÄ,ÖÁÉÙÒª¹ýÁËÌÚѶÄÇÒ»¹Ø²Å¿ÉÒÔ....
ÄÜÈÆ¹ýÑéÖ¤ÄÇÒ»µÀ²ÅÐУ¡£¡
......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......