Member Avatar for tukai

Hello guys,
I have Oracle9i installed in my homepc and my O.S. is Windowsxp-professional. Now,I want to connect Vb using Microsoft OLE DB Provier for oracle. For this i have done the following steps---
1. Created a text document and renamed it with extension .udl
2. On openning the file i got a provider window from where i selected Microsoft OLE DB Provier for oracle and clicked next
3.In the connection window i gave username & password of my oracle database (ofcourse i didn't give host string, being a homepc i'm not connected to any lan)

But after doin this when i'm testing the connection with test connection button it gives error message--
conection failed.error message cannot be rerieved from oracle

I'm not getting what is the problem . please help me out....

  • 2 Contributors
  • 3 Replies
  • 103 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by jim mcnamara
Member Avatar for jim mcnamara

Can you connect using sqlplus?

Member Avatar for tukai

yes sqlplus is working properly.....

Member Avatar for jim mcnamara

That's good.
Do you have a valid tnsnames.ora and sqlnet.ora file? ie., please post them here.
They are in your Oracle home directory (like ORA92)

If you version of 9i is old they will be in (oraclehome)\NET80\ADMIN
Otherwise they will be in (oraclehome\NETWORK/ADMIN

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.