Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo. . . error

Topics: Developer Forum, User Forum
Jan 7, 2010 at 10:40 PM

I get the following error when I try to run this.  I just installed it, and have tried installing it on my computer and also on the SQL server.  I have .NET installed and up to date.  I'm not a programmer, but need to create a data dictionary for our SQL server and thought this would be an ideal tool.  I modified the DataDictionaryCreator.exe.config file with the proper information to connect to the SQL server after it failed the first time and that didn't help.  If I ignore the error, I can click the button to browse to and see the SQL server and its databases.

Error:

Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo. Version=10.0.0.0, Culture=neutral, PublicKeyToken=string' or one of its dependencies.  The system cannot find the file specified.

Here is the content of the error portion of the detail.

 

System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.SqlServer.ConnectionInfo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
   at DataDictionaryCreator.Main.DocumentationSetup(String sqlConnectionString)
   at DataDictionaryCreator.Main.MainForm_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=string' or one of its dependencies. The system cannot find the file specified.

File name: 'Microsoft.SqlServer.ConnectionInfo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=string'

   at DataDictionaryCreator.Main.DocumentationSetup(String sqlConnectionString)

   at DataDictionaryCreator.Main.MainForm_Load(Object sender, EventArgs e)

   at System.Windows.Forms.Form.OnLoad(EventArgs e)

   at System.Windows.Forms.Form.OnCreateControl()

   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)

   at System.Windows.Forms.Control.CreateControl()

   at System.Windows.Forms.Control.WmShowWindow(Message& m)

   at System.Windows.Forms.Control.WndProc(Message& m)

   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

   at System.Windows.Forms.ContainerControl.WndProc(Message& m)

   at System.Windows.Forms.Form.WmShowWindow(Message& m)

   at System.Windows.Forms.Form.WndProc(Message& m)

   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

As I said before, I'm not a developer, so I'd really appreciate any insight any of you may have.  Thanks.

 

 

Jan 14, 2010 at 5:28 PM

Hi,

 

which versions are you using?

 

- OS

- .NET Framework

- SQL Server

 

Jan 14, 2010 at 5:39 PM

Hi volley.  I have tried installing it on the SQL server and also on my desktop.

 

Server OS - Server 2003 R2 (version 5.2 R2 Build 3790.svr03_sp2_gdr.090319-1204 : Service Pack 2)

Server .NET Framework installed - 2.0 SP2, 3.0 SP2, 3.5 SP1 (all fully patched)

SQL Server - Standard Ed. version 9.00.3042.00

 

Desktop OS - XP Pro SP3 (version 5.1 Build 2600.xpsp_sp3_gdr.090804-1435 : Service Pack 3)

Desktop .NET Framework installed - 1.1, 2.0 SP2, 3.0 SP2, 3.5 SP1 (all fully patched)

SQL Server connected to - Standard Ed. version 9.00.3042.00

 

Thanks

Jan 28, 2010 at 9:31 PM

I'm having the same issue.  I just downloaded and installed it on my desktop.  I also have the same desktop versions as jpbmdb reported on Jan 14 at 12:30pm.

Any ideas?

Thanks

Feb 3, 2010 at 4:52 AM

try this :

http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en


Microsoft SQL Server System CLR Types

Microsoft SQL Server 2008 Management Objects

Feb 3, 2010 at 7:33 PM

That got me further than I had gotten before.  Installing those two did allow me to actually open the program without the problems I was having before; however, now when I get into the Data Dictionary Creator, I cannot connect to the database.  I get the message "Your database connection failed.  Please try again.  You may use the connection string builder by clicking the ellipse to the right."  I can clear the connection string, and use the builder to recreate the string, successfully test the connection within the builder, but when I click on File/Connect to Database, I can't connect.  When I click the Continue button, everything is grayed out.  This is my connection string:

Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=GCBHServices_TEST;Data Source=GCBHS4

I am running SQL Server 2005.  That may not have been clear when I stated above that I was running version 9.00.3042.00.

Ideas?

May 21, 2010 at 12:20 AM
I am using the SQL 2005 and VS.net 2005 (installed, in case it matters). Microsoft .Net Framework 2.0 Service Pack 2 Microsoft .Net Framework 3.0 Service Pack 2 Microsoft .Net Framework 3.5 SP1 I am getting this error: " ... Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified." If it does not work for SQL 2005 and Vs.net 2005, please let me know.
Jun 16, 2010 at 5:47 PM
I have WinXP SP3 and SQL 2005 Express SP3, and also MS-SQL 2000 Developer SP4. I had the same error. I Googled the error and the thread I found suggested installing the MS-SQL 2008 msi for the component. That did not help. I then uninstalled DDC, and downloaded and installed the prior version and it worked. I am not a developer for the database I am documenting, but suspect that something for MS-SQL 2005 broke when the last update with MS-SQL 2008 support was added. I have not tried installing the latest version of DDC to see if it will work now. I'm just looking for a quick and easy way to solve my issue and the prior version appears that it will do just that. Please advise when MS-SQL 2005 will work again. Our apps are not yet supported on MS-SQL 2008, but getting the data model is independent of the version of MS-SQL.
Jun 25, 2010 at 11:05 PM

I'm having the same issue.

Jul 19, 2010 at 2:10 AM

The latest version "1.3.4" should now fix this issue. Assembly dependencies weren't included in the previous releases. Also, now using ClickOnce as deployment engine.

 

Jul 19, 2010 at 3:54 PM
Thanks for the update. This did fix the problem for me. It runs on XP Pro, but I could not get the installation to run on Windows 7.
Jul 19, 2010 at 6:39 PM
I uninstalled as per the instructions, then tried the "oneclick" installer. I get a message: "Unable to install or run this application. This application requires your system to be updated to Microsoft Common Language Runtime Version 4.0.30319.0. Please contact your system administrator," So what am I missing? I believe it is something with .Net. This is Win XP SP3 fully patched with all updates for .Net 1, 2, & 3.
Jul 19, 2010 at 9:42 PM

Install .net 4.0 and your all set... for some reason the ClickOnce installer doesn't auto install .net 4.0 even if I set it as a prerequisite.

Jul 19, 2010 at 9:48 PM
jpbmdb wrote:
Thanks for the update. This did fix the problem for me. It runs on XP Pro, but I could not get the installation to run on Windows 7.

Do you get any error on Windows 7? I'll try and get some testing done with Windows 7.

 

Jul 22, 2010 at 12:37 AM

Windows 7 with .NET 4.0 installed.

Installed and Working fine.

Sep 10, 2010 at 6:46 PM

I am running windows server 2008 and cannot connect.   I get this error

Could not load file or assemby 'interop.msdasc, version=1.0.0.0 culture = neutral.

Here is what is in the details.

See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************System.BadImageFormatException: Could not load file or assembly 'Interop.MSDASC, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An attempt was made to load a program with an incorrect format.File name: 'Interop.MSDASC, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'   at DataDictionaryCreator.Main.PromptForConnectionString(String currentConnectionString)   at DataDictionaryCreator.Main.SetConnectionString()   at DataDictionaryCreator.Main.btnSetConnectionString_Click(Object sender, EventArgs e)   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)   at System.Windows.Forms.Control.WndProc(Message& m)   at System.Windows.Forms.ButtonBase.WndProc(Message& m)   at System.Windows.Forms.Button.WndProc(Message& m)   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
WRN: Assembly binding logging is turned OFF.To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.Note: There is some performance penalty associated with assembly bind failure logging.To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].


************** Loaded Assemblies **************mscorlib    Assembly Version: 4.0.0.0    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll----------------------------------------System    Assembly Version: 4.0.0.0    Win32 Version: 4.0.30319.1 built by: RTMRel    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll----------------------------------------DataDictionaryCreator    Assembly Version: 1.2.0.0    Win32 Version: 1.2.0.0    CodeBase: file:///C:/Users/Administrator/AppData/Local/Apps/2.0/QXMPZP7M.M20/7T8CW97Q.3P4/data..tion_a163f1f54368f8dc_0001.0003_b6a32ed07225a7ff/DataDictionaryCreator.exe----------------------------------------System.Windows.Forms    Assembly Version: 4.0.0.0    Win32 Version: 4.0.30319.1 built by: RTMRel    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll----------------------------------------System.Drawing    Assembly Version: 4.0.0.0    Win32 Version: 4.0.30319.1 built by: RTMRel    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll----------------------------------------System.Configuration    Assembly Version: 4.0.0.0    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll----------------------------------------System.Xml    Assembly Version: 4.0.0.0    Win32 Version: 4.0.30319.1 built by: RTMRel    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll----------------------------------------Accessibility    Assembly Version: 4.0.0.0    Win32 Version: 4.0.30319.1 built by: RTMRel    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll----------------------------------------System.Deployment    Assembly Version: 4.0.0.0    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Deployment/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll----------------------------------------Microsoft.SqlServer.Smo    Assembly Version: 10.0.0.0    Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1045 )    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll----------------------------------------Microsoft.SqlServer.Management.Sdk.Sfc    Assembly Version: 10.0.0.0    Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1045 )    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Management.Sdk.Sfc/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.Sdk.Sfc.dll----------------------------------------Microsoft.SqlServer.ConnectionInfo    Assembly Version: 10.0.0.0    Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1045 )    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll----------------------------------------Microsoft.SqlServer.SqlEnum    Assembly Version: 10.0.0.0    Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1045 )    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SqlEnum/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlEnum.dll----------------------------------------Microsoft.SqlServer.Dmf    Assembly Version: 10.0.0.0    Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1045 )    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Dmf/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Dmf.dll----------------------------------------System.Data    Assembly Version: 4.0.0.0    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll----------------------------------------System.Core    Assembly Version: 4.0.0.0    Win32 Version: 4.0.30319.1 built by: RTMRel    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll----------------------------------------bopeutxe    Assembly Version: 1.2.0.0    Win32 Version: 4.0.30319.1 built by: RTMRel    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll----------------------------------------
************** JIT Debugging **************To enable just-in-time (JIT) debugging, the .config file for thisapplication or computer (machine.config) must have thejitDebugging value set in the system.windows.forms section.The application must also be compiled with debuggingenabled.
For example:
<configuration>    <system.windows.forms jitDebugging="true" /></configuration>
When JIT debugging is enabled, any unhandled exceptionwill be sent to the JIT debugger registered on the computerrather than be handled by this dialog box.

 

Jun 2, 2011 at 6:25 PM

Hi,

 

I get a similar error.  Database connection failed, at the outset.  When I click on the ellipsis, a popup error displays an unhandled exception. 

 

Per the instructions above, I installed

 

Microsoft SQL Server System CLR Types

Microsoft SQL Server 2008 Management Objects


, and re-installed .NET 4.x.

System.BadImageFormatException: Could not load file or assembly 'Interop.MSDASC, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An attempt was made to load a program with an incorrect format.
File name: 'Interop.MSDASC, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'
   at DataDictionaryCreator.Main.PromptForConnectionString(String currentConnectionString)
   at DataDictionaryCreator.Main.SetConnectionString()
   at DataDictionaryCreator.Main.btnSetConnectionString_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, In

...

...

...

 

 

If anybody has tried EZ Data Dictionary, please let me know.  There seems to be no way to order it without sending an email or sending a check or ordering on the phone.  Also, there are two different prices listed:

 

At http://www.datadictionary.com/order.asp, the single user price is $99.00.  At 
http://www.datadictionary.com/order.html, it's $699.00. 

 

 

 

Sep 13, 2012 at 7:06 PM

I have the same issue as CPExplorer and have not found a solution. Please help.

Jun 24, 2014 at 1:38 AM
I am also having the same issue as those above.
I have tried the same steps but it is still not working
I am on Windows 7 Pro and have .Net Framework 4.5 installed on the machine.
Getting the same message.


System.BadImageFormatException: Could not load file or assembly 'Interop.MSDASC, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An attempt was made to load a program with an incorrect format.
File name: 'Interop.MSDASC, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'