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

From: Philippe Martin <pmartin_at_snakecard.com>
Date: Thu, 23 Mar 2006 16:14:29 -0600
Message-ID: <95FUf.2439$fS6.1267@dukeread11>

PS: I'm about to purchase visual studio 2005 but did notice that VB .NET express did not offer any oracle option in the connection dialog.

Philippe

Philippe Martin wrote:

> H,
> 
> I am now to the point where I can see the information but not modify it.
> 
> 1) Is that because the client is too old ?
> 2) Do you suggest I use VB .NET instead ?
> 
> Philippe
> 
> 
> 
> Sybrand Bakker wrote:
> 
>> 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

Received on Thu Mar 23 2006 - 16:14:29 CST