This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Installing Assembly in SQL
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Dec 21, 2012
09:57 AM
Installing Assembly in SQL
I am creating a BasicMSI that installs scripts to a database. One of them creates an assembly in the database based off a DLL that is installed with the product.
When the script runs it errors out with:
Assembly 'MyAssembly' was not found in the SQL catalog of database 'MyDB'.
Originally I was using a text replacement which replaced a placeholder of the path/filename with the [INSTALLDIR]\MyAssembly.dll and then started making it less automated by hardcoding it in. The assembly is in the folder and yet it still errors out the same way.
Is this a limitation on the SQL scripting with InstallShield? Or am I missing the correct way of doing it?:confused:
When the script runs it errors out with:
Assembly 'MyAssembly' was not found in the SQL catalog of database 'MyDB'.
Originally I was using a text replacement which replaced a placeholder of the path/filename with the [INSTALLDIR]\MyAssembly.dll and then started making it less automated by hardcoding it in. The assembly is in the folder and yet it still errors out the same way.
Is this a limitation on the SQL scripting with InstallShield? Or am I missing the correct way of doing it?:confused:
(6) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Dec 21, 2012
10:01 AM
This is the script portion:
USE MyDB
CREATE ASSEMBLY MyAssemblyFunctions
FROM 'c:\Program Files (x86)\CompanyName\ProductName\Database\MyAssembly.dll'
WITH PERMISSION_SET = SAFE;
USE MyDB
CREATE ASSEMBLY MyAssemblyFunctions
FROM 'c:\Program Files (x86)\CompanyName\ProductName\Database\MyAssembly.dll'
WITH PERMISSION_SET = SAFE;
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Dec 28, 2012
05:20 PM
If you run the same script from Microsoft SQL Server Management Studio, does it work?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Dec 28, 2012
05:49 PM
hidenori wrote:
If you run the same script from Microsoft SQL Server Management Studio, does it work?
Yes..........
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Dec 29, 2012
12:37 PM
Can you post a log?
The SQL custom actions should scheduled after file installation by default. Perhaps you've played with it and have race condition.
Are you using the same credentials via InstallShield and Management Studio?
The SQL custom actions should scheduled after file installation by default. Perhaps you've played with it and have race condition.
Are you using the same credentials via InstallShield and Management Studio?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Dec 31, 2012
11:43 AM
Christopher Painter wrote:
Can you post a log?
The SQL custom actions should scheduled after file installation by default. Perhaps you've played with it and have race condition.
Are you using the same credentials via InstallShield and Management Studio?
I am trying but some encapsula is telling me I am being denied access to post anything aside from text.
Here is an excerpt from the log with the error
ADO Error: Number: -2147217900 Description: Assembly 'MyAssembly' was not found in the SQL catalog of database 'MyDB'. Source: Microsoft OLE DB Provider for SQL Server SQL State: 42000 Native Error: 6528
1: There was a SQL scripting error at line 17. Aborting the setup.
Yes, same credentials.
some stupid encapsula website protection error pops up when I attempt to paste in the code blocks with the SQL code being ran.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 01, 2013
08:22 AM
Are you able to snapshot and rollback your entire environment to rule out external influences? If the test in IS and mangement studio the same database instance?
If you want, send a sample DLL and SQL snippet to chrpai@iswix.com and I'll play with it.
If you want, send a sample DLL and SQL snippet to chrpai@iswix.com and I'll play with it.
![](/skins/images/D60DF682EA37BF37032955CE10F3F0BB/responsive_peak/images/icon_anonymous_message.png)