7,763
社区成员
发帖
与我相关
我的任务
分享江湖救急!!!!精通ORACLE和VB的大哥请进!!!!!
VB中存取ORACLE数据库的BLOB数据类型。为何我使用DSN可以存取，而用连接字符串连接可以成功，但却不能存取，以下是代码。
Dim conn As New ADODB.Connection
Dim rs As ADODB.Recordset
conn.CursorLocation = adUseClient
conn.ConnectionString = "Provider=MSDAORA;Driver={Microsoft ODBC for oracle};SERVER=ADGISDEV;UID=grm;PWD=;"
conn.Open
Set rs = conn.Execute("SELECT A.EM_USERNAME, A.EM_APPNAME,A.EM_BODY from EM_APPLICATION A", 64)
Dim conn As New ADODB.Connection
Dim rs As ADODB.Recordset
conn.CursorLocation = adUseClient
conn.ConnectionString = "Provider=MSDAORA;Driver={Microsoft ODBC for oracle};SERVER=ADGISDEV;UID=grm;PWD=;"
conn.Open
Set rs = conn.Execute("SELECT A.EM_USERNAME, A.EM_APPNAME,A.EM_BODY from EM_APPLICATION A", 64)
...全文
