ODBC 連SQLITE
func connDBsqlite($oS)
$ado = ObjCreate("ADODB.Connection") ;'建立一個連線
$ado.open ( "DRIVER={SQLite3 ODBC Driver};Database="&$oS)
WinSetTitle("[CLASS:AutoIt v3 GUI;Title:SQL查詢]", "", "SQL查詢 " & $oS)
EndFunc
原來就這樣就好了
ODBC 連ORACLE
Func connDB($oS, $UR, $PD) ; 連結db的東西
$ado = ObjCreate("ADODB.Connection") ; Create a COM ADODB Object with the Beta version
$ado.ConnectionString = ("Provider=MSDAORA.1;Data Source='" & $oS & "';User Id= '" & $UR & "'; Password='" & $PD & "';")
$ado.Open
WinSetTitle("[CLASS:AutoIt v3 GUI;Title:SQL查詢]", "", "SQL查詢 " & $oS)
EndFunc ;==>connDB
2009年10月23日 星期五
訂閱:
張貼留言 (Atom)
RHEL install EPEL
https://www.linuxtechi.com/install-epel-repo-on-rhel-system/ EPEL dnf install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest...
-
旋轉泡泡: Oracle DataGuard 相關 Oracle DataGuard 檢查開啟狀態 -- 請全貼 -- ===check=== select dbid,name from v$database; select log_mode , OPE...
-
Check Log Mode SQL> select dbid,name from v$database; select log_mode , OPEN_MODE , DATABASE_ROLE from v$database; --Data...
-
download: https://download.owncloud.org/download/repositories/production/CentOS_7/noarch/owncloud-files-10.3.2-2.1.noarch.rpm https://d...
沒有留言:
張貼留言