oracle(tm) client and networking components

[papakula]

Hi all!
I am working on Win 98 and personal oracle 8i , Now Im trying to connect oracle with vb and I tried to create a dsn but its giving error
oracle(tm) client and networking components not found...
From where can I install this components and what I should do . Any help would be gr8. Many thanks
Dar

 

[JulianChappell]

Hello Papakula,
I had to do an Oracle conversion for a VB 6 project and found the same thing. I had to install the Oracle OLEDB Provider, downloadable from otn.oracle.com on the windows client machines, place a file called TNSNames.ora with an appropriate entry for the DB server in the correct folder (e.g. C:\Oracle\Ora81\Network\Admin). There is a samples subdirectory with an example TNSNames.ora file. Then, for your connection string, use something like:
"Provider=OraOLEDB.Oracle;" & _
&quot;Data Source=<TNSNAMESENTRY>&quot; & _
&quot;PLSQLRSet=1;&quot; & _
&quot;User ID=<USERID>&quot; & _
&quot;Password=<PASSWORD>&quot;
where <TNSNAMESENTRY> is the top line from an entry in the TNSNames.ora file mentioned earlier, and <USERID> and <PASSWORD> are the user credentials for a user created in the Oracle DB. The PLSQLRSet=1 bit is for getting recordsets out of stored procedures (another slightly less than easy task). Good luck!

 

[papakula]

Hi Julian
Many thanks for your info.. But it would be greatful, if u be more in detail.
Many Thanks
Dar