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
mrbirdAsked:
Who is Participating?
 
StefaanConnect With a Mentor Commented:
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
 
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
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
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
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.