Advice required on SQL Server 2008


Author
Message
Peter Denton
Peter Denton
StrataFrame User (147 reputation)StrataFrame User (147 reputation)StrataFrame User (147 reputation)StrataFrame User (147 reputation)StrataFrame User (147 reputation)StrataFrame User (147 reputation)StrataFrame User (147 reputation)StrataFrame User (147 reputation)StrataFrame User (147 reputation)
Group: Forum Members
Posts: 77, Visits: 787
G'day

I've just loaded SQL Server 2008, upgrading my SQL Server 2005 instance, and tried to run one of my strataframe applications within the Visual Studio 2008 SP1 IDE. Unfortunately I can't access my database.

The following code:

Dim serverSchema As New MicroFour.StrataFrame.DBEngine.SQL.SQLServerSchema

Dim builder As System.Data.SqlClient.SqlConnectionStringBuilder

Dim lcConnection As String = ""

'-- Set the server

lcConnection = String.Format("Server={0};Integrated Security=SSPI;Persist Security Info=False;Initial Catalog={1}", _

"PGD-Vista", _

"TMS201")

builder = New System.Data.SqlClient.SqlConnectionStringBuilder(lcConnection)

serverSchema.Connect(builder.DataSource)

causes an exception wit the following details:

ConnectionFailureException
  This SQL Server version (10.0) is not supported.

Source     : Microsoft.SqlServer.ConnectionInfo

Stack Trace:
   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()
   at MicroFour.StrataFrame.DBEngine.SQL.SQLServerSchema.Connect(String SQLServername, String UserName, String Password, Boolean CheckConnectionOnly)
   at TMSSerialTest.AppMain.fred() in C:\Users\peterd\VS2005 Workspace\TMS Redevelopment\TMS\TMSSerialTest\AppMain.vb:line 57
   at TMSSerialTest.AppMain.SetDataSources() in C:\Users\peterd\VS2005 Workspace\TMS Redevelopment\TMS\TMSSerialTest\AppMain.vb:line 146
   at MicroFour.StrataFrame.Application.StrataFrameApplication.Raise_SetDataSources()
   at MicroFour.StrataFrame.Application.StrataFrameApplication.RunApplication()
   at TMSSerialTest.AppMain.Main() in C:\Users\peterd\VS2005 Workspace\TMS Redevelopment\TMS\TMSSerialTest\AppMain.vb:line 25
   at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
   at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
   at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

I've tried this with the project as it was targeted at .Net 2.0, and again targeted at .NET 3.5 with the same result.

I'm running the 1.6.6 Beta version of Strataframe

Is there a simple explanation (and hopefully solution)?

Thanks

Peter

Reply
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Hi Peter,

Yes I understand, I also want to use MS-SQL2008 for my 1st SF application to be release in 2 weeks.  Let's see what SF Team will say about this.

Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search