Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Install ADO Application on Client Machine

Posted on 2001-07-02
8
165 Views
Last Modified: 2013-11-23
Hi all,

After I developed the application, I use ADO to access Oracle database.

I want to install my application to the client computer, which already have Oracle client on it. The client computer is Windows 98. I already install MDAC 2.6 on it.

When I run the application, after enter the user/password the error shows "Provider cannot be found. It may not be properly installed".

Where do I have to config??

Thank you
mrbird
0
Comment
Question by:mrbird
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6247524
guessing you must configure it with the odbc-administrator
0
 
LVL 3

Expert Comment

by:Stefaan
ID: 6247526
Hi,

Have you checked that the OLE-DB provider for Oracle is available on the client machine ?

Best regards,


Stefaan
0
 
LVL 22

Expert Comment

by:Mohammed Nasman
ID: 6247528
Hello

  Did u configured oracle client with net8 configuration, try to test it with sql plus to connect to the server if u have have problems with sql plus also, that mean u have problem in oracle client


Mohammed
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:mrbird
ID: 6247550
Hi,
mnasman:
I already configured the Net8, and I can use sqlplus on the client.

Stefaan:
How to check OLE-DB provider for Oracle in the client machine.

On my development machine, I didn't configure the ODBC and it works. I think the ODBC is not related. Am I correct?

Thank you for all comments
mrbird
0
 
LVL 22

Expert Comment

by:Mohammed Nasman
ID: 6247598
you are right, you don't need the ODBC, but from your error messages, I think the oracle driver not working good, try to reinstall the MDAC

Mohammed
0
 
LVL 3

Accepted Solution

by:
Stefaan earned 40 total points
ID: 6247613
Hi,

Somewhere on your harddisk create a new file and give it a name and .UDL as extension.  Now in your explorer double click on that file.  This will open the Data Link properties screen.  In the provider tab select your OLE-DB provider for oracle and configure the rest to connect to your DB.  Try to test the connection, and if it works ADO is installed correctly and you have a connection to your DB.

If it doesn't work, then you will have to check some things out, like can the client access the server, ...

Best regards,


Stefaan
0
 

Author Comment

by:mrbird
ID: 6251008
Thank you very much, finally I can figure out what is wrong in my configure by following your suggestion. And it works fine now :)
mrbird

ps. All, Thanks for all your comments
0
 

Author Comment

by:mrbird
ID: 6251480
Thank you very much, finally I can figure out what is wrong in my configure by following your suggestion. And it works fine now :)
mrbird

ps. All, Thanks for all your comments
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question