Re: Connecting to Oracle From VB6

From: Glynn (wwgze_at_woolworths.co.za)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 14:34:24 +0200

Is this the provider that rewuires you to know how big your Return Data is
going to be before you issue your query?

We will be accessing Stored Procedures with this connectivity?

Many thanks,

Glynn

<mboizeau@free.fr> wrote in message
news:1106222072.231786.90520@c13g2000cwb.googlegroups.com...
> You need
> - Oracle connectivity. ie basic oracle client installed on your server
> - TNS entry to you database
> - A connection layer. here you may have the choice between ODBC and
> OLEDB.
> for ODBC : in adminsitration tools choss "ODBC" and add a new DSN
> choose an oracle provider, you will then be prompted for loging info
> - In your vb6 code implement ADO objects (the ADODB.connection object
> and recordset object have a look to MS doc for this:
> http://msdn.microsoft.com) In you code you should provide a connection
> string this connection string looks like :
> "Provider=\"OraOLEDB.Oracle.1\";User
> ID=MY_LOGIN;PASSWORD=My_Password;Data Source=My_database;Extended
> Properties=;Persist Security Info=False"
> if you choose OLEDB and the oracle OLEDB Provider " OraOLEDB "(it
> coms with the client installation
> You may choose the Microsoft Oledb for Oracle driver "MSDAORA"
> If you choose ODBC you connection string should look like
> "ODBC;DSN=RDF_DEV;UID=RDF_USER;PWD=USERDEV;DBQ=RDF_DEV.World;"
>
> details here (the source code is for .net C# but configuration info
> are identical) :
> http://oraclevsmicrosoft.blogspot.com/2004/12/connect-net-application-to-oracle.html
>
>
> hope this helps
>
> Marc Boizeau
> Oraclevsmicrosoft
>
> http://Oraclevsmicrosoft.blogspot.com
>
> Glynn wrote:
>> Hi All,
>>
>> I'm looking to try to connect to an Oracle database running on Unix
> from a
>> VB6 COM+ client running on Windows 2000.
>>
>> Here is the Version Info.
>>
>> Unix : AIX 5.2 64 bit
>> Oracle : 9.2.0.6
>>
>> One constraint is that I cannot install a Java Virtual Machine on my
>> servers.
>>
>> Thanks in advance.
>>
>> Regards,
>>
>> Glynn
>

Relevant Pages