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
ADVERTISEMENT
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
Jan 26, 2010
My college said he had problems creating a ClickOnce deployment because he could not reference one of the 2 Interop DLLs in his visual studio. I find this rather hard to believe so I'd like some input from experts. is it true you can only deploy the dlls that are referenced in your project?
View 2 Replies
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
Mar 20, 2010
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:
[Code]...
View 1 Replies
Mar 12, 2010
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??
View 1 Replies
Nov 20, 2009
I have an application that uses a text file for its settings. This file is placed in the application folder but deployment sets its file attributes as "Read Only". I have to manually change this attribute every time I deploy the application or an upgrade. I tried (successfully) to place the text file in the "Documents and settings|All users|Application Data" folder, creating a specific folder for my application in which to place my file. The folder and file were created by the setup process but then, users who did not have admin rights still did not see the file, let alone open it.
I have gone back to placing my text file in the [Programs files]|[Manufacturer]|[Application name] folder but am saddled with manually changing the attributes. Is there a way I can do this programatically during deployment (e.g. by some post-deployment process)?
View 4 Replies
Nov 5, 2010
I have created a clickonce application with a file format to be associated with it. (publish -> Options -> File associations) I have tried to get the file name from command line arguments but i can't. I think that there is an other way to get it.
View 8 Replies
Apr 11, 2009
How do I publish/deploy the WinForms application including a database file via ClickOnce?
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback,
View 1 Replies
Jan 15, 2012
I've built a VSTO add-in for Microsoft Word and deployed to a webserver. Installation goes off without a hitch. When I create an updated version of the application and redeploy it to the webserver, the add-in correctly detects that there's a new version and attempts to update it. This is where I'm running into the following error (the "xxx" indicates that I had to censor something):url...The customization cannot be installed because another version is currently installed and cannot be upgraded from this location. To install this version of the customization,first use Add or Remove Programs to uninstall this program: xxx. Then install the new customization from the following location: url...This appears to me as if I left a local reference of some sort in my Project, but I can't find anything of the sort. The only reference to this file is within the xxx.vbproj.FileListAbsolute.txt file that's generated in the bin/Debug folder.Not sure if this is also a clue, but I'm seeing Registry Keys added referencing this as the location of the VSTO Project Manifest.
View 1 Replies
Mar 15, 2010
VS 2008 / VB.Net / WinForms I have an application setting (Settings.settings) for a project and I am using Click Once deployment. I used the VS Editor to create the setting and I can see the setting in the app.config file
<applicationSettings>
<MyApp.Win.My.MySettings>
<setting name="MySetting" serializeAs="String">
<value>False</value>
[code]....
View 1 Replies
Aug 24, 2011
My application/project has an Access Database as its Project DataSource. I have a DataSet Designer (.xsd), with many TableAdapters, some of which I've created via the Designer. I have 2-10 users/foreman on any given workday, with their own Netbook and my ClickOnce Application.Users will add/edit/delete records in each of their own versions of the App/DataBase, XML files, representing changes, are created and upload to an ftp server.The corner I've painted myself into:When my Project Manager downloads these XML files using his own version of the application, analyzes each reported item, confirms and updates his version what is the best way to propagate those updates back to each user without having to update the project db and publish again?
View 4 Replies
Mar 11, 2010
I've used VB2008EE to create a Windows Forms app which includes a Help form. The helpform contains a Treeview for navigation and a WebBrowser control which displays the relevant part of an HTML page containg the help information.The app is intended to be used offline - so I need to include the HTML page file as part of the published app, and I need to be able to specify where this HTML file will be installed on the target computer so that the URI in my Helpform which loads the Help page will locate this file.
(I expect the HTML file should live in the directory pointed to by the:
My.Computer.FileSystem.SpecialDirectories.CurrentUserApplicationData property)
how to specify the Project settings and Publish Wizard etc. (& whatever else is necessary) in order to achieve the above.
View 3 Replies
Jun 22, 2011
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.
View 2 Replies
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
Jul 2, 2009
Deploying Winforms Application to Client Machines Application Failing on start
View 8 Replies
Mar 12, 2009
how to load a .bak file of database backup in sql server 2005 using vb.net 2008 windows application?
View 5 Replies
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
May 31, 2010
I have made a Database application using SQL Server 2005 and Visual Basic (V Studion 2005). The problem is: the SQL server name on my PC is different from the name on my brother's PC.....i want to run the application in his PC......however, all database adapters, objects i have used are linked to my SQL server...hw can i run my application on my brother's PC, with minimum changes and effort?
View 4 Replies
Jan 24, 2010
I have prepared an application which uses SQL Server 2005 Express Edition as its database and Reports using Crystal Reports which comes integrated with VB .net 2008.I am able to package and deploy my application alone. To the system where I am going to install doesnot have SQL Server or Crystal report runtime files.I want to include the same in my package so that it gets installed and followed by my application.I have chosen install application from the same location and tried to package it. It doesn't work.Please suggest me steps so that I can have the required softwares packaged with my application so that the user when he installs, it installs at one go.
View 5 Replies
Nov 26, 2009
I have deployed my app no problem on my laptop that has .net3. I want to distribute my app to office xp nodes. This there a way of deploying an application to use .net2 instead of 3?
View 5 Replies
Aug 5, 2011
Im wondering if anyone would be able to point me to a very well detailed tutorial as to how to Embed a font into my deployed application , So when its installed on an end user,s computer, they can see the font.
I currently have this code and have embedded the font.ttf into the resource under the files option.
newPDF.addTrueTypeFont("..
esources" & fontName & ".ttf", fontName)
View 11 Replies
Aug 11, 2010
i'm tying to send email in my application directly by the smtp server but the server doesn't allow me to do that.The application its used by everyone in the company, so i set the smtp client UseDefaultCredentials to True, but the server replies with this when i try to send an email:[code].....If i set the credentials by hand, the server sends the email. So my problem is how to make this work to everyone? I don't want to have one public/friend var all time in the application with the credentials of the current user?
View 9 Replies
Apr 6, 2012
Case : I'm creating an application (desktop application) with VB.NET (actually windows form), and using SQL Server Express 2008 for its database.
[Code]...
View 1 Replies
Aug 31, 2010
When a user click the .msi, i want a folder called "Your Files", which comes with two small images by default, to be created in C:UsersYourNameDocuments. In short, MyDocuments.
What i did is put the following code in program.cs:
string myDocuments = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
string downloadArea = System.IO.Path.Combine(myDocuments, "Your Files");
System.IO.Directory.CreateDirectory(downloadArea);
Just before:
Application.Run(new mainForm());
The problem is, this folder will be created every time the user runs the application which is not a good solution, also in this case there is no place to load the two images so it can be loaded while the folder is created. I want the folder to be created once preferably while installing the application, so even when i uninstall the folder "Your Files" and its sub files be deleted automatically along with the program files. I tried to do it via Setup Project, but i couldn't.
View 1 Replies
Oct 8, 2008
I have a project that uses a crystal report and I'm planning of deploying it.The problem is, is there a common setup for the components that was used in my project so I don't need it to manually register on the client pc?
View 2 Replies
Sep 17, 2010
Trying to deploy an application written in VB.NET. First had an issue with not including the PowerPacks (what is in this anyway?) but that went away and the application installed correctly once I included it as a prerequisite.Now however once the user logs into the application the main menu just bombs, doesn't even load, the app just quits. I suspected it was the DataGridView and had those suspicions confirmed when I changed the application's startup form to one without the grid.
View 2 Replies
Jun 6, 2011
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.
View 1 Replies
Apr 8, 2010
I've made an application in VB.NET which uses MsExcel that runs without any error on the PC where .NET it's installed. But on another PC the build executable occurs an error system.invalidoperationexception The .NET FRAMEWORK that needs the application it's installed,But Ms Office is not installed.
View 1 Replies
Aug 26, 2011
When depolying a Windows Application with a CD How does one depoly Folders, with a large number pictures in them, along with the program that uses them!Further, when having the Control Panel utillities Uninstall the Program, how can you get it to remove the Folders containing the pictures along with the program that was installed with the pictures, assuming you can do so in the first place?Do not suggest using C or any other laguage please!
View 9 Replies
