SubSonic Forums
All Your Database Are Belong To Us

subcommander VERSION work under SQL Server 2008?

Latest post 11-04-2008 5:52 PM by yitzchok. 3 replies.
  • 11-04-2008 5:25 PM

    subcommander VERSION work under SQL Server 2008?

    We're using SQL Server 2008 locally.  The version option (you know... Subsonic DB via the webcast) doesn't work correctly.  Is SubSonic 2.1 currently supporting SQL Server 2008 via the version parm?

    Thx.

     

  • 11-04-2008 5:37 PM In reply to

    Re: subcommander VERSION work under SQL Server 2008?

    There is nothing specifically in SubSonic for SqlServer 2008 but you should be able to use SubSonic with SqlServer 2008 just like you used it with SqlServer 2005 (you just tell it your using SqlServer)

    If I am I because I am I, and You are You because You are You, then I am I, and you are you. But If I am I because You are You, and You are You because I am I, then I am not I and You are not You. -Rabbi of Kotzk

  • 11-04-2008 5:49 PM In reply to

    Re: subcommander VERSION work under SQL Server 2008?

     I'm getting the following errors in output, and I'll paste the web.config below too.  I figured sqldmo was different from 2005 to 2008 but maybe it's something else?

    Using same web.config obviously as when get the valid Generated output.

    Setting ConfigPath: 'Web.config'

    Building configuration from C:\src\ssTest1\Web.config

    Adding connection to NorthwindDAL

    ERROR: Trying to execute version

    Error Message: Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server . ---> Microsoft.SqlServer.Management.Common.ConnectionFailureException: This SQL Server version (10.0) is not supported.

    at Microsoft.SqlServer.Management.Common.ConnectionManager.CheckServerVersion(ServerVersion version)

    at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect(WindowsIdentity impersonatedIdentity)

    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()

    --- End of inner exception stack trace ---

    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()

    at Microsoft.SqlServer.Management.Common.ConnectionManager.PoolConnect()

    at Microsoft.SqlServer.Management.Common.ConnectionManager.get_ServerVersion()

    at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetServerVersion()

    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetDbComparer(Boolean inServer)

    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.InitializeStringComparer()

    at Microsoft.SqlServer.Management.Smo.AbstractCollectionBase.get_StringComparer()

    at Microsoft.SqlServer.Management.Smo.SimpleObjectCollectionBase.InitInnerCollection()

    at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.get_InternalStorage()

    at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.GetObjectByKey(ObjectKeyBase key)

    at Microsoft.SqlServer.Management.Smo.DatabaseCollection.get_Item(String name)

    at SubSonic.SubCommander.DBScripter.ScriptSchema(String connectionString) in C:\svn\subsonicproject\trunk\SubCommander\DBScripter.cs:line 51

    at SubSonic.SubCommander.Program.ScriptSchema() in C:\svn\subsonicproject\trunk\SubCommander\Program.cs:line 696

    at SubSonic.SubCommander.Program.Main(String[] args) in C:\svn\subsonicproject\trunk\SubCommander\Program.cs:line 68

    Execution Time: 3531ms

     

     

     

     

     

     

     

  • 11-04-2008 5:52 PM In reply to

    Re: subcommander VERSION work under SQL Server 2008?

    Sorry I didn't notice that you said the VERSION command ya that looks like it only work with SqlServer 2005

    If I am I because I am I, and You are You because You are You, then I am I, and you are you. But If I am I because You are You, and You are You because I am I, then I am not I and You are not You. -Rabbi of Kotzk

Page 1 of 1 (4 items) | RSS