用VB连接ORACLE数据库,请大家提供一些例子或者是连接字符串谢谢
解决方案 »
- 当目录带有空格时,如何获得程序的完整路径?
- datacombo添加数据
- 求求大家了一个API的问题,困扰我一天了。
- 跳楼分: ActiveReports Pro 内如何用脚本实现这样的一个简单功能?
- 关于mshflexgrid控件的问题
- combobox style=2 ,(不可修改形式),如何来给combobox.text设置一个初始值?
- 关于sqldmo.rll的注册问题!!!!在线等。
- 关于多个系统调用一个ocx控件出错的问题,请问
- 因学习虽要 请大家给一份ADO+ACCESS做出来的数据库源代码给我 不胜感激!!!
- 如何制作一个VB的安装文件?
- 使用tchart控件时怎么给等值线标示值
- 心中有火!想散分求得一好心情!---一文读后有感!!啊。火!!!!
http://community.csdn.net/Expert/topic/3588/3588453.xml?temp=.2525751
http://community.csdn.net/Expert/topic/3417/3417245.xml?temp=.3961298
http://www.connectionstrings.com/
'建立与Oracle数据库的连接
'========================================
Public Function Conn_Oracle(strConn As String) As Boolean
On Error GoTo err1
Dim i As Long
If Not Conn Is Nothing Then Set Conn = Nothing
Set Conn = New ADODB.Connection
'*************************************************************
' Operator = "aaa(111)"
' UserName = "WWW"
' PassWord = "www"
' ServerName = "ORACLE1_LSC"'
' strConn = ""
' strConn = strConn & "Provider=OraOLEDB.Oracle;"
' strConn = strConn & "Data Source=" & ServerName & ";"
' strConn = strConn & "User ID=" & UserName & ";"
' strConn = strConn & "PassWord=" & PassWord & ";"
'*************************************************************
' Debug.Print strConn
Conn.ConnectionString = strConn
Conn.CommandTimeout = 60
Conn.CursorLocation = adUseClient
Conn.Open
'建立表空间
'Conn.Execute "CREATE TABLESPACE ""FLYINGZFX"" DATAFILE 'D:\flyingzfx.dbf' SIZE 5m autoextend on", , adCmdText
'删除表空间(其中一步)
'Conn.Execute "alter database 'D:\flyingzfx.dbf' offline drop", , adCmdText
'添加字段
'Conn.Execute "ALTER TABLE FLYINGZFX.TEMPTEST ADD(CC VARCHAR2(50))"
'修改字段类型
'Conn.Execute "ALTER TABLE FLYINGZFX.TEMPTEST MODIFY(A VARCHAR2(50))"
'删除字段
'Conn.Execute "ALTER TABLE FLYINGZFX.TEMPTEST DROP (A, B) CASCADE CONSTRAINTS"
'删除主键
'Conn.Execute "ALTER TABLE FLYINGZFX.TEMPTEST DROP CONSTRAINT BB CASCADE"
'删除表
'Conn.Execute "DROP TABLE xxxx TRUNCATE CASCADE"
Debug.Print "Connection Success!!!" & " (Conn_Oracle)"
Conn_Oracle = True
Exit Function
err1:
Conn_Oracle = False
Debug.Print Err.Description
Err.Clear
If Not Conn Is Nothing Then
If Conn.State <> 0 Then Conn.Close
Set Conn = Nothing
End If
End Function