Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Greg_01
Starting Member
4 Posts |
 Posted - 2009-09-24 : 11:22:44
|
| Hi Guys, I have a problem connecting to an oracle database from a SQL CLR. This only happens on one of my dev boxes. I tried on two others and it worked fine. Before I rebuild the system I would like to exhaust all possibilities. Here is what I have done; 1. SQLPlus I can use to connect to the Oracle database and retrieve data 2. I wrote a small program in vb.net to connect to Oracle and retrieve some random data. That worked. Ran it from Visual Studios. 3. I have given admin permissions on all folders. 4. The error that I get OCIEnvCreate failed with return code -1 but error message text was not available.5. I have tried installing and uninstalling the Oracle Client. 6. Talked to our Oracle guys, they told me that the Client is installed correctly. Which makes sense since I can connect every other way other then through SQL. There have been really old version of the oracle client installed before on the machine, and so the only thing I can think of is that when SQL executes the CLR and it tries to run the Oracle client it’s pointing to some old installation. I would really appreciate any ideas.Thank you |
|
|
Greg_01
Starting Member
4 Posts |
Posted - 2009-09-24 : 15:05:24
|
| I did a little bit more digging and now I get the following errorThe action that failed was:Demand The type of the first permission that failed was: System.Data.OracleClient.OraclePermission The Zone of the assembly that failed was:MyComputer |
 |
|
|
danielmorrow83
Starting Member
1 Post |
Posted - 2010-04-26 : 14:45:51
|
| Hi, did you figure out the problem? I'm getting this error as well.cheers |
|
|
|
|
|
|
SQL CLR and Oracle Client