Lost universe of Programing

USERNAME :- Forum Post:-114
HomePortalGalleryRegisterLog in


 Data Base Connectivity Through ORACLE

Go down 

Number of posts : 160
Age : 33
Location : Lucknow
Job/hobbies : Software Engeener
What U like To do ? : Because Its Rock with me.
Registration date : 2008-01-06

Data Base Connectivity Through ORACLE Empty
PostSubject: Data Base Connectivity Through ORACLE   Data Base Connectivity Through ORACLE I_icon_minitime1/21/2008, 11:54 pm

1.First A recordset,connection and command object is established before making any connection in oracle
2.adocon.ConnectionString = "Provider=MSDAORA;user id =internal;password =oracle;"
Through this syntax connect the vb 6.0 application through oracle

User ID = scott and password = Tiger can be also used
3. through the following code given below u can connect to the oracle,

Quote :

Dim StrSQL As String
Dim adoRecSet As ADODB.Recordset
Dim adocon As ADODB.Connection
Dim ConnectionString As String
Set AdoCmd = New ADODB.Command
Set adocon = New ADODB.Connection
adocon.ConnectionString = "Provider=MSDAORA;user id =internal;password =oracle;"
StrSQL = "Insert Into product values ('" & Text1.Text & "','" & Text2.Text & "','" & Text3.Text & "','" & Text4.Text & "')"
AdoCmd.ActiveConnection = adocon
AdoCmd.CommandText = StrSQL
AdoCmd.CommandType = adCmdText


""-(`v)-"HACKER OF HEART"-(`v)-"
Data Base Connectivity Through ORACLE Earth10
Back to top Go down
View user profile http://aspx.forumotion.com
Data Base Connectivity Through ORACLE
Back to top 
Page 1 of 1
 Similar topics
» JavaScript Chess
» Pixel Base
» Terminator- 2012 Year Base book (Private book, now public)
» Stuck on getting data centers?
» Opening Base Books (ctg)

Permissions in this forum:You cannot reply to topics in this forum
Lost universe of Programing :: --=| SOURCE CODE |=-- :: C/C++ SOURCE CODE-
Jump to: