Re: VB6 pro & oracle express 10g From: Philippe Martin <pmartin@snakecard.com> Reply-To: pmartin@snakecard.com Date: Thursday 23 March 2006 02:21:06 pm Groups: comp.lang.basic.visual.database no references

Hi it was a schema problem

Philippe Martin wrote:

> Hi,
>
>
> I am trying for the first time to connect VB6 and oracle express 10g (and
> I am brand new to oracle)
>
>
> 1 ) I installed, Oracle and the various universall installer
> 2 ) I created a user with all privileges and a table "CUSTOMERS"
> 3 ) I configured a service then an odbc driver
> 4) I tested the connection from the Microsoft ODBC manager: OK
> 5) in VB6 - I created a data environment/connection using "SERVICE" and my
> new user name: OK
>
> 6) in VB6 - I created a command under the connection and chose "TABLE" as
> type
>
>
> problem #1 - A long list of table appears, but not my "CUSTOMERS" table
> problem #2 - The tables I see in that list do not match with the tables I
> see from the Oracle admin program object browser (ex: HR.EMPLOYEES)
>
>
> It's almost as if I'm looking at a different database server.
>
> Any help greatly appreciated.
>
> Philippe
Received on Thu Mar 23 2006 - 15:35:28 CST