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

On Thu, 23 Mar 2006 15:21:01 -0600, Philippe Martin <pmartin_at_snakecard.com> 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

Vb6 is way old, and your ODBC driver probably too. What is the version number of your orawin.dll?
Likely it is not going to work ever, because your client is too old.

--
Sybrand Bakker, Senior Oracle DBA