Click here to Skip to main content
16,019,843 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi to all :) :)

I have developed a windows application in C# and used SQL Server 2008 as DB and now i deployed and created a .exe for that application , now my question is that to install it in target system , does the target system must be instlled with SQL Server or not?

Thanks in Advance
Phanindra :)
Posted

1 solution

You don't need SQL Server installed on the machine just to provide SQL connectivity...the drivers required to connect to SQL Server are installed as part of the framework.

If the target machine is connected to a network or can 'see' the machine that has SQL server installed, then just change the connection string to point at the SQL server instance

You then have a client (the machine running the program) connected to a server (machine running SQL Server), which is a classic design for application requiring database access


However, if you don't have a server \ shared machine running SQL Server and you want to use (localhost) in your connection string, then you will need SQL installed on the target machine
 
Share this answer
 
Comments
phanindra_mangipudi 1-Mar-11 11:47am    
Sir , Can you help me with more clarity or how to do it , Please Smile
Dylan Morley 1-Mar-11 12:14pm    
Please provide more info, do you have a server you want the client to connect to? Or do you want to use localhost?
phanindra_mangipudi 3-Mar-11 12:40pm    
sorry for late reply sir,
with the .exe i have i can install in any where or any machine ; how can i say that particular machine ; the machines may or may not be shared , i mean that every client is different from others

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900