以下是簡單化的VB程式碼：
1、MS SQL server
Private Sub Form_Load()
Dim scn As ADODB.Connection
Dim srs0 As ADODB.Recordset
Set scn = New ADODB.Connection
scn.ConnectionString = "Provider=SQLOLEDB.1;Password= PPP;User ID= UUU;Data Source=XXX;Persist Security Info=True"
scn.Open
Set srs0 = New ADODB.Recordset
srs0.Open "select teacher_id from ieteacher", scn, adOpenKeyset
Set DataGrid1.DataSource = srs0
End Sub
2、Oracle
Private Sub Form_Load()
Dim scn As ADODB.Connection
Dim srs0 As ADODB.Recordset
Set scn = New ADODB.Connection
scn.ConnectionString = "Provider=MSDAORA.1;Password=PPP;User ID=UUU;Data Source=XXX;Persist Security Info=True"
scn.Open
Set srs0 = New ADODB.Recordset
srs0.Open "select teacher_id from ieteacher", scn, adOpenKeyset
Set DataGrid1.DataSource = srs0
End Sub
同樣的程式...只是（連線字串）不同，為什麼MS SQL server 就可以select資料
可是Oracle 卻不行....還顯示..『資料列集無法設定書籤』.....
但是用SQL plus 卻可以....
但是Oracle可以連線進入喔....是因為Oracle的database權限有問題嗎？？
好奇怪....同樣都是以（連線字串）來做的...
請各位高手幫忙看看......