>>Hello Eric,
>>
>>Sorry, I was wrong. Actullay, I want to connect Oracle as a Back-end and
>>VB as a Front-end.
>>
>>Any idea about that ? ? ?
>>
>>Amol
>
>You should have client setup disk provided by Oracle. Normally, it is on the same disk as the Server installation but you have to install only the client part.
There's also an Oracle ODBC driver included as a part of the MDAC 2.1 update, distributed with Visual Studio SP3 as MDAC_TYP.EXE (MDAC 2.1 is a mandatory install prior to applying SP3, although you do not have to select the Oracle driver for inclusion when the self-installing MDAC 2.1 file is run.)
You can download the current version of the MDAC self-installing, freely-redistributable executable from msdn.microsoft.com if you don't have it otherwise (it's on the MSDN distribution, and there's a version of MDAC on the retail Visual Studio 6.0 distribution disk set as well.)
I have been told that Oracle's ODBC and OLEDB drivers are better than Microsoft's, but not being involved with oracle on any of the development platforms I use now, I don't have an informed opinion.