i started programming with .NET (i have express edition) and wanted to make a conection to an SQL Server.. the problem is that i cant conect :(
previously i had .net 2005 - i started having the issue there - i unistalled it, n installed visual studio 2008.
I have installed SQL Compact that came with the .net 2008, and besides it SQL Server 2000.
When I try to make a conection to the SQL Server, if server is running I have to stop it and then choose the DB i want to use. (if its running wont let me choose any DB). Then, when i select the DB i need, Im getting this error:
"The instruction CREATE FILE fount SO error 5 (failed to retrieve text for this error.Reason:15105) while trying to open or creating the fysichal file : -path- to northwnd_log.ldf.
Cant open the new database -path to northwnd.mdf. CREATE DATABASE discarded.
Error while trying to attach a DB automatically named for archive -path to northwnd.mdf. There already exists a database with the same name, cant open the specified file or it is in a shared UNC resourse.
File activation error. File name -path to northwnd_log.ldf- might be wrong"
And when i try to connect with the SQL compact edition that came installed with the visual studio, im getting this error:
"Can not allow access to the file in DB [File name = path to northwind.sdf]"
And dont know what is that im doing wrong.