Create an EXE or setup file in .NET Windows application which can use SQL Server 2005

Question

I have been working on a C# windows application with SQL Server 2005, and now I need to deploy it to other system.

I created a setup file using setup an deployment filling all the prerequisite but as I deploy it on another computer error keeps popping up saying it can't open connection.

I am thinking my problem here is in deployed project database is missing.

Now my question is how can I use this database and I have connection string that work only in my system so I need to change this connection string too.

How can I do that?

Please help me tackle my problem...

thank you in advance

user1343820 · Accepted Answer · 2012-04-23 08:31:27Z

2

Are you using sql compact or sql ? if it is sql compact, you can add the file to you project and join it to you project and deploy it, if it is SQL you need to have an Public WAN SQL server so you app can access it thru internet.

answered Apr 23, 2012 at 8:31

user1343820

Sign up to request clarification or add additional context in comments.

2 Comments

shunilkarki Over a year ago

i am using sql. but can you help me how can i deploy sql compact as well as sql

user1343820 Over a year ago

sql compact is just like sql, but in a file. Just config your OleDB connection and add an sql compact database file to you project and create an DataBound to it.

Collectives™ on Stack Overflow

Create an EXE or setup file in .NET Windows application which can use SQL Server 2005

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related