| Connecting SQL*Plus to VB6 and Access [message #323230] |
Tue, 27 May 2008 18:23  |
sqlnoob
Messages: 2
Registered: December 2007
|
Junior Member |
|
|
Hi
I'm doing an assignment and stuck on two of the tasks. I need to know how to connect a database created in SQL*Plus to a MS Access database. I also need to connect the same database to Visual Basic (v6).
I currently have a table in SQL*Plus with the following fields:
StudentID, CourseID, First_Name, Surname.
StudentID is a primary key and CourseID is a foreign key.
I've been looking through all my notes and doing a lot of research on the Internet on how to do these tasks but have not been successful. If someone can provide an example, that would be really useful.
Thank you.
|
|
|
|
| Re: Connecting SQL*Plus to VB6 and Access [message #323234 is a reply to message #323230] |
Tue, 27 May 2008 18:42  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
I suggest you contact the instructor or at least a classmate.
> I need to know how to connect a database created in SQL*Plus to a MS Access database.
1) One does not connect an Oracle database to anything.
2) at best, a piece of client s/w connects to Oracle database.
3) While Oracle can inter-operate with MS-Access, said interactions are typically initiated by having MS-ACCESS connect to Oracle.
> I also need to connect the same database to Visual Basic (v6).
the same database as opposed the other database?
Exactly how does one "connect" anything to a programming lanuage, like VB?
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above
[Updated on: Tue, 27 May 2008 18:43] by Moderator Report message to a moderator |
|
|
|
| Re: Connecting SQL*Plus to VB6 and Access [message #323248 is a reply to message #323230] |
Tue, 27 May 2008 22:42 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
I think it is better to think you want to read/write an Oracle table from MS/Access and a VB6 program.
Both undertand ODBC.
Search for "Oracle VB (or VB6 or Visual Basic) ODBC" and you will find many solutions.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
