Solved

Install ADO Application on Client Machine

Posted on 2001-07-02
8
163 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
 

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
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…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

932 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now