|
I compile a C# Web Service with the following command line
csc /t:library /out:ForwardRate.dll ForwardRate.cs /r:System.Data.OracleClient.dll
Following successfull compilation, I copy the DLL to the /bin directory of IIS. When I locally open the URL for my service, I get a page correctly describing my Web Service. However when I use the invoke button to test, it generates an exception of DLL not found. Unable to locate a dll (OCI.DLL). This dll is in the path, but it is not in the /bin directory where the service dll is located. I have since tried to create some simple console programs that duplicate the service behaviour and they compile as above and run without any problem. Does it make sense that any DLL's that a service assembly needs to reference at runtime have to reside in the /bin directory of IIS? Or have I missed out on something else?
Chris Meech
We're more like a hobbiest in a Home Depot drooling at all the shiny power tools, rather than a craftsman that makes the chair to an exacting level of comfort by measuring the customer's butt. Marc Clifton
VB is like a toolbox, in the hands of a craftsman, you can end up with some amazing stuff, but without the skills to use it right you end up with Homer Simpson's attempt at building a barbeque or his attempt at a Spice rack. Michael P. Butler
|
|
|
|
|
That is really strange. I have a web service running and using the ODP.NET, and don't have any references to OCI.DLL.
OCI.DLL is Oracle Call Interface and is installed by the Oracle Client.
Is the Oracle Client installed on the machine you are using to test ??
Free your mind...
|
|
|
|
|
Guillermo Rivero wrote:
Is the Oracle Client installed on the machine you are using to test ??
Yes it is. The two ways that I have checked this are one, using the Oracle Installer to confirm that Oracle Client is installed, and two I put together a couple of test console programs that would connect and query exactly the same as the service is supposed to. These test programs compiled and ran without a problem.
Guillermo Rivero wrote:
I have a web service running and using the ODP.NET, and don't have any references to OCI.DLL
My understanding is that both the classes of Oracle Client of .NET v1.1 or classes of the Oracle Data Provider .NET (from Oracle) require a minimum of Oracle Client 8.1.7. Additionally, once Oracle Client is required, OCI.DLL will get linked in eventually. It's about as low as you get in accessing the database.
I just find it odd that the console programs work but the service does not. 
Thanks, though.
Chris Meech
We're more like a hobbiest in a Home Depot drooling at all the shiny power tools, rather than a craftsman that makes the chair to an exacting level of comfort by measuring the customer's butt. Marc Clifton
VB is like a toolbox, in the hands of a craftsman, you can end up with some amazing stuff, but without the skills to use it right you end up with Homer Simpson's attempt at building a barbeque or his attempt at a Spice rack. Michael P. Butler
|
|
|
|
|
|
Try putting oci.dll in your bin directory along with your assembly. Either inetsrv.exe or aspnet_filter.dll doesn't seem to search for files in the PATH and putting native DLLs in the bin directory has worked for us before. There might have been a different problem, though. I remember reading something about this a long time ago and now I can't remember where it is.
Also, are the "console programs" you're talking about .NET console apps that use the Oracle.NET client, or Oracle's console apps? Is oci.dll even in a directory specified by the PATH environment variable?
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Heath Stewart wrote:
Try putting oci.dll in your bin directory
That's first on my Monday morning TODO list. 
Heath Stewart wrote:
Either inetsrv.exe or aspnet_filter.dll doesn't seem to search for files in the PATH and putting native DLLs in the bin directory has worked for us before.
If this is true, it seems like a pretty big oversight on DLL loading. And would explain the difference that I'm experiencing.
Heath Stewart wrote:
Also, are the "console programs" you're talking about .NET console apps that use the Oracle.NET client, or Oracle's console apps?
These console programs are .NET console apps. I'm using the classes for Oracle that ship as part of the .NET Framework SDK version 1.1
Heath Stewart wrote:
Is oci.dll even in a directory specified by the PATH environment variable?
Yes it is.
I'll be back on Monday to tackle this issue. Thanks for help, Heath and I'll post again to let you know how it turns out.
Chris Meech
We're more like a hobbiest in a Home Depot drooling at all the shiny power tools, rather than a craftsman that makes the chair to an exacting level of comfort by measuring the customer's butt. Marc Clifton
VB is like a toolbox, in the hands of a craftsman, you can end up with some amazing stuff, but without the skills to use it right you end up with Homer Simpson's attempt at building a barbeque or his attempt at a Spice rack. Michael P. Butler
|
|
|
|
|
yes, oci.dll is in a directory in the PATH enviroment variable. And I have the Oracle.NET assembly in the GAC. May be that's why it works for me.
Free your mind...
|
|
|
|
|
I tested out copying the OCI.DLL file to the /bin directory with my service assembly, but I still get the same error. For what it's worth, here is the output
System.DllNotFoundException: Unable to load DLL (oci.dll).
at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction)
at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction)
at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
at ForwardRate..ctor()
ForwardRate is my service class and in it's ctor it attempts to connect to an Oracle database.
I'm wondering if I shouldn't try using the GAC utilities to add the System.Data.OracleClient.dll to the GAC? I not sure about doing so, cause I wonder if Microsoft didn't do so for some technical reason as opposed to some political reason.
Chris Meech
We're more like a hobbiest in a Home Depot drooling at all the shiny power tools, rather than a craftsman that makes the chair to an exacting level of comfort by measuring the customer's butt. Marc Clifton
VB is like a toolbox, in the hands of a craftsman, you can end up with some amazing stuff, but without the skills to use it right you end up with Homer Simpson's attempt at building a barbeque or his attempt at a Spice rack. Michael P. Butler
|
|
|
|
|
Someone else mentioned that they did when they had a similar problem and it worked fine. You'll be able to control versioning better anyway. In any case, System.Data.OracleClient is already in my GAC and I didn't put it there, which makes me wonder if something went wrong during the installation of .NET 1.1.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
When your application, e.g. a Web Service, is running inside aspnet_wp.exe, it's running as other user (the user you configured ASP.NET for, with a default of a local account named ASPNET).
The PATH environment variable is defined for each user at application start, so you'll need to either change the PATH environment variable for the ASP.NET user or change the ASP.NET user (search for processModel on MSDN) for one that has the PATH correctly configured. Don't forget to restart IIS or kill the aspnet_wp.exe process or the environment variable won't be loaded again.
As an alternative (that most system administrators hate), you can go to your system properties and change the PATH environment variable for the whole system and do a system restart (I'm not sure if a restart is needed, it may not be).
Trying to make bits uncopyable is like trying to make water not wet.
-- Bruce Schneier
By the way, dog_spawn isn't a nickname - it is my name with an underscore instead of a space. -- dog_spawn
|
|
|
|
|
The Oracle directories have been added to the system path, so that shouldn't be an issue. As well the console programs run fine. I've done some more testing this morning and even weirder is that putting the OCI.DLL file in the /bin directory with my assembly does not fix the problem at all.
I'm beginning to suspect that this is a managed code mixed with unmanaged code issue, but I'm going to test some more. I may also try to use the GACUTIL to add the System.Data.OracleClient.dll assembly to the GAC.
Thanks for the help.
Chris Meech
We're more like a hobbiest in a Home Depot drooling at all the shiny power tools, rather than a craftsman that makes the chair to an exacting level of comfort by measuring the customer's butt. Marc Clifton
VB is like a toolbox, in the hands of a craftsman, you can end up with some amazing stuff, but without the skills to use it right you end up with Homer Simpson's attempt at building a barbeque or his attempt at a Spice rack. Michael P. Butler
|
|
|
|
|
Chris Meech wrote:
As well the console programs run fine.
Yes, because they run as a different user. Are you trying to run them as the same user than the aspnet_wp.exe?
Can you make a simple function on your Web Service that returns System.Environment.GetEnvironmentVariables ?
Trying to make bits uncopyable is like trying to make water not wet.
-- Bruce Schneier
By the way, dog_spawn isn't a nickname - it is my name with an underscore instead of a space. -- dog_spawn
|
|
|
|
|
Daniel Turini wrote:
Yes, because they run as a different user. Are you trying to run them as the same user than the aspnet_wp.exe?
Good point. But since the system environment has the PATH establish corectly, I'm sure that is how they are being found. The IIS installation is completely default, so how would I determine what user account the processes run under and bettery yet what would I use in order to change that? Thanks.
Daniel Turini wrote:
Can you make a simple function on your Web Service that returns System.Environment.GetEnvironmentVariables
That sounds like a good test. I'll try that out shourtly. Thanks.
Chris Meech
We're more like a hobbiest in a Home Depot drooling at all the shiny power tools, rather than a craftsman that makes the chair to an exacting level of comfort by measuring the customer's butt. Marc Clifton
VB is like a toolbox, in the hands of a craftsman, you can end up with some amazing stuff, but without the skills to use it right you end up with Homer Simpson's attempt at building a barbeque or his attempt at a Spice rack. Michael P. Butler
|
|
|
|
|
Chris Meech wrote:
The IIS installation is completely default, so how would I determine what user account the processes run under and bettery yet what would I use in order to change that? Thanks.
Invoke the task manager (Ctrl-Shift-Esc), View/Select Columns/User Name.
Now, see on the process list what is the user for the aspnet_wp.exe process. On default installations, this is the ASPNET user.
Trying to make bits uncopyable is like trying to make water not wet.
-- Bruce Schneier
By the way, dog_spawn isn't a nickname - it is my name with an underscore instead of a space. -- dog_spawn
|
|
|
|
|
Daniel Turini wrote:
Invoke the task manager (Ctrl-Shift-Esc), View/Select Columns/User Name.
The closest column name is User Objects, which displays a numerical number. The aspnet_wp.exe process is running under the user object of '0'.
I tried your idea about a service to return the PATH environment variable and the string contains the full system path which includes the Oracle directories such as bin.
This is one mother of a confusing problem. 
Chris Meech
We're more like a hobbiest in a Home Depot drooling at all the shiny power tools, rather than a craftsman that makes the chair to an exacting level of comfort by measuring the customer's butt. Marc Clifton
VB is like a toolbox, in the hands of a craftsman, you can end up with some amazing stuff, but without the skills to use it right you end up with Homer Simpson's attempt at building a barbeque or his attempt at a Spice rack. Michael P. Butler
|
|
|
|
|
Chris Meech wrote:
The closest column name is User Objects, which displays a numerical number. The aspnet_wp.exe process is running under the user object of '0'.
Damn! I'm running Windows XP and you're probably on Win2k. It seems Win2k doesn't have this column. Ok, you can change the user that runs the aspnet_wp.exe to any other you may like on C:\WINNT\Microsoft.NET\Framework\v1.1.4322\CONFIG\machine.config
Search for a tag <processModel.
There, change the userName and password attributes to the user you're using to run the console applications. Don't forget to restart IIS, this is important.
If you're with a default installation, you should have the special value "Machine" as the user name.
If this doesn't work, I quit. I have no more ideas. Format the **** machine and restart from scratch 
Trying to make bits uncopyable is like trying to make water not wet.
-- Bruce Schneier
By the way, dog_spawn isn't a nickname - it is my name with an underscore instead of a space. -- dog_spawn
|
|
|
|
|
I modified the machine.config file and restarted IIS. Stil have the same issue, though. 
I'm going to remove .NET and IIS and then re-install both but I will install IIS first before I install .NET which is opposite to how they were originally installed.
Thanks for all your help Daniel. I appreciate it very much.
Chris Meech
We're more like a hobbiest in a Home Depot drooling at all the shiny power tools, rather than a craftsman that makes the chair to an exacting level of comfort by measuring the customer's butt. Marc Clifton
VB is like a toolbox, in the hands of a craftsman, you can end up with some amazing stuff, but without the skills to use it right you end up with Homer Simpson's attempt at building a barbeque or his attempt at a Spice rack. Michael P. Butler
|
|
|
|
|
If you find something that works, let me know: it's always interesting to learn something. If you're facing this problem, I may have it in the future, too.
A guy who works a lot with Oracle here suggested that you may have more than one Oracle client installed on your machine, but I doubt it could cause this kind of problem. If it's the case, he said that the only way around is uninstall all the clients and install only the newer one. As I said, I doubt this is the case...
Trying to make bits uncopyable is like trying to make water not wet.
-- Bruce Schneier
By the way, dog_spawn isn't a nickname - it is my name with an underscore instead of a space. -- dog_spawn
|
|
|
|
|
Well, I uninstalled .NET and IIS, then rebooted and installed IIS and .NET (but only the runtime) and the problem is still there. I'm going to try IIS on another server, so that Oracle and IIS are not running together. But I'm getting very suspicious that the error message is incorrect and not the 'real' reason for the problem. At least if it changed to something else I'd have a clue of what the problem might, but right it's just like blind dart throwing.
Chris Meech
We're more like a hobbiest in a Home Depot drooling at all the shiny power tools, rather than a craftsman that makes the chair to an exacting level of comfort by measuring the customer's butt. Marc Clifton
VB is like a toolbox, in the hands of a craftsman, you can end up with some amazing stuff, but without the skills to use it right you end up with Homer Simpson's attempt at building a barbeque or his attempt at a Spice rack. Michael P. Butler
|
|
|
|
|
I need the new Windows XP icons for common toolbar operations such as New, Open, Print, Save etc. Are they available somewhere?
|
|
|
|
|
These are actually not icons but a Bitmap image strip in the Bitmap resource type section of several different executables. If you want the ones that you typically see in Windows XP, open the library %windir%\system32\browseui.dll, expand the Bitmap section, and view the various Bitmaps which you can right-click and extract. For the high-res 8 bit, 20x20 pixel buttons, see resource #266, for example.
You can either chop these up into squares using the Office Photo Editor or MS Paint or any other basic graphic package, set the ImageList.TranspartColor property to the color mask (with the bitmaps mentioned above, it's Magenta) and use these at design-time, or read the whole strip into an ImageList using ImageList.Images.AddStrip and embed the bitmap resource in your assembly (in the VS.NET project, select the Bitmap and change the "Build Action" in the property grid to "Embedded Resource"). See Assembly.GetManifestResourceStream for infomration about how to read that embedded resource. One of the Image constructor overloads can do that easily as well.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
|
Sorry, 8-bit / 256-color. Fixed in the previous post.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
126 bit... do you meant 8?
/\ |_ E X E GG
|
|
|
|
|
1) I changed it before you could've seen it, and 2) where you did you get 126-bit? It used t say "256 bit" by mistake, when it should've said 8-bit. Yes, I do very much know the difference but people make mistakes, especially when they're tired.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
