小弟知道利用ADO連結SQL SERVER 時的寫法是
DIM conn As New ADODB.Connection
DBF_file = "資料庫主機名稱; " & _
"Initial Catalog=資料庫名稱"
connStr = "provider=SQLOLEDB; User ID=sa; PassWORD=;" & _
"data source=" & DBF_file
conn.Open connStr
rs.CursorLocation = adUseClient
但如果要連Orcale 時要怎麼寫呢?
DIM conn As New ADODB.Connection
DBF_file = "資料庫主機名稱; " & _
"Initial Catalog=資料庫名稱"
connStr = "provider=SQLOLEDB; User ID=sa; PassWORD=;" & _
"data source=" & DBF_file
conn.Open connStr
rs.CursorLocation = adUseClient
但如果要連Orcale 時要怎麼寫呢?
全站熱搜
留言列表