Á¬½ÓACCESSÊý¾Ý¿â·¢Éú´íÎó
private void but_login_Click(object sender, EventArgs e)
{
string constring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\³ÌÐòÁ·Ï°\\database\\data.accdb;Persist Security Info=False ";
OdbcCommand comm = new OdbcCommand();
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = constring;
comm.Connection = conn;
conn.Open();
comm.CommandText = "select * from user where user_name="+teb_username.Text +"and user_password="+teb_password.Text;
OdbcDataReader reader = new OdbcDataReader();
reader = comm.ExecuteReader();
if (reader.HasRows)
.........
ÔÚconn.open();ÖгöÏÖ´íÎó£¬ÌáʾERROR [IM002] [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\½Ìѧ\HandsOn\DesignPattern\SimpleFactory\SF.mdb;User Id=admin;Password=;
ÕâÊÇÎÒÔÚÅäÖÃÎļþдµÄ×Ö·û´®£¬Äã±È½Ïһϰ¡
\\data.accdb
accessÓ¦¸ÃÊÇmdb½áβ°É£¿
Ó¦¸ÃÊÇÄãµÄÁ¬½Ó×Ö·û´®ÓÐÎÊÌâ accessÊý¾Ý¿âµÄºó׺ÃûÊÇmdb°É »¹ÓоÍÊǰÑpersist security InfoÉèÖÃΪTrueÊÔÒ»ÊÔ
ûÁ¬ÉϿ⣬¼ì²éÁ¬½Ó´®Óï¾ä´íÎó¡£
½¨Ò飺
ÔÚweb.config/app.configÖж¨Òå
<add key="DatabaseType" value="Oledb"/>
<add key="ConnectionString" value="provider=microsoft.jet.oledb.4.0;Data Source="/>
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
ÇëÎÊÓÐÈËÖªµÀÈçºÎÔÚkernel mode ÏÂд64 bit driver, ¿ÉÒÔ½«IO bitmap ´ò¿ª£¬
32bit¿ÉÒÔÓÃKe386SetIoAccessMapºÍKe386IoSetAccessProcess£¬
Çë問64 bit driverÓÐÀàËÆµÄfunctionaÂð?
ûŪ¹ý¡£
GoogleµÄ£ºhtt ......