The error is System. OracleClient requires Oracle client software version 8. We've tried, making a console app that opens the connection, connection runs fine, opens, displays a message and all is well there. Then we make a simple web form, put it in the directory of the program, just a button, opens the connection, try.. The console app was running under an Administrator, web site running under iwam.
Is it possible that iwam has a different path? NET using Authenticated User privileges. To fix the problem you have to give the Authenticated Users group privilege to the Oracle Home directory.
Copying in the file from the Oracle home directory solved this problem for me. Update 1: It is possible for different users to have different path. But its not the likely problem here.
There is more chance that the user that the iwam user doesn't have permission to the oracle client directory. Update 0: Its suppose to work. Check for environment variable That are needed to find the oracle client and tnsnames. Also, consider using the Oracle Data Provider for.
NET search for odp. Oracle Client version 11 cannot connect to 8i databases. You will need a client in version 10 at most. When we first moved over to Vista with Oracle 10g, we experienced this issue when we installed the Oracle client on our Vista boxes, even when we were running with admin privileges during install.
I do believe that this was after 11g was released, so it is possible that there is a 'Vista compatible' version for 11g also. Why not use this: dotConnect for Oracle formerly known as OraDirect. Posted 7-Mar am Maciej Los. Thanks for your suggestion. Could you please clarify,data provider should I install in my machine or Oracle dev box or sql server dev box?
Maciej Los 7-Mar pm. Client machine. Maciej Los Mar pm. You're very welcome. Can you accept this answer as a solution - formally, to remove your question from unanswered list? Add your solution here. OK Paste as. Treat my content as plain text, not as HTML.
Existing Members Sign in to your account. This email is in use. Do you need your password? Programs that use ODBC to connect to remote databases must have a way to identify the type of database and the computer to which they wish to connect. This is accomplished through an ODBC data source, which associates a name with some database connection information.
In the case of Oracle, the database connection information is simply the name of the Net8 Service you set up during the Oracle Client Configuration. This is document anjm in the Knowledge Base. Last modified on Skip to: content search login.
Knowledge Base Toggle local menu Menus About the team. Can anyone advise what could be the problem? Thanks in advance! Message 3 of 6. Post Reply. Helpful resources. Launching new user group features Learn how to create your own user groups today! Learn More. Check it Out! Click here to read more about the November Updates! Read More. Microsoft Collaboration Conference December 7—9, Join us, in-person, December 7—9 in Las Vegas, for the largest gathering of the Microsoft community in the world.
Register Now.
0コメント