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

PBÖÐÁ¬½ÓAccessÊý¾Ý¿âµÄÈýÖÖ·½·¨

PBÖÐÁ¬½ÓAccessÊý¾Ý¿âµÄÈýÖÖ·½·¨
·½Ê½Ò»£º
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='driver=Microsoft Access Driver (*.mdb);DBQ=c:\foodmart.mdb'"
CONNECT;
IF SQLCA.SQLCode <> 0 THEN
MessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü","ÇëÓë¹ÜÀíÔ±ÁªÏµ¡£´íÎóºÅ:" + String(SQLCA.SQLCode) + "~r~n´íÎóÔ­Òò:" + SQLCA.SQLErrText)
RETURN
else
MessageBox("Êý¾Ý¿âÁ¬½Ó³É¹¦","ÏÖÔÚ½øÈëϵͳ... ...")
end if
·½Ê½¶þ£º
SQLCA.DBMS = "OLE DB"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PROVIDER='Microsoft.Jet.OLEDB.4.0',DATASOURCE='C:\foodmart.mdb'"
CONNECT;
·½Ê½Èý£º
½¨Á¢DSN£¬Í¨¹ýODBCÁ¬½Ó¡£Õâ¸ö¾Í²»Óöà˵ÁË¡£
ÀýÈç:
// Profile my_ass
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=my_ass'"
catalog tables could not be created and are not available for use ÎÊÌâ½â¾ö·½·¨:
ÕâÖÖÇé¿ö¶à¼ûÓÚ´ÓSQL server ×ªµ½ Access Êý¾Ý¿â,ÓÃODBCÁ¬½ÓµÄÇé¿ö
°ÑsqlserverÊý¾Ý¿âÀïµÄÎå¸ö‘pb’×Öĸ¿ªÍ·µÄÊý¾Ý±íµ¼Èëµ½accessÊý¾Ý¿âÀïÈ¥£¬ÔÙÁ¬½Ó¾Í²»ÌáʾÁË
¹ØÓÚ¶¯Ì¬×¢²áODBCÊý¾ÝÔ´
¹ØÓÚ¶¯Ì¬×¢²áAccessÊý¾ÝÔ´
//***********************************************
// º¯ÊýÃû: gf_setodbc_access
//     ¹¦ÄÜ: Íê³ÉaccessÊý¾ÝÔ´µÄ×¢²á¹¦ÄÜ
// ÊäÈë²ÎÊý:
//   as_database Êý¾Ý¿âÃû
//   (¼´AccessÊý¾Ý¿âÎļþÃû×Ö£¬²»º¬À©Õ¹Ãû)
//   as_path   Êý¾Ý¿âÎļþËùÔÚµÄĿ¼
// ·µ»ØÖµ:
//   true ±íʾ×Ô¶¯ÅäÖóɹ¦
//   false ±íʾ×Ô¶¯ÅäÖÃʧ°Ü
// Éè¼ÆÕß: Adamswater
// Íê³Éʱ¼ä: 2005Äê6ÔÂ
//***************************************************
boolean lb_rtn
string ls_root,ls_root_dsn,ls_root_Jet,ls_root_Engines
integer li_rtn
string ls_


Ïà¹ØÎĵµ£º

C#²Ù×÷ACCESSÊý¾Ý¿â(´´½¨,ѹËõ,±¸·Ý,»Ö¸´)(תÔØ)

ÏÂÃæÕâ¶ÎC# ´úÂë¿ÉÒÔÓÃÀ´Ñ¹ËõºÍÐÞ¸´AccessÊý¾Ý¿â,²»¹ÜËüÊÇÒ»¸ö¼òµ¥µÄ".mdb"ACCESSÊý¾Ý¿â»¹ÊÇÒ»¸ö".mdw"ÍøÂç¹²ÏíÊý¾Ý¿â,Õâ¸ö¹ý³ÌºÍÄãÔÚÓÃMS AccessÓ¦ÓóÌÐòÖÐʹÓõÄ"¹¤¾ß-Êý¾Ý¿âʵÓù¤¾ß-ѹËõºÍÐÞ¸´"ʱִÐеIJÙ×÷ÍêÈ«Ò»Ñù.ʵÀý´úÂëʹÓÃÁË"³Ù°ó¶¨"(ÔËÐÐÖÐÔÚÄÚ´æÖн¨Á¢COM¶ÔÏó),ÕâÑù¾Í²»ÐèÒªÔÚ¹¤³ÌÖмÓÈëCOMÒýÓÃÁË,Ò²²»ÐèÒªÔÚP ......

ÀûÓà DataGridView »æÖÆͼƬÁÐ±í£¨´ÓAccess¶ÁȡͼƬ£©

using System;
using System.IO;
using System.Runtime.InteropServices;
using System.Threading;
using System.Windows.Forms;
using Microsoft.Win32;
using Access = Microsoft.Office.Interop.Access;
namespace ImageAccess
{
    static class Program
    {
   ......

¹ØÓÚACCESSÏÂOleDbParameterµÄʹÓÃ

½ñÌ죬»¹ÊÇÔÚ×öÄǸöÏîÄ¿£¬ÒÀȻʹÓÃÍù³£µÄsqlhelperÓ÷¨£¬Íù³£µÄÊý¾Ý¿â²Ù×÷À࣬µ«ÊÇÆ«Æ«µ÷ÊÔ²»³É¹¦£¬¶øÇÒ×îÖØÒªµÄÊÇ£¬Ëü²»±¨´í
ÖÐÎç³Ô·¹»ØÀ´£¬±¾À´Ïë´òËã˯¸öÎç¾õµÄ£¬µ«ÊÇÏîÄ¿Ì«½ôÆÈÁË£¬ÓÚÊÇÓÖ¸ú³µ³µÑо¿ÁËÒ»ÖÐÎ磬×îºó£¬·¢ÏÖÈç¹û²»ÓÃ@²ÎÊý´«µÝµÄ»°£¬ÊÇÕý³£ÔËÐеģ¬ÓÚÊÇ°Ù¶ÈÁËһϣ¬ÄÇЩÈË˵ҪÓÓ£¿”µ±Õ¼Î»·û
......

ACCESS¶¨Ê±Ô¶³Ì±¸·Ý

ACCESSÔ¶³Ì±¸·ÝÒ»Ö±ÊǸöÁîÈËÍ·ÌÛµÄÎÊÌâ ¿´µ½Ò»¸ö²»´íµÄ±¸·Ý·½·¨ ·ÖÏíÏ£º
Ô­ÎĵØÖ·£ºhttp://www.cnblogs.com/catcat811/archive/2009/12/31/1637186.html
ÍøÕ¾ÓÖ¹ØÁË~~~¹ØµÃºÜͻȻ£¬Êý¾ÝÒ²À´²»¼°±¸·Ý¡£ÒòΪ¹«Ë¾Óиö²Ö¿âµÄϵͳÔÚ×âÓ÷þÎñÆ÷ÉÏ£¬Èç¹ûÍ£Á˾͵ÃÖØеã²Ö£¬ÄÇÊǺÜÀÛÈ˵ÄÊ¡£×î½üÍøվʱ³£¹Ø£¬ÕæÈÃÈËÍ·Í´¡£ÎªÁ˱Üà ......

php Á¬½ÓaccessµÄ´úÂë

<?php
$connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("data.mdb");
$connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC);
$issuetime=date("Y-m-d H:i:s");
$sql="insert into test values("","",...)";
$result=odbc_exec($connid,$sql);
if($result) echo "successful";
else ec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ