Deploying Desktop Application With SQL Server Express As Backend Db On Local Area Network

May 28, 2009

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?

View 2 Replies


ADVERTISEMENT

Deploying An Application Express 2010 With A Sql Server 2008 R2 Database?

Apr 10, 2012

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.

View 5 Replies

.net 08 Local Area Network (LAN) Source Code?

Mar 4, 2010

find a source code of using a local area network(LAN) in visual basic.net 2008?

View 1 Replies

Stream Audio And Video In The Local Area Network?

Oct 26, 2009

I am developing an application where in I need to stream audio and video in the local area network. There is calling option from my application where users can call each other(audio call or video call) in the LAN.

View 3 Replies

Deploy Windows Application With Its Local Database SQL Server R2 Express?

Apr 5, 2012

how can i deploy windows application developed using Vb.net and Sqlserver R2 Express as local database?..how can i make it in setup format(including sqlserver) to deliver to clients?is it compulsory the client should install SQL Server R2 Express in his system apart from the installation of this windows application?

View 5 Replies

Deploying Sql Server On A Network

Jun 6, 2011

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

View 1 Replies

Open Excel On Local Desktop Using Remote Desktop Application ?

Jun 11, 2012

We have a Windows Forms VB.NET application running on Windows Server 2008. Users access this app using Remote desktop.The app displays information in Excel, but Excel opens on the server.Is there a way for the .NET app to launch Excel on the users local desktop?

View 1 Replies

Deploying A 2005 WinForm App With A SQL Server Express Database?

Jun 2, 2006

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.

View 7 Replies

SQL Server Name On Local Computer Not Network?

Jul 18, 2012

how to find the list of SQL servers on the local machine...and not the network...

I searched in google but everywhere its for the list of SQL servers on network....I just want my PC SQL server name....

View 4 Replies

Make A Chat Application That Can Go Out The Local Network?

May 16, 2012

I have been trying to make a chat application that can go out the local network for quite some time, but all I seem to find is chat applications for in local networks?

View 7 Replies

Windows Application + Accessing From Outside The Local Network?

Jul 12, 2011

I have developed a windows application for my company. It is a multi user software and we are using sql 2008 as the database. The sql 2008 is installed in our company server. Within our LAN, there is no problem in accessing the software and its working pretty fine.

Now the problem is, some of the managers need to go out frequently(for business tour and all) and they need access to this software. The software is already installed in their laptops.Is there any way to access the database that is in our company server ???

We have few static IPs with us, is there any way i can use that here (Using NAT in the firewall or something)?

View 3 Replies

Deploying A .net Application With A .MDF File(sql Server 2008) + ClickOnce?

Apr 19, 2011

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?

View 2 Replies

SQL Server - Local Database With Visual Basic Express 2010

May 24, 2011

Visual Basic 2010 Express, lets the user to add a Local Database with .sdf extension. These databases needs MICROSOFT SQL Server to be created or they can run in the user's pc without any additional software? What are the limit of these databases unlike an external database?

View 2 Replies

Is Storing Image File In Database Good In Desktop Application Running In Network?

Oct 21, 2009

I recently came across a problem for image file storage in network.I have developed a desktop application. It runs in network. It has central database system. Users log in from their own computer in the network and do their job.Till now the database actions are going fine no problem. Users shares data from same database server.

View 7 Replies

Storing Image File In Database Good In Desktop Application Running In Network?

Aug 5, 2010

I recently came across a problem for image file storage in network.I have developed a desktop application. It runs in network. It has central database system. Users log in from their own computer in the network and do their job.Till now the database actions are going fine no problem. Users shares data from same database server.

View 3 Replies

Develop An Application Which Can Connect Any Remote Server And Pick The Configuration Information From Server And Show It In Desktop?

Feb 10, 2010

I planing to develop an application which can connect any remote server and pick the configuration information from server and show it in my desktop.

View 4 Replies

VS2010 Converted 32bit App From .Net 1 To .Net 4 Not Loading Without Local Version Of SQL Server 2008 Express Running?

Mar 28, 2011

I have an application that will not load unless my local SQL Server is running on an Vista Home Premium machine. This started after a .Net 1 to .Net 4 conversion. I am using a sub main sub that is not being called (msgbox is not fired when entering the app), however, I see the app through taskmgr with increasing memory usage, but then the app is removed from the list. By design, if the program cannot locate a SQL Server a form pops up with a connection box to locate the SQL Server for the app. How it determines if it has a valid connection is the program looks for a connection string in the registry, then attempts to connect to it, however, none of this code executes because of the failure to enter into the sub main.The two machines I have tried the 32 bit app on

XP Pro: Failed / Using SQL Server 2008 Express

Windows 2003 Server: Works / Using SQL Server 2008 Developer

Both machines have .Net 4 Client Profile with Extended?

View 10 Replies

Enable Application To Run On Server / Network Share So That Only Serial Number Needed Is For Server?

May 29, 2012

I have an application I have developed which works great on individual PC's. However I've had some interest from a few customers that asked if I have a network version for site licencing.If my app did not save any data or write any reg entries, this might have been ok. But it does to the local computer. I also built in my own copy protection and trial function that stores data in the registry on the local computer.What would I need to do to enable my application to run on a server/network share, so that the only a serial number needed is for the server?

View 3 Replies

VS 2005 Net Application And SQL Express Network Deploy

Aug 17, 2009

I have my vbnet application with sql server express designed for individual desktop pc. Now I want to have it work on a network.

1_ how can I make my customer to install sql express and the Database on the server and enable the network protocols seamlessly? dont want to have my customer configuring sql expess manually. 2_ how can I have my client software to look for the sql express and connect to it in a seamless way??

Can I avoid the customer to enter configuration data?

View 7 Replies

Remote Desktop Application? Safe To Use Winsock In Creating A Client/server Application?

Jul 18, 2012

Im planning to create a Remote Desktop Application and I'm having problem with viewing other computers monitor or screen.

Im not asking for the code on how to do it. and one more thing is it safe to use winsock in creating a client/server application?

View 3 Replies

VB Express 2010 : A Network-related Or Instance-specific Error Occurred While Establishing To Sql Server

Jun 1, 2010

i downloaded samples of vb 2010, i tried to run Create DB (Data Samples) but i'm receiving this error. I have MS SQL Server 2008 installed.a network-related or instance-specific error occurred while establishing to sql server. the server was not found or was not accessible.Verify that the instances name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error:40 - Could not open a connection to SQL Server)

View 3 Replies

C# - Deploy An ASP.NET Application As Desktop Application (with Server Component)?

Jul 7, 2010

Question: I created an ASP.NET web application. Now it originally was meant for deployment on a webserver.That is working, so, so far so good.My question now is: Is it possible to deploy it as a desktop-application, too? That is to say the installer installs some kind of server, plus the web application, configures the server to run this application on a localhost URL, and then creates a link in the start menu/desktop, where it opens that url (website, the application) on localhost in a web browser?

I think it should be possible, though the server wouldn't be IIS, because this is a windows component which can't be separately installed. Is there anything like this already out there The nonplusultra would be that it only starts the server when you click on the shortcut.

View 4 Replies

Database Backend (.MDB) Copied To Project Directory - Connect To Network Drive

Apr 20, 2009

I'm a bit new to VB.NET and I have a database which I want to connect to an access backend stored on a network drive for multiple users. I can view the Database in the solution explorer and the directory defaults to the project folder. How can I specify the directory to pull from my network drive? VS has copied this datasource and imported it locally which is fine for testing, but i need the file accessible for multiple users. Is this something I do when publishing?

View 3 Replies

Using SQL Express 2005 As Backend Database On VB6(front End)

Mar 9, 2010

I've been using ms access bfore but want to upgrade coz the company im working in is getting bigger. With almost 10,000 new clients added every week. Im afraid access can't handle it anymore. So im planning to create a new database. Im really new to this SQL Express but have knowledge in sql using vb codes. Is it easy to be used as backend database?

View 6 Replies

PHP + SQL Server - Desktop Application Can't Be Replaced By A Web Application?

Jun 22, 2009

the system is going to have two front-ends - one web application and one desktop application.The desktop application is going to be coded using VB.NET, and the web application in PHP. There's really no reason why the desktop application can't be replaced by a web application as well - except that one of the programmers seem to really want to code it in VB...However none of us have experience working with either of these pairs .

P.S. hosting service will be gotten from some provider and not be on the client's own server.

View 3 Replies

Connection Between Desktop Application And Online SQL Server?

May 19, 2011

I made a desktop application and I Have a server on the internet and I need to make a connection between them

Can some one advise me about this problem?

View 3 Replies

Sql Server - Interact Sql Database In Desktop Application?

May 26, 2010

I am writing a desktop database application. I want my application to use SQL database.

View 1 Replies

Web Service On Web Server For Local Application Advice?

May 15, 2009

i am looking into web services to be used for a windows forms application that i want to connect to my website and return data from my database. One thing i am concerned about is security. I have only played with web service a little bit but it seems to allow direct access to it by url and then run the service, showing the results in the browser. i guess i could set it up to accept a password in the code. i guess really if i have to pass in the query criteria to the sql from the application then showing the records in a browser should not be a problem. in my web application for the site i can keep all my web services in the app_data folder for no browser access.

i just need some advice in this area. goods, bads, other options if better. i don't have a full grasp on working this way from a client side windows application.

View 9 Replies

Send Values To Application In Client PC From Local Server Using PHP?

Jun 21, 2012

I have three client PCs and one local server (actually a pc- Using windows 7 Ultimate on it).

In the server pc I have XAMPP installed and I am running an application developed using PHP on it. There I have the following PHP variables[code]...

View 1 Replies

Client/Server Chat Application ..Works Only On Same Network?

Mar 14, 2010

I have a client/server chat application which I made . My question is how do I make the application work not only Locally but On any other network. I tried putting my IP in the part of creation of the client socket .

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved