Access KeyÆÆ½â
1.Ê×ÏÈ ddicÓÃ戶ÓÃ戶進È룬su01£¬輸ÈëÓÃ戶Ãû£¨“¼ÓÈëÎÒн¨Á¢µÄdev”£©£¬»Ø車£¬½¨Á¢Ò»個ÓÃ戶帳號£¬È»áá°Ñ設ÖÃÃÜ碼£¬profile選項ÖÐ輸Èë“SAP_ALL”(這個ÊÇSAP ALL 認證µÄÒâ˼)£¬±£´æ¾Í¿ÉÁË¡£È»ááLOG OFF¡£
2.ÓÃн¨Á¢µÄ“DEV”µÇ陸£¬Ïµ統會ÌáʾÄã¸ü¸ÄÃÜ碼¡£¸ü¸Ä£¬È»ááÌáʾÄãÊǵÚÒ»´ÎµÇ陸¡£È»áá 開Ê¼ÆÆ½âÁË¡£
(這ÊÇ顯ʾµÄ視´°)
3.£Ó£Å£³£¸£¬¡¡輸Èë"LSKEYF00",È»áá點"DISPLAY", ÕÒµ½ form. JUMP_THE_WALL, ÔÚ¡¡¡¡¡¡¡¡
CALL 'GET_DEVELOPER_KEY' ID 'NAME' FIELD 'ABCDEFGHIJKL'
ID 'CUSTID' FIELD '1234567890'
ID 'KEY' FIELD DUMMY_KEY.
這裡¡£設ÖÃÖÐ斷點£¨Ëù謂設ÖÃÖÐ斷點£¬¾ÍÊǰÑÓÎ標·ÅÔÚ這裡¡£點擊”紅É«stop“°´鈕£©¡£
È»ááÔÙT-CODE裡Ãæ“/o” ×¢ÒâÊÇÓ¢ÎÄ×Öĸo£¬²»ÊÇÁ㡣Ȼáá»Ø車,ϵ統³ö來Ìáʾ."generate new" OR "END SESSION"
Äã±Ø須Éú³ÉеÄ視´°£¬ËùÒÔ點擊“generate new”¡£
ϵ統µÄµÇ陸áá³õʼ½éÃæÓÖ³ö現ÁË,現ÔÚÓÖ¿ÉÒÔ輸Èë“se38”,進ÈëABAP/4 EDITORµÄ½éÃæÁË.
(這ÊÇÐ޸ĵÄ視´°)
4.£Ó£Å£³£¸£¬¡¡輸ÈëLSKEYF00,È»áá點"CHANGE", 這時»ØÍ£ÔÚÖÐ斷點ÉÏ£¬Ô
Ïà¹ØÎĵµ£º
DB2ConnectionString
b2str = "Provider=MSDASQL.1;Password=a$sk6G7;Persist Security Info=True;User ID=DBA;Data Source=ConDB2SFXXK"
AccessConnectonString
accessstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\DMSJK.mdb;Jet OLEDB:database password=" ......
1¡¢Ìí¼ÓADODCµ½´°Ìå
2¡¢ACESSÊý¾Ý¿âÖÐÖÁÉÙÓÐÒ»ÕÅ±í´æÔÚ¡£
Private Sub Form_Load()
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
"C:\Documents and Settings\Administrator\" & _
"My Documents\11.mdb;Pe ......
ÒÔǰµÄʱºòÓÃVCдÁËÁ½ÖÖÁ¬½ÓAccessÊý¾Ý¿âµÄ·½·¨£¬ÎªÁË·½±ãÒÔºó²éÕÒ°ÑÕâÁ½ÖÖ·½·¨×öһϼòµ¥µÄ½éÉÜ¡£Windowsƽ̨µÄÊý¾Ý½Ó¿Ú±ê×¼ÓÐODBC¡¢OLE DB¡¢ADOºÍBorlandµÄBDE½Ó¿Ú£¬ODBC(Open DataBase Connectivity)Ö»ÄÜÓÃÓÚ·ÃÎʹØÏµÐÍÊý¾Ý¿â£¬ÎªÁË·ÃÎʷǹØÏµÐÍÊý¾Ý΢ÈíÉè¼ÆÁËOLE DB½Ó¿Ú²¢ÔÚ´Ë»ù´¡ÉÏÍÆ³öÁËADO(ActiveX Data Objects)¡£± ......
±¾ÎĽ«c#ÓïÑÔ²Ù×÷AccessÊý¾Ý¿âµÄ·½·¨¼ÓÒÔ×ܽᣬÖ÷Òª½â¾öµÄÎÊÌâÈçÏ£º
´´½¨mdb
´´½¨table
¶ÁÈ¡tableÄÚÈÝ
²é
ѯtableÖеÄÄÚÈÝ
ÏòtableÖвåÈëÊý¾Ý
ɾ³ýtableÖеļǼ
ÏòtableÖвåÈëÕÕÆ¬
¶ÁÈ¡tableÖеÄÕÕÆ¬µÈ¡£
ÎÄ
½éÉÜC#
·ÃÎʲÙ×÷AccessÊý¾Ý¿âµÄ»ù´¡ÖªÊ¶£¬²¢Ìá
¹©Ò»¸öÏà¹ØµÄÀý³Ì¡£C#µÄADO.NET»¹²»ÄÜͨ¹ý±à³Ì·½Ê½´ ......
using System;
using System.Data;
using System.Xml;
using System.Data.OleDb ;
using System.Collections;
namespace ePhoto.AccessDAL
{
/// <summary>
/// DBUtil ²Ù×÷AccessÊý¾Ý¿â
/// </summary>
public class DBUtil
{
private Hashtable parmCache = Hashtable.Synchronized(new ......