View Complete Post
I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.
I have two SQL Server instances installed.
1- UserLT (this is sql 2000)2- UserLT\SQL2005 (this is SQL 2005 named instance)
But when i try to add a database to my VS website project I get the following error:
Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925
I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)
and changed the "SQLEXPRESS" to "USERLT\SQL2005".
But I still get the same error message. Any ideas how i can resolve this issue?
i've installed SQL server 2005 express and Visual web developper 2005 express.
when i whant to create a database in VWD the following error occures:
connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=49251
i searched the internet but can't find the solution, i already reinstalled my complete workstation but the problem stays.
I have linked my tables, in SQL Server Express 2005, to MS Access 2007 and created a File DSN named LocalSQLServer.dsn. Both the front end (MS Access 2007) and the back end (SQL Express 2005) are on the same machine.
I am trying to check an open connection , and for that I have written a module -- Function CheckConnection(strFileDSNName As String, _
strDBName As String, Optional strUN As String, Optional strPW As String) As Boolean
strConnect = "Provider=ODBC" & _
";FILE DSN =" & strFileDSNName & _
";Database=" & strDBName
I have created a form with a command button to check the connection, but it is giving the following error
"-2147467259; Method 'Close Connection' of Object'_CurrentProject failed
I am not able to figure it out, if the Connection Parameters that I have taken are correct or not. Please help me in this.