accessÁ¬½Ó×Ö·û´®ÎÊÌâ
¿É²»¿ÉÒÔ°ÑaccessÁ¬½Ó×Ö·û´®Ð´½øÒ»¸öÀàÖУ¬È»ºóÒªÓõÄʱºòµ÷ÓÃ
¾ÍÏñSQLÄÇÑùÑù£º
using System.Data.SqlClient;
public class DBHelper
{
public DBHelper()
{
}
public static SqlConnction Create()
{return new SqlConnection("server=.;uid=sa;pwd=;database=xxx.mdf");}
}
µ÷ÓõÄʱºòÖ±½ÓSqlConnetion conn=DBhelper.Create();
Èç¹ûÊÇACCESSµÄ»°ÔõôҲ£¬ÎÒÏñÕâÑùÊÔ¹ý£¬Ìáʾ¡°ÉÏÏÂÎÄÖв»´æÔÚserver¡±accessÏà¶Ô·¾¶ÓÃServer.MaPpath()
¿ÉÄܵģ¬ÄãÒ²¿ÉÒÔÓö¯ÈíµÄ´úÂëÉú³ÉÆ÷À´ÊµÏÖ¡£×Ô¶¯Éú³É¡£
private string _strConn;
private string strConnection
{
get {
if( _strConn==null )
_strConn ="Provider=Microsoft.Jet.OleDb.4.0; data source=" + Server.MapPath(".")+"\\dbWebIS.mdb";
return _strConn;
}
}
connectionstring.com
<add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺
×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏÂ
HTTP Status 500 -
------------------------------------------------------------------------------- ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......