Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. Problem in referring the assemblies

Problem in referring the assemblies

Scheduled Pinned Locked Moved ASP.NET
helpcsharpdatabasesql-serversysadmin
7 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • K Offline
    K Offline
    kandalu
    wrote on last edited by
    #1

    Hi, I am using .net 2.0 and sql server 2005. I have added the assemblies like Microsoft.SqlServer; Microsoft.SqlServer.Management.Common; Microsoft.SqlServer.Management.Smo; in my project. But that project is not running in sql server 2000. It needs those dlls. In my project there is no dll files in the bin folder. Please help me to rectify this error. Thanks.

    S P 2 Replies Last reply
    0
    • K kandalu

      Hi, I am using .net 2.0 and sql server 2005. I have added the assemblies like Microsoft.SqlServer; Microsoft.SqlServer.Management.Common; Microsoft.SqlServer.Management.Smo; in my project. But that project is not running in sql server 2000. It needs those dlls. In my project there is no dll files in the bin folder. Please help me to rectify this error. Thanks.

      S Offline
      S Offline
      Shyam Bharath
      wrote on last edited by
      #2

      What is the error message that u r getting?

      ------------------------------------------- It's code that drives you - Shyam

      1 Reply Last reply
      0
      • K kandalu

        Hi, I am using .net 2.0 and sql server 2005. I have added the assemblies like Microsoft.SqlServer; Microsoft.SqlServer.Management.Common; Microsoft.SqlServer.Management.Smo; in my project. But that project is not running in sql server 2000. It needs those dlls. In my project there is no dll files in the bin folder. Please help me to rectify this error. Thanks.

        P Offline
        P Offline
        Paddy Boyd
        wrote on last edited by
        #3

        I think that the assemblies you probably need are System.Data & System.Data.SqlClient. What are the items you have referenced for?

        N 1 Reply Last reply
        0
        • P Paddy Boyd

          I think that the assemblies you probably need are System.Data & System.Data.SqlClient. What are the items you have referenced for?

          N Offline
          N Offline
          N a v a n e e t h
          wrote on last edited by
          #4

          The assemblies OP mentioned comes with SMO (SQL server management objects) class library.

          Navaneeth How to use google | Ask smart questions

          K 1 Reply Last reply
          0
          • N N a v a n e e t h

            The assemblies OP mentioned comes with SMO (SQL server management objects) class library.

            Navaneeth How to use google | Ask smart questions

            K Offline
            K Offline
            kandalu
            wrote on last edited by
            #5

            Hi, I am getting the following error : Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. If sqlserver 2000 is installed in a system instead of sqlserver2005, I can' locate the SMO reference. The references I added are Microsoft.sqlserver.connectioninfo Microsoft.sqlserver.smo Microsoft.sqlserver.smoenum Microsoft.sqlserver.sqlenum If we add these references, is any dll files will be created in the bin folder or we have to explicitly copy this dll to the bin folder?

            N 1 Reply Last reply
            0
            • K kandalu

              Hi, I am getting the following error : Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. If sqlserver 2000 is installed in a system instead of sqlserver2005, I can' locate the SMO reference. The references I added are Microsoft.sqlserver.connectioninfo Microsoft.sqlserver.smo Microsoft.sqlserver.smoenum Microsoft.sqlserver.sqlenum If we add these references, is any dll files will be created in the bin folder or we have to explicitly copy this dll to the bin folder?

              N Offline
              N Offline
              N a v a n e e t h
              wrote on last edited by
              #6

              Do you have SMO[^] libraries available?

              Navaneeth How to use google | Ask smart questions

              K 1 Reply Last reply
              0
              • N N a v a n e e t h

                Do you have SMO[^] libraries available?

                Navaneeth How to use google | Ask smart questions

                K Offline
                K Offline
                kandalu
                wrote on last edited by
                #7

                Hi, I have SMO libraries in SQL SERVER 2005.

                1 Reply Last reply
                0
                Reply
                • Reply as topic
                Log in to reply
                • Oldest to Newest
                • Newest to Oldest
                • Most Votes


                • Login

                • Don't have an account? Register

                • Login or register to search.
                • First post
                  Last post
                0
                • Categories
                • Recent
                • Tags
                • Popular
                • World
                • Users
                • Groups