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.
|
|
|