Dim gObj_Connection As New ADODB.Connection
Dim gObj_Command As New ADODB.Command
Dim gObj_Dataset As New ADODB.Recordset
Const strConnection = "Provider=OraOLEDB.Oracle.1;Password=manager;Persist Security Info=True;User ID=system;Data Source=faxsrv"Private Sub CommandButton1_Click()
gObj_Connection.Open strConnection, "system", "manager", adConnectUnspecified
gObj_Dataset.Open "select * from dual", gObj_Connection, adOpenUnspecified, adLockOptimistic, -1
End SubMailto:[email protected]
Dim gObj_Command As New ADODB.Command
Dim gObj_Dataset As New ADODB.Recordset
Const strConnection = "Provider=OraOLEDB.Oracle.1;Password=manager;Persist Security Info=True;User ID=system;Data Source=faxsrv"Private Sub CommandButton1_Click()
gObj_Connection.Open strConnection, "system", "manager", adConnectUnspecified
gObj_Dataset.Open "select * from dual", gObj_Connection, adOpenUnspecified, adLockOptimistic, -1
End SubMailto:[email protected]
解决方案 »
- vbscript将Excel内容插入数据库问题
- 请教一个关于CreateFile函数的问题
- 请问如何使msflexgrid大小和表格内容多少一起缩放呢?
- inet控件:运行时提示“仍在执行上一请求”???!!!!!!
- 散5500分!被封杀1年积攒的,下午5点前结贴,只给想做版主的!
- 感谢 CSDN !!!为我们提供的这样的论坛!!!!
- 请教datagrid的问题?
- Email日文邮件主题编码问题。
- 勇士\高手,在哪?_______如何实现mschart的x轴和Y轴一样可以用数值自动递增,显示主网格线和细网格线。
- 第一!散分!(还有牢骚,呵呵)
- 那里可以下载这些东西啊
- 谁知道access数据库最多可以有几个表
"Server=OracleServer.world;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;"
OLE DB Provider for Oracle (from Microsoft)
oConn.Open "Provider=msdaora;" & _
"Data Source=MyOracleDB;" & _
"User Id=myUsername;" & _
"Password=myPassword;"
OLE DB Provider for Oracle (from Oracle)
For Standard Security:oConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User Id=myUsername;" & _
"Password=myPassword;"For a Trusted Connection:oConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User Id=/;" & _
"Password=;"
' OroConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"OSAuthent=1;"
Dim Conn As New ADODB.Connection
conn.open strconn
strconn = "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=wangqiang;password=123;Data Source=szic"
Re.Open "select * from ictype where name='" & combName.Text & "'", Conn, adOpenStatic, adLockOptimistic
re!name=....
....
cn.Open StrSql