Background info I have SQL 2005, 2008, and 2012 installed. I am running VB.net 2010. In my my program I have checked my connection with the modify connection and went to advanced and checked my data source. I have 4 sources .\SQLexpress, ., .\sqlexpress2008, and .\act7. I am using "." the rest fail connection test giving me 661 or 655 can not connect to 706. I am trying to use linq to sql and when I try to "database.submitchanges()"
i get the following error.
The database 'C:\database\FIRSTDB.MDF' cannot be opened because it is version 706. This server supports version 655 and earlier. A downgrade path is not supported.
Could not open new database 'C:\database\FIRSTDB.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file C:\database\firstdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
The code im using for the datacontext
Public Class lqdc
Public invoices As Table(Of Invoice)
Public Sub New(ByVal connection As String)
Private Sub btnCommit_Click(sender As System.Object, e As System.EventArgs) Handles btnCommit.Click
Dim database As New lqdc("C:\database\firstdb.mdf")
Dim AddInvoice As New Invoice
AddInvoice.OrgId = cbOrgId.SelectedValue
AddInvoice.ClientId = cbClientId.SelectedValue
AddInvoice.TechId = cbTechId.SelectedValue
AddInvoice.theDate = dtpDate.Value
AddInvoice.Notes = txtNotes.Text
AddInvoice.Parts = txtParts.Text
AddInvoice.Labor = txtLabor.Text
AddInvoice.Mileage = txtMileage.Text
AddInvoice.TotalCost = txtTotalCost.Text
AddInvoice.InvoiceNumber = txtInvoiceNumber.Text
'errors out right here with using older connection for some reason.
So why is it in Visual Basic using an older version of SQL to submit my code?