SQL Server 2005 Express issue…

5 pts.
Tags:
SQL Server
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following