Maxwell Tech Note

發表文章

The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine.

The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine. When running 64-bit windows and there are no MS Access drivers that run 64 bit.So to resolve it you need to change the build configuration to x86 found in the programs properties. Then click on Build and change the Platform target from Any CPU to x86.Recompile your program , it works like charm. http://ybbest.wordpress.com/2009/07/22/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine/

閱讀完整內容

[SQL server]手動將結構描述改成dbo

手動將結構描述改為dbo 開啟Microsoft SQL Server Management Studio==>選擇該資料庫==>選擇資料表，其結構描述為使用者名稱的==>到資料表上按滑鼠右鍵，選擇設計==>在屬性中選結構描述==>變更擁有者為dbo，存檔==>擁有者就改為dbo，就可刪除帳號即可

閱讀完整內容

Google API for .net

http://code.google.com/p/google-api-dotnet-client/ 記錄一下有天應該會用到的

閱讀完整內容

[asp]asp + JSON

送出Json的asp  <% Dim member Set member = jsObject() member("name") = "MAX" member("surname") = "max" member("message") = "Hello World" member.Flush %> 接收json的asp <!DOCTYPE html> <html> <head> <script src="http://code.jquery.com/jquery-latest.js"></script> </head> <body> <div id="dname"></div> <script> $.getJSON("jsonTest.asp", function(data) { $("#dname").text(data.name); }); </script> </body> </html> aspjson

閱讀完整內容

[JQuery]checkbox 是否被選取或checked設定

set $("#your-checkbox-id").attr('checked') $("#your-checkbox-id").removeAttr('checked') 判斷 if ( $("#your-checkbox-id").attr('checked') ) { something(); }

閱讀完整內容

[ASP] Use HashTable In asp

用CreateObject("Scripting.Dictionary") 來產生 hashtable Set MyHash = CreateObject("Scripting.Dictionary") MyHash.Add "key", "Value" hashKeys = MyHash.keys for each k in MyHash.keys responsew.write( MyHash.Item(k)) next VBScript » Objects » Dictionary

閱讀完整內容

[jQuery]JQuery Validation and Ajax

imports jquery.min.js imports jquery.validate.min.js [Ajax] function callAjax(){ $.ajax({type: "POST", url: "ajax.asp", data: {fun: "checkCardNO", CardNo: $("#CardNo").val()}, dataType:"html", success:function(msg){ $("#AjaxValue").val(msg); /* Use Hidden input or div to transfer Ajax Value */ } }) } [Form Validation] --Add Validation Function $.validator.addMethod("checkRegisterd", function(value, element) { callAjax(); if($("#AjaxValue").val()=="Unregisted") return true; } ); $.validator.addMethod("Useless", function(value, element) { callAjax(); if($("#AjaxValue").val()!="noData") return true; } ); --Validation $().ready(function() { $("#form1").validate({ rules: { CardNo: { required: true, Useless: true, checkRegisterd: true }, Name: "required", Tel: { require...

閱讀完整內容