954,535 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

vb.net with msSQL2005 publishing

Hello to all, I got problem in my vb.net program in publishing it.

I am using Microsoft Visual Studio 2008, when I publish my program and I got the setup file and when i tried to run into another computer I got some error saying that it cant connect into the database.

Actually I used msSQL 2005 server in my VS 2008.

I will appreciate for any help. thanks

Sorry for my bad english.

ZER09
Light Poster
47 posts since Jul 2009
Reputation Points: 10
Solved Threads: 0
 

You need to install the appropriate version of .net framework and MS-SQL server on target machine before deploying your application. However you can embed MS-SQL express into your custom applications.

__avd
Posting Genius (adatapost)
Moderator
8,648 posts since Oct 2008
Reputation Points: 2,136
Solved Threads: 1,241
 

Its mean that if I will export the database in new MS-SQL server I need also to edit the connection string of the application.

ZER09
Light Poster
47 posts since Jul 2009
Reputation Points: 10
Solved Threads: 0
 

Yes!

__avd
Posting Genius (adatapost)
Moderator
8,648 posts since Oct 2008
Reputation Points: 2,136
Solved Threads: 1,241
 

can I ask one more? How can I export my MS-SQL database using SQL sever management studio express?

ZER09
Light Poster
47 posts since Jul 2009
Reputation Points: 10
Solved Threads: 0
 

Right click on database name and select Generate Script.

__avd
Posting Genius (adatapost)
Moderator
8,648 posts since Oct 2008
Reputation Points: 2,136
Solved Threads: 1,241
 

ok i got it thank you for the help. by the way do you have any tutorial for vb.net or c# for the beginners in pdf format. thank you in advance.

ZER09
Light Poster
47 posts since Jul 2009
Reputation Points: 10
Solved Threads: 0
 

Try this site.

http://www.dreamincode.net
http://www.dzone.com


I always use this site to look for the tutorial. :)

bincly
Newbie Poster
3 posts since Jan 2011
Reputation Points: 10
Solved Threads: 1
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: