 |  |  |  |  |  |  |  |
about project
 |
What are the visual basic project with backend oracle. how the database connctivity is done with VB .
Easy Way to Connect Oracle from VB
Install Oracle Client on your system
'Connection Object for Oracle Database connection
Dim con As ADODB.Connection
'Recordset Object for Oracle Tables
Dim rst As New ADODB.Recordset
con.Open "Provider=MSDAORA;Data Source=OracleDataBase;User ID=OracleUserID; Password=OraclePassword;
rst.Open "Select * From OracleTableName"
Do While Not rst.EOF
'Do the Processing here Display etc
Msgbox rst("No")
Msgbox rst("Name")
rst.MoveNext
Loop
rst.close
con.close
set rst = Nothing
Set con = Nothing
Install Oracle Client on your system
'Connection Object for Oracle Database connection
Dim con As ADODB.Connection
'Recordset Object for Oracle Tables
Dim rst As New ADODB.Recordset
con.Open "Provider=MSDAORA;Data Source=OracleDataBase;User ID=OracleUserID; Password=OraclePassword;
rst.Open "Select * From OracleTableName"
Do While Not rst.EOF
'Do the Processing here Display etc
Msgbox rst("No")
Msgbox rst("Name")
rst.MoveNext
Loop
rst.close
con.close
set rst = Nothing
Set con = Nothing
|
Similar Threads
- Project idea (C#)
- Senior Software Project Manager (Software Development Job Offers)
- Project on offer - GUI for ATi Drivers (Software Development Job Offers)
- Wade Robson Project (Geeks' Lounge)
- ASP .NET web apps/service in VS.NET won't let me name the project? (ASP.NET)
- amateur coders needed , project in audio streaming (C++)
- Group Project Ideas (Geeks' Lounge)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: I cannot se 2 fields using crystal reports
- Next Thread: how do i use selectionformula using 2 fields
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
