如果某一oracle資料源不能在oracle的tnsnames.ora檔案中明確定義，而想在引數檔案（ini）或從資料表中動態提取其IP、SID等資訊，如何動態生成oracle連接串或采用其他方法連接到oracle？請各位大俠賜教，先謝了！
uj5u.com熱心網友回復：
用jdbc連uj5u.com熱心網友回復：
同意用jdbc連接uj5u.com熱心網友回復：
麻煩看下:http://topic.csdn.net/u/20080325/17/16a4b5ba-0a69-4ba3-9926-a183e7fa4b94.html另:PB9如何用JDBC鏈接Oralce10:
SQLCA.DBMS = "JDBC"
SQLCA.LogPass = "123"
SQLCA.LogId = "system"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Driver='oracle.jdbc.driver.OracleDriver',URL='jdbc:oracle:thin:@192.168.0.1:1521:orcl'"
connect using sqlca;
總是提示:Count not load class oracle.jdbc.driver.OracleDriver
還需要什么驅動檔案嗎?
給指個明路吧,超急呀
uj5u.com熱心網友回復：
給你貼一段原始碼//配置資料源
// Profile BDJXPG
SQLCA.DBMS = "O90 Oracle9i (9.0.1)"
SQLCA.LogPass = "DB4S.SERVER"//"DB4S.114"
SQLCA.ServerName = "DB4S"
SQLCA.LogId = "test"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PBCatalogOwner=test,TableCriteria=',test"
connect using sqlca;
guo_sound = CREATE uo_command
//驗證資料庫是否連接成功
IF SQLCA.SQLCODE = 0 THEN
//打開公告欄視窗
//open(w_ggl)
//初始化環境變數陣列
f_checkprocinvalid()
gs_envparameter[] ={"單位編碼","","單位名稱","","實際人數","","在編人數","","操作人員","","系統日期","","系統時間","","客戶端IP","","主機名稱","","用戶角色","","用戶型別","","用戶名稱",""}
//創建用戶權限物件
iuo_getright = create uo_getright
Open(w_login)
//OPEN(w_chose1)
ELSE
MessageBox("系統資訊","不能連接資料庫,請配合管理員檢查網路狀態! ")
return
END IF
uj5u.com熱心網友回復：
lz要干嘛？轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/116505.html
標籤：數據庫相關