Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle database front end

989503Feb 6 2013 — edited Feb 11 2013
Hello, I hope I'm in the right section here!

I'm creating a management system for football for a project at uni. I've created all my tables using SQL Developer and done this using a localhost connection. All my tables and queries are running as I want in SQL Developer so the next stage is to create a front end for the database using Visual Basic. I've downloaded Microsoft Visual Studio 2012 and seemingly had successfully connected to my localhost database using the Tools tab in Visual Studio followed by 'Connect to Database'.

At this stage I believed that I had successfully connected because all of the tables I had created in SQL Developer were showing down the left hand side of the Visual Studio page under the localhost connection in Server Explorer. I am able to right click any of my tables (e.g. players, managers, fixtures, etc) and select the 'Show Table Data' command.. This successfully displays all of the records that I had put in using SQL Developer. The really confusing bit starts here:

When I go to try and actually write a new query in Visual Studio for any of these tables by right clicking them and selecting 'New Query', the Add Table box that comes up shows none of my tables and in fact only contains the default HR tables such as employees (HR), departments (HR), countries (HR), etc. The same applies if I try and select a data source for my Visual Studio project, it seemingly connects to my localhost database but then displays only the default tables.. none of my football related tables (which show up fine in the Server Explorer) are showing.

I'm really confused at this stage, I'm new to Visual Studio (as you may have guessed!), but at this stage unless I've missed something obvious I just don't understand why I am unable to manipulate my tables.

Does anyone have any ideas?

I'll be happy to give any more info if needed! Thanks!!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2013
Added on Feb 6 2013
12 comments
14,871 views