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 error
The 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