How Can I Connect VB To Oracle?
I want to know the step by step process to connect VB to Oracle database.
2 Answers - Sort by: Date | Rating
Visual Basic is very easy to use and to much popular language.Microsoft provides this language.and mainly this language is used for window based applications.
data access methods that all accomplish exactly the same task are DAO, RDO, ADO and OLE DB
DAO
DAO stands for Data Access Objects it permits Visual Basic application to talk to a database. for the manipulation of databases it uses the Jet Database Engine.the functionalities of the jet engine is as like the ODBC.
RDO
RDO stands foe Remote Data Objects.it permits Visual Basic to talk to relational databases.it is the need of Enterprise Edition of the visual basic to use the RDO.
ADO
ADO stands for Active X Data Objects.its permits VB and other web tools to interface with different type of data sources.ADO is very simple in use and very powerful.
OLE DB
OLE DB ,utilizes a set of COM interfaces for finding and arranging the data.
RDO and DAO are working for backward compatibility.but it is batter to convert to ADO or OLE-DB.
code for connecting the VB with oracle:
Set Cn = New ADODB.Connection
With Cn
.connection string = Conn
.cursor location = adUseClient
.Open
End With
If Cn.State = adStateOpen The
MsgBox "Connection successful."
End If
'Connect to Oracle server end
'close connection begin
Cn.Close
Set Cn = Nothing
Set CP = Nothing
'close connection end
data access methods that all accomplish exactly the same task are DAO, RDO, ADO and OLE DB
DAO
DAO stands for Data Access Objects it permits Visual Basic application to talk to a database. for the manipulation of databases it uses the Jet Database Engine.the functionalities of the jet engine is as like the ODBC.
RDO
RDO stands foe Remote Data Objects.it permits Visual Basic to talk to relational databases.it is the need of Enterprise Edition of the visual basic to use the RDO.
ADO
ADO stands for Active X Data Objects.its permits VB and other web tools to interface with different type of data sources.ADO is very simple in use and very powerful.
OLE DB
OLE DB ,utilizes a set of COM interfaces for finding and arranging the data.
RDO and DAO are working for backward compatibility.but it is batter to convert to ADO or OLE-DB.
code for connecting the VB with oracle:
Set Cn = New ADODB.Connection
With Cn
.connection string = Conn
.cursor location = adUseClient
.Open
End With
If Cn.State = adStateOpen The
MsgBox "Connection successful."
End If
'Connect to Oracle server end
'close connection begin
Cn.Close
Set Cn = Nothing
Set CP = Nothing
'close connection end
0
0
You can use ODBC(Open Database Connectivity) to link them up. In the control panel, find administrative services and click on odbc and follow the instructions.
0
0
- Hi What's The Main Difference Between Oracle 10g & 11i?
- Which Types Of Backups You Can Take In Oracle?
- How We Uninstall Oracle?
- How To Increase Sga Size Dynamically In Oracle 10g?
- Pls Advice Good Oracle DBA Course Centres In Bangalore With Good Trainer And Less Fees?
- What Are The Ways Of Connecting To The Net?
- What Is Online Redo Log Files?
- What Is The Diff Between Oracle 8i,9i,10g From Developer Point Of View?
- Difference Between Looping Statements In C And Oracle?
- Which Is The Best Institute For Oracle In Chennai?
- How Can I Connect Vb With Oracle Through Properties Connectivity And Coding Both?
- Through Properties Connectivity How We Connect Vb With Oracle?
- What Is A Redo Logfile?
- Is Oracle Course Iis Necessary For To Get A Better Job?
- How Can I Connect Oracle Database From VB6 Code Using ADO DB Connection?
- Who Or What Is The Oracle At Delphi And Why Do The The Bans Hope This Oracle Can Help Them?
- How Do I Move A Database From My Pc To The Server?
- Which King Consulted The God Through The Use Of Oracle Bones?
- What Is Mean By Citect Scada Cluster?
- How To Find The Setup Of Oracle 9i?
- How Can You Upgrade Your Apps If You Don't Have The Money?
- How To Setup The Cluster?
- What Is Trigger And How We Will Use It In Oracle?
- How To Connect VB With Oracle?
- Why Is NI-ST Is Concerned About IEEE's 802.11i WLAN?

New Comment - Comments are editable for 5 min.