Showing results 1 to 4 of 4

Thread: Adding Datasource in VSTA

  1. #1
    schilderf Gast

    Default Adding Datasource in VSTA

    Hello,

    I want to add a data connection in the VSTA database explorer but i've got some errors.
    Sometimes I recieve the error that the database is in use.
    And sometimes I get the following error:

    Unable to add data connection.

    Could not load file or assembly
    'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0,
    Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. the system cannot find the file specified.

    When I search for detail information about this issue some forums advice me to install the SQL Server Management Objects package for SQL server 2005.

    My first question:
    - is it possible to add a data connection?
    - can I install the SQL Server Management Objects package?

  2. #2

    Default Re: Adding Datasource in VSTA

    This message appears most likely due to the fact that VSTA 2.0 is based on MS Visual Studio 2008, and the Microsoft SQL Server Express instance installed with zenon (zenon_dev) is a Microsoft SQL Server 2005 Express instance. (instead of a Microsoft SQL Server 2008 Express)

    First you need to install: "Microsoft SQL Server System CLR Types"

    Then you need to install: "Microsoft SQL Server 2008 Management Objects"

    These installations are part of the Microsoft SQL Server 2008 feature pack and can be downloaded here:

    link

    After a restart of the zenon editor you should be able to add the data source without the error message.

  3. #3

    Default Re: Adding Datasource in VSTA

    note, that in VSTA it is not possible to select "Microsoft SQL Server" from the list of available data sources. In the proffessional versions of Microsoft Visual studio this data provider is available.

    However after you have configured the data source to use a (new) local .mdf file, for the "Microsoft SQL Server Database File" data source, you can reconfigure the connection string for the dataset, to directly connect to the database.

    you could e.g. configure the data set with a local (detached) copy as a .mdf file, and then afterwards connect to the SQL server.

  4. #4
    schilderf Gast

    Daumen hoch Re: Adding Datasource in VSTA

    It works.

    Thank you very much

Similar Threads

  1. IEC61850 Driverconfiguration messed up after adding a driver
    By markclemens in forum zenon Energy Edition
    Replies: 1
    Last Post: 22nd January 2016, 11:29
  2. VSTA Startproblem
    By stevethefiend in forum VSTA
    Replies: 12
    Last Post: 11th March 2010, 03:16
  3. VSTA and Datagrids
    By stevethefiend in forum VSTA
    Replies: 2
    Last Post: 10th March 2010, 00:50
  4. VSTA Batchinformationen
    By stimpfig in forum VSTA
    Replies: 1
    Last Post: 18th January 2010, 16:54

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •