Forum Discussion

John_Carter56's avatar
John_Carter56
Copper Contributor
Aug 04, 2021
Solved

Trying to connect via ODBC. Can't find assembly 'Microsoft.SqlServer.ConnectionInfo'

I'm trying to use a third-party app to create a new database in one of my SQL Server instances and receive an error stating that it can't find assembly 'Microsoft.SqlServer.ConnectionInfo'.  I can fi...
  • John_Carter56's avatar
    John_Carter56
    Aug 06, 2021

    olafhelper Thanx.  In my case, I had to download the correct version (in this case, SQL Server 2014 Feature Pack) of the Shared Management Objects (SharedManagementObjects.msi) and SQL system CLR types (SQLSysClrTypes.msi).

John_Carter56's avatar
John_Carter56
Copper Contributor
Aug 05, 2021

olafhelper Thanx for your reply.

 

You are correct that Microsoft.SqlServer.ConnectionInfo has nothing to do with ODBC.

 

I'm pretty sure I've got the SMO installed as I find Microsoft.SqlServer.ConnectionInfo.dll in a number of directories including the following:

    * c:\windows\assembly\GAC_MSIL

    * c:\windows Microsoft.NET\assembly\GAC_MSIL

    * c:\Program Files (x86)\Microsoft SQL Server\110\SDK\Assemblies

 

I guess the app I'm using can't find the assembly so what can I do to set the environment so that it can find that assembly?  Since it is a DLL, is it a PATH thing or something else?

olafhelper's avatar
olafhelper
Bronze Contributor
Aug 06, 2021
Best bet is to ask the support of the third-party app vendor, they should know how to fix.
  • John_Carter56's avatar
    John_Carter56
    Copper Contributor
    Aug 06, 2021

    olafhelper Thanx.  In my case, I had to download the correct version (in this case, SQL Server 2014 Feature Pack) of the Shared Management Objects (SharedManagementObjects.msi) and SQL system CLR types (SQLSysClrTypes.msi).

Resources