473,323 Members | 1,547 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

How to add SQL Server Database into C# / VB deployment package

i made deployment package to install C# application on other computer, where Server not install . So its working fine and install SQL server and my application.My application working fine.Get an error if try to access DB.Bec there is not any such DB created.

But the problem is that how to add DB also in deployment package.
i also try to make DB deployment package in VB .its working fine only for my PC but unable to deploy DB on other computer.SQL server installed on PC ,

i received This Error msg Received

"A network -related or instance-specific error occurred while establishing a connection to SQL server.The server was not found or was not accessible.Verify that the instance name is correct and that SQL Server is configured to allow remote connection.(provider:Named pipes Provider,error:40- could not open a connection to SQL server)"

http://msdn.microsoft.com/en-us/library/49b92ztk%28VS.80%29.aspx#Y798

detail of code and steps to make it given in above site.

so how to add DB into PC
Attached Images
File Type: jpg 1212.jpg (35.3 KB, 379 views)
Mar 16 '11 #1
2 2967
Aimee Bailey
197 Expert 100+
The whole point of an SQL Server is that it resides on one computer and other computers are able to connect to it to insert, query and update information, this means it is not really a viable option to have it deploy with a package as you said as it is simply not practical. However if your needs are that you just wish to have the ability to use a database in your application, then I would suggest you look into SQL Compact Edition. this is a method of using an .sdl file as your database, which can be installed with your application. It is not as powerful as an SQL server, however it would give you many of the abilities you would be looking for.

All the best.

Aimee.
Mar 20 '11 #2
i use SQL compact edition to install on client PC.its install properly on client PC. but i want to use the same database which i am using on my development PC to client PC.but i am unable to do that.this is the problem.
Mar 22 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: DB developer | last post by:
Hello friends I am trying to create a deployment project to distribute my VB.NET application with MSDE database. I am using VS.NET with MSDE 2000 deployment toolkit (release candidate) to achieve...
0
by: Jony Joe | last post by:
Dear All; I am now making a deployment package using the .net deployment setup project. It is a desktop application that its solution contains 7 projects that generate DLLs and EXEs...
2
by: hitendra15 | last post by:
How to Deploy SQL server Database to another PC, How to create a package that craetes Database as well as ODBC driver for accessing data at enduser PC, using .Net VB
0
by: Dean | last post by:
How can I automatically increase the version number of a deployment package so that I don't forget to do this? TIA Dean
4
by: Dmitri Shvetsov | last post by:
Hi, What could be a reason? I wrote a Windows Application on C#. It works with a remote database through the Internet. It works excellent on my developer's machine. When the application is moved...
1
by: Wendy Elizabeth | last post by:
I need to deploy a service that will run on a production server. I am not certain what category of deployment directions that I should follow from the MSDN site. The service is written is Visual...
1
by: SKarnis | last post by:
I have created a simple ASP.NET Web Service with VB on Win XP Pro SP2, IIS 5.1, .NET 1.1. Service works in Visual Studio environment. Created an deployment package. Tried running the deployment...
4
by: Steve Long | last post by:
Hello, I 'm not sure if this is the correct forum to post this question in but, I using MS' suggested method of using their setup.exe and settings.ini to deploy dotnetfx.exe with my deployment...
1
by: vick | last post by:
I installed Visual Studio 2005 Professional Ediction in order to create a 2003 Access Deploymnet package so my client could run the Access system I created on all their computers without having...
2
by: Jim Richards | last post by:
Using XP Pro w/SP2 and Visual Studio 2003. I have no trouble creating a deployment package when the application does not have a sub-directory such as "Images". I have an app that uses a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.