StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Business Objects and Data Access (How do I?)
»
DataBase Deployment Toolkit Error
DataBase Deployment Toolkit Error
Post Reply
Like
2
1
2
Next
Jump To Page
DataBase Deployment Toolkit Error
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Buffie
Buffie
posted 7 Years Ago
ANSWER
HOT
Topic Details
Share Topic
Group: StrataFrame Users
Posts: 119,
Visits: 11K
I have not used this in a while but I need to change a table structure and I went to DataBase Deployment ToolKit and found the Database I needed to edit this morning and I get the following error.
TypeInitializationException
The type initializer for 'MicroFour.StrataFrame.Business.DBEAssembliesBO' threw an exception.
FileNotFoundException
Could not load file or assembly 'Microsoft.SqlServer.SqlEnum, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
FileNotFoundException
Could not load file or assembly 'Microsoft.SqlServer.SqlEnum, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Source : StrataFrame BO
Stack Trace:
at MicroFour.StrataFrame.Business.DBEAssembliesBO..cctor()
at MicroFour.StrataFrame.Business.DBEAssembliesBO..ctor(IContainer Container)
at MicroFour.StrataFrame.Data.ProfileEditorDialog.InitializeComponent()
at MicroFour.StrataFrame.Data.ProfileEditorDialog..ctor(Int32 ProfilePK)
at MicroFour.StrataFrame.Data.DatabaseMain.OpenDialog(Int32 ProfilePK)
at MicroFour.StrataFrame.Data.DatabaseMain.ShowProfileOpenDialog()
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.TimerNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
It says it could not load "
Microsoft.SqlServer.SqlEnum". I am not sure what to try? I know it exists on my machine as the image shows.
Any help would be appreciated. Win 10 Pro - Visual Studio 17
Attachments
SqlServerSqlEnum.PNG
(
323 views,
43.00 KB
)
Reply
Like
2
Edhy Rijo
E
Edhy Rijo
posted 7 Years Ago
ANSWER
Post Details
Share Post
E
Group: StrataFrame Users
Posts: 2.4K,
Visits: 23K
Hi Terry,
The DDT uses the Microsoft Shared Management Objects (SMO) and it looks like yours are not registered.
You could try to repair them via the Add/Remove program or re-download them from
https://www.microsoft.com/en-us/download/details.aspx?id=52676
and install:
ENU\x64\SharedManagementObjects.msi
ENU\x86\SharedManagementObjects.msi
I would try to repair them first, the DDT uses a very specific version of the SMO.
Edhy Rijo
Reply
Like
1
Buffie
Buffie
posted 7 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 119,
Visits: 11K
I tried to repair the SMO and I tried to repair the whole SQLExpress installation and I still get the same error. I even downloaded a complete install package from Microsoft.
Is the next choice Uninstalling and reinstalling SQLExpress?
Ben, maybe you could chime in with any ideas you might have?
TIA.
Reply
Like
2
Buffie
Buffie
posted 7 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 119,
Visits: 11K
Is there another way to find out if SMO has been installed or installed correctly?
TIA
Reply
Like
1
Buffie
Buffie
posted 7 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 119,
Visits: 11K
This pretty well has gotten me completely Stopped. I have a new Win 10 Pro machine. I have reinstalled Win 10 and got all the required .Net Versions and tried installing SqlExpress2014 and I still don't get the SMO from Microsoft installed. I have completely reinstalled Win 10 Pro and then installed Visual Studio 2017 and got all the required .Net Versions and then installed SQLExpress2014 and I don't get the SMO from Microsoft installed. Of course without SMO Strataframe Database Deployment does not work. Can not proceed with BO's and so forth.
Does anybody have a clue as to what I should do???
TIA
Reply
Like
1
Edhy Rijo
E
Edhy Rijo
posted 7 Years Ago
ANSWER
Post Details
Share Post
E
Group: StrataFrame Users
Posts: 2.4K,
Visits: 23K
Hi Terry,
Sorry I got pretty busy and forgot to post something here.
Please read the whole forum in this thread
http://forum.strataframe.net/FindPost33478.aspx
If you haven't download and install my custom SF setup for Windows 10 and look at other threads for manually registering all the SF assemblies, I am almost sure this may fix your issue.
Sorry you had to go to trouble of re-installing everything, that is a major decision.
Edhy Rijo
Reply
Like
1
Buffie
Buffie
posted 7 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 119,
Visits: 11K
No problem. I think I have used all of the correct stuff but since I have a pretty clean vanilla machine I will go through it again. Thanks for the notes.
Reply
Like
1
Edhy Rijo
E
Edhy Rijo
posted 7 Years Ago
ANSWER
Post Details
Share Post
E
Group: StrataFrame Users
Posts: 2.4K,
Visits: 23K
I believe my custom setup will install the SMO used by the DDT.
Also take a look at this post and download the SMO from there and see if that works for you.
http://forum.strataframe.net/FindPost32382.aspx
What version of SQL Server are you using?
Please let me know if it works.
Edhy Rijo
Edited
7 Years Ago by
Edhy Rijo
Reply
Like
1
Buffie
Buffie
posted 7 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 119,
Visits: 11K
SqlExpress 2014
Thanks for the other info. Will try tomorrow.
Reply
Like
2
Buffie
Buffie
posted 7 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 119,
Visits: 11K
What makes me wonder about all of this is spelled out in the images.
When I run Regedit and look under Local Machine - Software - Microsoft - Microsoft SQL Server, on my last development machine I had SMO but notice on the new machine SMO2.
What is going on with that?
Attachments
SMO.PNG
(
276 views,
10.00 KB
)
SMO2.PNG
(
276 views,
7.00 KB
)
Reply
Like
1
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Post Reply
Like
2
1
2
Next
Jump To Page
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search