Hi all, 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]"
i just reinstalled vb.net, and could conect to a sql server compact (came with vb.net) .. and when trying to make a query into the northwind db, im getting : "error while trying to create de consult, there is no assigment of DbType Ofject to any known SQL Server Compact data type"
re-done it again.. checked the connection String and has the whole path to the db.. the db in the DB explorer is conected.. BUT let me make the sql query without the where clause.. any idea why this happend and how can i make to use the where clause??