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
View 2 Replieshave 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.
View 1 RepliesI'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?
[Code]...
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]...
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 RepliesI 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 RepliesI 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?
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 RepliesIs 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.
just want to ask what would be the possible code if there are no records in database.. example when you click search.. then there! well.. here is my code
[code...]
I have two textboxes and 1 button ...
i m doing when i enter travel id in textbox1 and click on button1 then in textbox2 i retrieve the travel agency name according to the travel id i entered in textbox1,
I want when no record is found according to the travel id i entered in textbox1 then in textbox2 it shows the message no record found ...
this is coding i use to retrieve record in textbox2 by enter travel id in textbox1 : have a look ...
re-edit this code according to my query above :
Protected Sub Button4_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim SQLData As New System.Data.SqlClient.SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User
[Code]....
After adding a UserControl to a form which access my database I get this warning:
Warning1The database file cannot be found. Check the path to the database.
[ Data Source = C:Program Files (x86)Microsoft Visual Studio 10.0Common7IDEDatabase.sdf ]
C:UsersUserDocumentsVisual Studio 2010ProjectsProject1Project1Options.Designer.vb2160
Thing is I never had a database at that location, my database is and has always been in MyDocuments in the Project folder itself. There is nothing anywhere in my code referring to that database! When I double click it I get sent to this line in the Designers window:
Me.Controls.Add(Me.BoxControl1)
Even though I get this error I can still access my database, so basically it does absolutely nothing except drive me mad! So how do I fix this?
We have an VB.net application that is being moved from one box to another. It runs great on the old box. The new box is configured the same as the old one but is on newer hardware. When I run the application on the new server it complains that the adobe toolkit that we use can not be found.
View 2 Replieshow to show error msg in literal if no record found in database according to the text entered in textbox1 and textbox2 else if show record in gridview if the text entered in textbox1 and textbox2 will be found in database ...
View 1 RepliesI am using VS2008 front end and MySql 5 database When I attempt to run this sproc I get the following error message:"Procedure or function 'Test_sp' cannot be found in database 'EVOLUTION'." Yet the Stored procedure is definitely there.I have tried changing the name of both the sproc and in the sub below but it makes no difference.This is the first time that I am trying to use a sproc and I can't get it right.All other communication to and from the database is fine.
Dim Cmd As New MySqlCommand("Test_sp", Datacon)
Cmd.CommandType = CommandType.StoredProcedure
Cmd.Parameters.Add("@Acl_Key", MySqlDbType.String).Value = "ABC"
Cmd.Parameters.Add("@Acl_Desc", MySqlDbType.String).Value = "My Description"
[code]....
I recently upgraded my system to Windows 7 64bit and ever since then I have had nothing but issues with my code attempting to access an Oracle database. I was using msdaora for my connection string however that does not work in 64bit. I changed over to OraOLEDB.Oracle which everything I can find on Google says to use however it fails every time. I have installed Oracle 11g 2 times now and even tried reinstalling VB.net 2010 and still no luck.
Here is my connection string....
Code:
MyConn.ConnectionString = "Provider=OraOLEDB.Oracle;Server=emsp.grhq.XXXX.com;Data Source=emsp;User Id=XXXX;password=XXXX"
And I am inporting....
Code:
Imports System.Data.OracleClient
Yet when I try it says...
Quote:
Provider cannot be found. It may not be properly installed.
I've made an application and it connects to my database. But the issue is the details of the database can be found out through packet logging or something. How can I stop this from happening and secure it, without having to have a third party such as PHP script etc.
View 1 RepliesCurrently I am using this code to check for Firefox on a 32 bit machine
Code:
Dim Firefox32 As String
Firefox32 = My.Computer.Registry.GetValue _
("HKEY_LOCAL_MACHINESOFTWAREMozillaMozilla Firefox 5.0in", "PathToExe", Nothing)
MsgBox("The value is " & Firefox32)
If the value is found then the above message is fine, but if the entry is not found I want it to display a message like: "Firefox could not be found" instead of "The value is: " What code would make this appear?
[Code]...
I have writen a program using vb.net 2005 and used SQL Server 2000 as the database. I also used DataSet to process the records. When I try to run the program on a peer-to-peer network it fails and returns the error message
System.Security.permissions.FileIOpermission, mscorlib, version2.0.0.0, culture = natural, PublicKeyToken = b77a5c561934e089
Then on the dialog box there was OK button when click on it, the error message
System.Data.SqlClient.SqlClientPermission, System.Data, version2.0.0.0, culture = natural, PublicKeyToken = b77a5c561934e089 failed
Was also displayed.
i would like some advice on how I would go about deploying my application I coded with vb.net and access.The problem I have been facing is that I cannot install it on another machine . It gives me an error saying that It cannot find the database in C:\Users\Weighbridge2\AppData\Local\Apps\2.0\Data\. database.accdb when you install access runtime and access runtime sp1 and copy the database to that location then it works.Is there a more efficient way of going about this. I suspect it has something to do with the refferences and prerequisites but up to now i've tried almost all we know .
View 1 RepliesI have designed a simple form in vb.net with MsAccess as the backend .The form is used to search for a data and diplay it.I need to create an .exe file of it and distribute it to many users without any errors .I have surfed a lot in search of deploying such applications but ended up nowhere . deploying my application(VB.NET with MSAccess) by detailing me all aspects of deployment ?
View 6 RepliesI have just completed an app, but i dont want to inculde the redistributable framework... What .dll(s) are required with the apps(so no framework is required)
or can i just integrate framework and my app into 1 setup.exe.
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 RepliesI 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 RepliesI am developing my application using d3dx functions. but when I deploy it to a fresh PC (which has no SDK installation) it doesn't run.
View 1 RepliesParser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
[Code]...
I built this vb.net windows application that uses an Access DB for data storage and it works fine in visual studio. The problem is, when I deploy, install it from an MSI, i get this error: (see below)If I right click on it and run this program as administrator, it works fine. I thought it was a permissions problem so I gave user, administrator and system full rights to all the files in the directory. But I still get the error.Isn't giving all the files in the program directory full rights the same as making it run as admin?
[code]...
I have developed an application in vb.net.I use a dll that I build as part of a different project in my solution. For some reason I don't get the full functionality of my application with the dll built as a "release" version, but it does work if the dll is built as a "debug" version (that's a whole different problem).I don't have a problem, for now, using the debug version.However, the problem I'm having is I am trying to deploy the application to another system and if I deploy the debug version of the dll I get a runtime error (see below).I have the .net Framework installed. I'm just wondering what has to be installed in order to allow me to use the debug version of the new system? [code]When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.
View 1 RepliesI have a project that uses web references to make SOAP calls to several web services. When I'm working locally, the services are hosted on my local machine, so the URL of each web service is something like [URL]. When I deploy the project to a server, the URL needs to change to the production URL. Currently I am accomplishing this with a prebuild event that does a find-and-replace on each URL and overwrites it with the deployment URL before deploying. Surely there is a better way.
View 1 Replies