J
James
Here's the basics of what I need to do. I have a COM DLL that I did not
write, but need to utilize. Effectively I'm trying to write a stored
procedure in SQL Server 2005 to pass parameters to a function that will call
this DLL, use some of my "managed" code, and ultimately return a row (or
several) as output. I'm completely new to this entire concept, so if this
is the wrong newsgroup...just point me in the right direction.
I've created the Class Library in VS2K5 and compiled it. It has a reference
to the DLL I need and a function that can return the correct values based on
the input parameters. This element seems ok.
I created a Database project and added a .NET Stored Procedure but was
unable to add a reference to the DLL that I created. So I'm thinking I
might need to have a web service interface between the Database Project and
the DLL I created. Is this valid or pointless?
Assuming it's valid...how do I transport the data from my DLL through the
webservice to my Database project? I seem to recall having trouble
transferring complex types through webservices (not sure if this is even
possible).
I apologize for my pure ignorance of all of this, first time diving into
this type of thing. Any help would be greatly appreciated, even if it's
just thought process. I could very well be over complicating this.
write, but need to utilize. Effectively I'm trying to write a stored
procedure in SQL Server 2005 to pass parameters to a function that will call
this DLL, use some of my "managed" code, and ultimately return a row (or
several) as output. I'm completely new to this entire concept, so if this
is the wrong newsgroup...just point me in the right direction.
I've created the Class Library in VS2K5 and compiled it. It has a reference
to the DLL I need and a function that can return the correct values based on
the input parameters. This element seems ok.
I created a Database project and added a .NET Stored Procedure but was
unable to add a reference to the DLL that I created. So I'm thinking I
might need to have a web service interface between the Database Project and
the DLL I created. Is this valid or pointless?
Assuming it's valid...how do I transport the data from my DLL through the
webservice to my Database project? I seem to recall having trouble
transferring complex types through webservices (not sure if this is even
possible).
I apologize for my pure ignorance of all of this, first time diving into
this type of thing. Any help would be greatly appreciated, even if it's
just thought process. I could very well be over complicating this.