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

access db

 class Program
    {
        static void Main(string[] args)
        {
            String conStr = "Data Source=mesqas;User ID=ctdsp_oee;Password=12345678";
            OracleConnection con = new OracleConnection(conStr);
            try
            {
                con.Open();
                OracleCommand com = con.CreateCommand();
                com.CommandText = "select * from temp";
                OracleDataReader read = com.ExecuteReader();
                while (read.Read())
                {
                    Console.WriteLine(read.GetString(1));
                 
                  
                }
                Console.ReadLine();
                read.Close();
      


Ïà¹ØÎĵµ£º

ÈçºÎѹËõ´øÓÐmdw°²È«Îļþ»úÖÆºÍÃÜÂëµÄµÄaccessÊý¾Ý¿â

a £½ “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\Êý¾Ý¿â.mdb;Password=¹ÜÀíÔ±ÃÜÂë;User ID=¹ÜÀíÔ±ÕʺÅ;Jet OLEDB:Database Password=Êý¾Ý¿âÃÜÂë;Jet OLEDB:System database=d:\system.MDW;”  ' ´Ë´¦Óû§ÕÊ»§±ØÐë¾ßÓйÜÀíԱȨÏÞ²ÅÐÐ,´Ë´¦ÊÇÖ¸Á¬½ÓÐèҪѹËõµÄÊý¾Ý¿âµÄÁ¬½Ó´úÂë.
 
b £½ &ldq ......

ÈÃÈËÎÞÓïµÄAccess¹Ø¼ü×Ö

×ö±ÏÒµÉè¼Æ£¬×î³õ¿¼Âǵ½·½±ãÐÔ£¬ÔÚÑ¡ÔñÊý¾Ý¿âʱ¾ÍÓÃÁËAccess£¨¿ÉÒÆÖ²ÐÔ̫ǿÁË£©£¬ÔÚ²âÊÔʱÅ׳öÁËÕâÑùµÄ´íÎó£º
System.Data.OleDb.OleDbException: INSERT INTO Óï¾äµÄÓï·¨´íÎóÒì³£
±éÑ°ÍøÉϸßÈË£¬Ëµ·¨¶¼¸÷²»Ò»Ñù£¬²»¹ý×îºó»¹ÊÇÕÒµ½ÁËÎÊÌâËùÔÚ£ºAccess±£Áô×Ö£¡
ÒòΪÔÚÊý¾Ý¿âÉè¼ÆÊ±Ã»Óп¼Âǵ½ÁÐÃû»áÓëAccess±£Áô×ÖÖØ¸´£¬Ëì ......

ʹÓÃrubyÓëMS AccessÊý¾Ý¿â½»»¥

ruby³£¹æ·ÃÎÊaccessÊý¾Ý¿âµÄ·½·¨Ó¦¸ÃÊÇʹÓÃDBI¿â
£º
require 'dbi'

DBI.connect("DBI:ADO:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb;")

¿ÉÊÇ
¼òµ¥³¢ÊÔÖ®ºóûÄܳɹ¦£¬ÌáʾÕÒ²»µ½Çý¶¯Æ÷ADO,ÀÁµÃÔÙÊÔ£¬ËìÕÒÆäËû·½·¨¡£
Ò»·¬ËÑË÷Ö®ºó£¬·¢ÏÖ¿ÉÒÔÓÃWIN32OLEÀ´·ÃÎÊaccess,дһ¸ö¼òµ¥µÄÀà°ü×°Ö®: ......

JavaScript Access´úÂë²Î¿¼

///ÏÂÃæÊǶÔAccessµÄÁ´½Ó
function getCountfromDB() {
    //ÒÔµ±Ç°Ò³ÃæÎļþΪ»ù´¡£¬ÕÒµ½ÎļþËùÔڵľø¶Ô·¾¶¡£
    var filePath = location.href.substring(0, location.href.indexOf("Cnt.htm"));
    var path = filePath + "MyData.mdb";
    //È¥µ ......

MFC ´úÂëÅäÖÃACCESSµÄODBCÁ¬½Ó

 SQLConfigDataSource
´´½¨ODBCÊý¾ÝÔ´¿ÉÒÔµ÷ÓÃWindowsϵͳ×ÓÄ¿
¼ÏµĶ¯Ì¬Á´½Ó¿âOdbcint.dllÖеĺ¯ÊýSQLConfigDataSource()
¸Ãº¯Êý¿ÉÒÔ¶¯Ì¬µØÔö¼Ó¡¢Ð޸ĺÍɾ³ý
Êý¾ÝÔ´¡£
SQLConfigDataSource()º¯Êý
SQLConfigDataSource()µÄÔ­ÐÍÈçÏÂ:
BOOL SQLConfigDataSource(HWND hwndParent, UINT
fRequest ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ