I have an application that accesses a sql server 2008 database. The server and database is stored on my local harddrive and I would like to learn to scale this up to having multiple users in our office access the application which I will i deploy on a server. For now the database will stay on my pc until I am ready to put it on a dedicated server for myself but for now how do I allow the application still to access my database without allowing anyone direct access to my server or my pc drive. Here is my current connection string:
I have recently developed a back end database in SQL server 2008 R2 and attached it to a application in VB express 2010.Everything works fine and when i publish the application, it works fine on my machine, but once i try to setup up the application on another machine i get the error message: A network related or instance specific error occurred while establishing a connection to SQL Server. Server was not found or not accessible please verify the instance name is correct or allow remote connections.I have read numerous forums on this saying about changing the connection string and instance name.but with being novice i dont understand what needs to be changed etc.The sql server allows remote connections, but i am unsure what else needs changing to allow the application to work with the database on another machine.
I have a VB.NET 2005 WinForm app that accesses a SQL Sever Express database.I use the Microsoft Practices Enterprise library to handle my data access with the following appearing in my app.config file.
I am trying to deploy a VB.net application that is currently using SQL Server 2008 as its database to connect to.I need this application to be able to include a copy of its data so that wherever I install the application there is no need for them to install SQL Express.
What i have been reading is that I should of been using SQL Server Compact Edition to do this. Is there any way that I can do this with using an .MDF file?If not, is it possible to convert an .MDF file to .SDF and then just include it in my vb.net app?
I have been getting an error when moving my application from my local machine to a web server. (I have not been getting the errors on my local host)[code]The first of the exceptions is the first error that came up using SQLOLEDB.1 as my provider, I started playing around with different providers and got the second 2nd exception.
PLEASE I HAVE OVER TEN CLIENT COMPUTERS. AM DESIGNING AN VB.NET WITH MSSQL SERVER 2005 EXPRESS APPLICATION THAT THE CLIENT CAN CONNECT TO THE DATABASE ON A ON COMPUTER.HOW DO I DO THAT.#ie vb.net + sql server network application
Basically back in VB6 days, I created several VB6 apps with Access as the backend database. I'd package my Access db file with the application setup, which copied it on to a shared network drive, and then different computers on the LAN could use the same backend database file, and that worked just fine. With SQL and VB .Net, I've done work with a SQL database hosted on a remote server, so you can basically build your query string easily and anyone can connect to it from anywhere, and it works just fine.However, what I'd like to do is have a local SQL express database as the backend for a VB .Net application and make a setup program that can install it in a way that it could be shared on a Local area network, without the user who is installing the application do anything.
I know about building a connection string with the local machine name, but I don't really have any experience with including an actual MDF file with the application. Does anyone know how it works, and is it a better approach? Does it work similar to placing an access file in a shared unc path?I know that ClickOnce (which is awesome) can install SQL express easily on a user's machine. However, the key is that I want SQL express to be installed only on the machine that is going to be the database server in a LAN enviornment, and not on every machine, unless it is neccesseary. And then how does your VB app know how to build the connection string to access the database from any machine on the local share?
have been trying to figure out for weeks now how to deploy my software With database to another computer. nothing seems to work. Is there a way I can do this Automatically. the software works on the other computer but it does not find the database and cannot connect either.
After deploying my project, I tried to install it on other pc , it installs well buthenever i run the .exe application my database file which is MS Access cannot be found.Well obviously the path is the problem.How would i make my path flexible and so that whenever i install it to other pc, my database will already be found. And also how can i include the database file inside the installer
I've tested an application (one that I'm developing) that utilizes MS Access database (.accdb) on a backup machine. And I consistently get an unhandled exception error saying 'The Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. I suppose I get this error because the backup machine doesn't have a driver or whatever to read the Access database file. Reading
this topic titled "How to deploy VB 2010 application as a standalone without MS Access", I understand that I can just specify a prerequisite for this component (driver or whatever...) in the project designer window in reference to this page. I wonder if there is a simpler way of delivering the database component to users? Or should I abandon the Access database and use a different one for easier accessibility?
I'm a first time visitor and poster, but I'm definitly going to stick around. I'm running an old version of Visual Studio .Net Academic 2002 and the .Net framework 2.0. I'm stuck on an issue regarding the deployment of a few programs I've thrown together. They all work fine on my development machine, but the problem they all use SQL Server databases, and I can't find any specific help on deploying a windows application with a database on a machine that isn't set up basically just like my development machine.
I know that I need the .net runtime bootstrapper on the target machine, so I can run basic programs that dont use SQL databases. That's no problem. But what about programs that make heavy use of databases? How does one go about deploying it on target machines? Is there a SQL server bootstrapper?
I have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
I am about to finish an application for a client. Now I'm having hard time deploying it since I really don't know how to do it.How do I deploy a windows form application with database?I've already downloaded the prerequisites redistributables. I also want those to be included in the installer.
I have to deploy my VB.NET application, and create a new access database with 5 tables, some filled in with values on installation in a specified folder in the C: drive which also needs to be created. I have found using google havent seemed to work for me. I am using Visual Basic 2008 Express Edition, so maybe I need to use a proper copy of Visual Studio 2008 to do this.
So basically I am looking for a way to create a .exe file that will be used to install my program on a user's computer, and create a folder and database with some values on instalation. Could anyone tell me how I can do this or point me in the right direction? EDIT - Also would you be able to answer this question for me. Will the computer that the program will be installed on require visual studio or any other software to run my program?
Is there any literature which guides a user through the steps of deploying a vb project created with VS 2010 Professional and incorporating SQL 2008RE Database?
I have a VB project which incorporates 2 databases - 1 Access Db and 1 SQL Db. The project compiles and runs beautifully. However, after adding the databases in the project as existing items and deploying, the project opens/runs, but when I try to login the application I keep getting an error message telling me that the path to the .mdb (Access) database is not a valid path. I don't have a clue what else to do.
I have a problem here... I'm using SQL Server as may database and developing that database in Visual Studio 2008.my problen is, when I use the STORED PROCEDURE from SQL SERVER it doesn't update/save new data on a the table. here's my coding; This is my stores procedure: when I execute this on on SQL SERVER it worked perfectly.
I have used 2008 and click once to setup a deploy to a network area...however I have been asked to do a wee program for a friend.How would I create a setup file to give to them on a CD/ pendrive etc??
i have developed one windows service to support my front end application. I need to deploy only service project as MSI so client simply can install and no need to open services.msc for manual action.
I tired to use InstallUtil C:Myservice.exe and it is working but all client don't have VB.NET to find installUtil.
i have a project and i used NSIS to create a Setup file. I am able to install it to my system but some parts of the program do not work (and they work when i run my project in VB). For example i have a Back Up option that creates a back up but this does not work when i run the application via the installation file. Probably it has something to do with the directories?
If System.IO.Directory.Exists(CurDirectory + "Backup Folder") = False Then System.IO.Directory.CreateDirectory(CurDirectory + "Backup Folder") End If
how can i make it work from the installation file? Do i need to copy something somewhere?
I've got a webservice and the WSDL file it pointing to a local file for testing reasons, is there a way of changing this when deploying my app without removing and readding them all?
I created some database already in my SQL server 2008. And im planning to show all this data via graph using VB.net..Is there anyone here can give me LINK, thread or the best is tutorial so that I can begin doing it.Usually my data is based on date only. So once the date inputted then it will SQL and get the exaxt data in Graph format.
Imports System.Data.SqlClient Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click CreateDatabase() End Sub
I was creating an enrollment system for my Thesis, and my adviser told me that I must have a Code in my program that Synchronize database from client and server so that if the terminal connection is "Up" the data will go to the server and if the connection is "Down" the data will go to the installed server on the the local machine. and every 20 mins or 30 mins will sync the database.
I am trying to store a .png image inside a database using SQL Server 2008. I have done this just fine using mySQL but for some reason it looks like this when placing it into ms SQL Server:
I would like to create a server program that accesses an "ms access" database. I will also need a client program that connects to the server. The reason for this is that the server is a mediator for several clients. Since I am using access, I plan on maybe having 20 or 30 clients connect to the server only. The client will have access to a virtual market. So when a person buys or sells something on the market, the server mediates the transaction and etc. At the same time, the access database saves each clients data as well as the overall market data.
I'm working in .NET solution Visual Basic that makes reporting of a database using Crystal Reports for .NET, and I want to store each report after it been generated in the database in xml or in PDF just tell me how?
