hi
i am Raghavendra. I dont know anything abt how to connect to oracle (sql) from VB 6 . could u plz let me know d steps n d code for executing the queries. its very urgent plz let me know
gurutheja
0
Newbie Poster
Recommended Answers
Jump to PostHi Raghu,
Add References
Microsoft ActiveX Data Object Library 2.0 to ur projectConnection To Oracle is :
Dim adoCn As New ADODB.Connection Dim sSQL as String Dim RST As New AdoDb.RecordSet sSQL= "Provider=MSDAORA.1;Password=MyPwd;" _ & " User ID=MyUserName;Data Source=MyDataSource;" _ & " Persist Security …
Jump to PostHi,
No Need To add any Active x or oledb control.
Just add the References in Project Menu.
Microsoft ActiveX Data Object Library 2.0Place Text1, Text2 TextBoxes on the Form.
Change DatabaseName, UserID and Password according to ur connections.
In Form Level After the Option Explicit …
All 8 Replies
QVeen72
104
Posting Shark
gurutheja
0
Newbie Poster
QVeen72
104
Posting Shark
gurutheja
0
Newbie Poster
afreaz
0
Newbie Poster
Comatose
290
Taboo Programmer
Team Colleague
jikraant
0
Newbie Poster
azizulkhn
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.