Microsoft OLE DB Provider for ODBC Drivers 錯誤 '80004005'

ASP 連 SQL SERVER資料庫


Microsoft OLE DB Provider for ODBC Drivers 錯誤 '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server 不存在或拒絕存取。



連線資訊:
ConnString="driver={SQL Server};server=127.0.0.1;uid=sa;pwd=密碼;database=資料庫"


變更:
ConnString="driver={SQL Server};server=(local);uid=sa;pwd=密碼;database=資料庫"

Search Files By LINQ

System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(path);

IEnumerable<System.IO.FileInfo> fileList
            = dir.GetFiles(string.Format("test*.docx"), System.IO.SearchOption.AllDirectories);

var files = from file in fileList
                 where file.Extension == ".docx" &&           DateTime.Now.ToString("yyyyMMdd").Equals(file.LastWriteTime.ToString("yyyyMMdd"))
                 orderby file.LastWriteTime descending
                 select file;

SQL 增加數字千分位

SQL SERVER:
select convert(varchar(1000),cast(欄位 as money),1)

ORACLE:
SELECT to_char(QTY_1, 'FM999,999,990.00')

手動打包*.dll及exe

AppDomain.CurrentDomain.AssemblyResolve += (sender, senderArgs) => {
                var executingAssembly = Assembly.GetExecutingAssembly();
                var assemblyName = new AssemblyName(executingAssembly.FullName).Name;
                var dllName = new AssemblyName(senderArgs.Name).Name;
                var dllUri = assemblyName + "." + dllName + ".dll";
                using (var resourceStream = executingAssembly.GetManifestResourceStream(dllUri)) {
                    var assemblyData = new Byte[resourceStream.Length];
                    resourceStream.Read(assemblyData, 0, assemblyData.Length);
                    return Assembly.Load(assemblyData);
                }
            };

嘗試載入oracle用戶端程式庫時傳出badimageformatexception當與具有32位元的oracle用戶端元件執行64位元模式安裝時會出現此問題

Windows 64 bit安裝 64bit Oracle Client時, 執行程式引起錯誤:
嘗試載入oracle用戶端程式庫時傳出badimageformatexception當與具有32位元的oracle用戶端元件執行64位元模式安裝時會出現此問題


解決方式:
1.下載Oracle Client 32bit免安裝版
2.設定環境變數到path

oracle like 替換

1. like 'A%'

=> instr(欄位,'A')=1




2. like '%A'

=> instr(欄位,'110101')=length(欄位)-length('A')+1







3. like '%A%'

=> instr(欄位,'2')>0

.NET Ajax TabContainer 跳回

TabContainer 設有tab1, tab2, tab3 .....

在某一tab操作時, 會跳回一開始的tab中



解決方式:
TabContainer 加入 AutoPostBack="true"