Database connectivity

Charith Liyanagamage

Hi Friends......

I developed my application successfully...it works.But I have a problem.It's when I'm going to publish/deploy my application I cant get my database into my application.I'm using VS2008 and SQL 2005 express.
Actually my database query in server and it's not local.It's not visible in server explorer too.I want get it inside the application.

I can still run my application successfully in my pc after the installation since I have that db in my machine.but when I'm going to run that app in another pc it doesnt work.
I think you can understand my problem....

Can anyone give me a solution......???Please somebody help me to do this.I'm stuck with this problem.

Thank you.
Charith

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Lisa17y ago
SQL 2005 Express just works on your system , it doesn't work as server to the other system.

Hence either you should have a SQL Server set up accessible to all who would be using the application or just inject your database to an embedded database directly into your application and publish it along with your application.

Hope it Helps.

Thanks,
Lisa
Mirko Meier17y ago
I think the permissions are the problems, too. Check the permissions of the database.

It can be useful to check the connectionString too. Have a look at ConnectionStrings.com
Prashant17y ago
Please check your settings, there may be permission probelms
Rajendra Deopura17y ago
Dear

I think the problem is with the connection string. Please check your connection string. Use Request.PhysicalApplicationpath( ) for Web Applications and Application.StartupPath( ) for Windows Applications in connection strings.

Thanks