SQL Server 2005 Express issue…
Hallo,
we have a pc that has Visual Studio and Sql Server 2005 Express installed on it, lets name it SERVER. We did a small project/application on SERVER with Visual Studio that has to be installed on another pc(client pc, lets name it CLIENTPC) and make some sql queries. The Database is placed on SERVER and the small project/application is placed on CLIENTPC. The application makes some queries from CLIENTPC to SERVER.
Our problem is that we get error even from the beginning of the application, when we run it from CLIENTPC on myConnection.Open() method.
We have to notice that the CLIENT machine does not have sql server express installed on it, and it seems that we are missing something here. In sql server 2000, installation of MDAC was enough but in server express 2005 there are no MDAC.
Any idea what we have to do so client could 'see' and 'work' with SERVER database files?
Thanks in advance
Software/Hardware used:
Software/Hardware used:
ASKED:
February 6, 2008 7:30 AM
UPDATED:
February 9, 2008 2:16 AM
Answer Wiki:
You need to install SQL Server 2005 Express edition before they will be able to see the files. This can be downloaded from <a href="http://www.microsoft.com/sql/">Microsoft's SQL Server site</a>.
I can guarantee that it was never enough to just install MDAC to be able to use SQL Server data files. You have always had to install the database engine and attach the database to the engine to be able to use the files.
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.