Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

Install ADO Application on Client Machine

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
mrbird
Asked:
mrbird
  • 3
  • 2
  • 2
  • +1
1 Solution
 
kretzschmarCommented:
guessing you must configure it with the odbc-administrator
0
 
StefaanCommented:
Hi,

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

Best regards,


Stefaan
0
 
Mohammed NasmanSoftware DeveloperCommented:
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
mrbirdAuthor Commented:
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
 
Mohammed NasmanSoftware DeveloperCommented:
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
 
StefaanCommented:
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
 
mrbirdAuthor Commented:
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
 
mrbirdAuthor Commented:
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now