Create Assembly error in Sequil
Create Assembly error in Sequil
Create Assembly error in Sequil
Create Assembly error in Sequil
Create Assembly error in Sequil
Create Assembly error in Sequil Create Assembly error in Sequil Create Assembly error in Sequil Create Assembly error in Sequil Create Assembly error in Sequil Create Assembly error in Sequil Create Assembly error in Sequil Create Assembly error in Sequil
Create Assembly error in Sequil Create Assembly error in Sequil
Create Assembly error in Sequil
Go Back  Xtreme Visual Basic Talk > > > Create Assembly error in Sequil


Reply
 
Thread Tools Display Modes
  #1  
Old 09-30-2008, 05:39 AM
rich5 rich5 is offline
Freshman
 
Join Date: Sep 2005
Posts: 49
Default Create Assembly error in Sequil


Hey guys

I'm trying to call a dll from with a stored proc n Sequil Server. First I need to create the assembly in Sequil.

I've run the following code:

CREATE ASSEMBLY DeltaUtilitiesDLL
FROM 'C:\Utilities.dll'

I get the following errorfrom sequil:

Msg 10301, Level 16, State 1, Line 1
Assembly 'Delta.Utilities' references assembly 'polar.zip, version=1.0.3.0, culture=neutral, publickeytoken=42b2951b2a5d8a4e.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(error not found)). Please load the referenced assembly into the current database and retry your request.


Any ideas..??

Peace and love
Reply With Quote
  #2  
Old 09-30-2008, 07:23 AM
wayneph's Avatar
waynephCreate Assembly error in Sequil wayneph is offline
Web Junkie

Retired Moderator
* Expert *
 
Join Date: Apr 2004
Location: D/FW, Texas, USA
Posts: 8,393
Default

It's telling you that you have functionality in your assembly that isn't avaialble on the SQL (not Sequil) Server. If you're not using anything from the assembly, then I'd modify the references so that it's not included.

However, if you do need to use it, I believe you can register it in the Global Assembly Cache on your SQL machine, and when you create the assembly it will find the reference.

The way the message reads, it sounds like it wants you to create an assembly from the polar.zip class in your database first, but I think the GAC would be a cleaner option if if works.
__________________
-- wayne, MSSM Retired
> SELECT * FROM users WHERE clue > 0
0 rows returned
Reply With Quote
  #3  
Old 09-30-2008, 08:29 AM
rich5 rich5 is offline
Freshman
 
Join Date: Sep 2005
Posts: 49
Default

Thanks wayne. The polar.zip is part of other functions within the DLL and is not needed for what I am doing, so I created a serparte DLL with just the functions I need and the assembly has been created.

The function within the DLL accepts a string and returns a string. The next problem I have is I need to call the function from Sequil and have it return the string.

I am new to calling DLLs from sequil, could you give me an example of how to do this..??
Reply With Quote
  #4  
Old 09-30-2008, 08:53 AM
rich5 rich5 is offline
Freshman
 
Join Date: Sep 2005
Posts: 49
Default

Right this is what I have so far. It's to create in Sequil one of the functions in the DLL, which doesn't require anything to be sent to it and returns a string

CREATE FUNCTION GetApprovedList()
RETURNS VARCHAR(4000)
AS EXTERNAL NAME [DeltaStringDLL].[Strings].[GetApprovedList]

DeltaStringDLL is the name of the DLL (or assembly)
Strings is the name of the class which the functions are found in
GetApprovedList is the name of the function in the DLL

The error I get when executing this code is:
Msg 6505, Level 16, State 1, Procedure GetApprovedList, Line 1
Could not find Type 'Strings' in assembly 'Delta.String'.


However I don't see why it doesn't recognise the class...???
Reply With Quote
  #5  
Old 10-01-2008, 06:57 AM
wayneph's Avatar
waynephCreate Assembly error in Sequil wayneph is offline
Web Junkie

Retired Moderator
* Expert *
 
Join Date: Apr 2004
Location: D/FW, Texas, USA
Posts: 8,393
Default

Most likely there is a Namspace compiled into your Assembly. You have to give the fully qualified Class name, not just the name of the Class itself.

And it's not call Sequil.
__________________
-- wayne, MSSM Retired
> SELECT * FROM users WHERE clue > 0
0 rows returned
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Create Assembly error in Sequil
Create Assembly error in Sequil
Create Assembly error in Sequil Create Assembly error in Sequil
Create Assembly error in Sequil
Create Assembly error in Sequil
Create Assembly error in Sequil Create Assembly error in Sequil Create Assembly error in Sequil Create Assembly error in Sequil Create Assembly error in Sequil Create Assembly error in Sequil Create Assembly error in Sequil
Create Assembly error in Sequil
Create Assembly error in Sequil
 
Create Assembly error in Sequil
Create Assembly error in Sequil
 
-->