Not Getting Data Access After Publishing Project
Mar 21, 2011
I want to publish my vb.net project, but when I publish the project, there is no access to database. It is showing error : "System.Data.OleDb.OleDbException: Could not find file 'C:\Documents and Settings\Administrator\Local Settings\Apps\2.0\N3WEXXZN.DE6\JHJXMQC9.9N6\mara..tion_c355efc190f94c5f_0001.0000_d27846b1540f4a39\EventsTable1.mdb'."
I am giving connection string as
"Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & My.Application.Info.DirectoryPath & "\EventsTable1.mdb"
OR
"Provider=Microsoft.JET.OLEDB.4.0;Data Source=|DataDirectory|\EventsTable1.mdb"
Why this error is occuring? Is there any other way to provide database path?
View 7 Replies
ADVERTISEMENT
Dec 20, 2011
i am trying to publish a vb.net project that has is connected to a database. the project can be published and installed and runs fine without the data base part. i get following error message: System.Data.SqlClient.SqlException (0x80131904): 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 connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
i assume that it simply cant find the database. where do i need to adjust the database file settings to make this work.
View 3 Replies
Apr 8, 2011
I have added some files that I need to be downloaded to the Application start up path. So I set Build Action as content now the files have been copied some where
C:Documents and SettingsTestUser.ANNAMLocal SettingsApps2.0DataHVDRBMY5.8AA858AT9VM.TNP est..tion_2d7cfc137d9c2c74_0001.0013_432bd4561850d290Data
How can access file from the application. My problem since it is a dynamic path will it be same folder count so that we can use like ....Data Some think like this
View 1 Replies
Sep 5, 2006
When i use the 'Publish <ProjectName>' feature in VB .NET, a setup file is created. When u run the setup, u cannot specify where u want to install ure program. Is there any way to change that.
View 5 Replies
Sep 5, 2011
This problem suddenly arose after several months of successful publishing.I am still able to build the project.
[Code]...
View 2 Replies
Dec 21, 2009
i went up to "Build > Build Project" then "Build > Publish Project." So I went to the director i published my project in, and I ran Setup.exe, I followed as prompt, and then when the Splash screen unloaded, the project stopped responding and closed. So I ran the debug on VB8 and it ran fine passed the splash screen. Then, I tried going to the debug folder, and run the project from there, it ran fine to. So I tried another solution. I copied, and pasted the .exe file in the debug folder to my desktop, along with the .dll files in the debug folder to, ran it, and it got an error instantly after running it.So the only way I could get it to run, is to leave the .exe in the Debug folder, and to run Debugging in VB8.Also, I really don't like the way VB8 publishes the files and you have to run the setup each time you want to run the program. Is there a way to just make it a normal .exe file, like the ones vb6 makes?
View 11 Replies
Jul 8, 2009
I have created a small project which also interacts with a mdb.It works great on the PC where it was created.However, when publishing it on my home network it asks for the first path. It lets me input the first path "where do u want to publish the project" successfully. When clicking next it brings up this form:
[Code]...
View 1 Replies
Aug 30, 2010
I have a project and I'm publishing it with ClickOnce. As it publishes, it asks: "Version 1.00.xxx (etc) already exists on the server, do you want to overwrite it?" -- well, I click yes, and then I run the setup file and install it (I publish to my desktop), and guess what -- it's the old version of the project.For some reason, unless the version that is published is greater than the prior version, even if I tell it to overwrite that version, it is not published properly!
This has caused me some headaches, as I test my program on another VM, find errors, fix them in code, republish, and find the same bugs in my program as I test it again because it didn't publish the latest or newest version of my program, I even tried the simplest thing, I changed the text on my main form window that opens to something different from previous, and no matter how many times I publish, and click overwrite the old version, the old version remains!
View 2 Replies
Dec 7, 2009
I'm trying to publish a project I created to a network server using the Publish Wizard in VB 2008. The project publishes to the specified path but I try to install the application I keep getting this error..
View 2 Replies
Mar 18, 2009
I am trying to publish a project. Via the publish wizard I have published the project. So I have:Project.applicationSetup.exeand a directory application files in which:Project.applicationProject.exe.deployProject.exe.manifest. When I start the setup it does it's thing (only one question: do you want to install ...etc) and 2 seconds later its done.
Problem:
1. I can't find the installation directory... (I can find the app in the 'add/remove programs' but not anywhere in program files or ..)
2. there are a few xml and mdb files I want to include in de project (or else the project does not work).
But because of (1) I don't know where to do so. Or beter yet, I would like to include these files in the installer.3. Why doesn't the installer ask me where I want to install?
View 5 Replies
Apr 22, 2011
I am using an Access Database with my project. When I publish, all the Forms seem to Publish. Also the database gets published. However, once I install it, there seems to be no connection with the Database.The Forms give me the Oledb error as Im using Access. However, the login form seems to connect with the database. In other words, my applications gets authenticated, but when I try to open other forms, there seem to be an error with DB connection
[Code]...
View 1 Replies
May 22, 2009
About publishing my program. there's a lot of files made after publishing unlike in vb6 when i converted it to exe file theres only one file. hmm how can i make just one exe file in vb9 is it possible? another question do i have to install the program after publishing?
View 5 Replies
Oct 21, 2010
I have a web site project in which I added a "Class.vb" file to hold public functions/procedures/variables. I'm trying to access a function within this file from my code-behind file from an aspx page. I've called the Class file "Module1"; Publc Class Module1.[code]...
View 3 Replies
Feb 24, 2010
I have a database that works fine when not yet published, I connect this way: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Network_Info.mdb" But when I publish my project my application can't find my database and I always get an error. Any solution to this matter?
View 4 Replies
Nov 23, 2009
I am new for working with vb dot net. I have developed sample project with Ms.Access data base and some pictures I have a doubt on how to package. If you have answer ,sent me a step by step procedure. I have to some custom installation also.
View 1 Replies
Feb 1, 2011
After trawling around the net for a good few days, i decided to post something here.
Basically, i've got a problem linking a data source (Access 2007 database) to a VB 2008 project.
I've broken it down to having a problem dragging a table onto my form, when it generates the nav bar, it says "0 of {0}", and the table is empty (despite the actual database containing values)
However, this happens only at home, at college it works totally fine. The only difference that's obvious is that i'm using Windows 7 at home, and Windows XP at college.
View 2 Replies
Mar 10, 2011
there is another problem in my system.... after publishing my project, i find that my data in datagrid view is not updated as in the ms access database i wonder why.... here i gave my coding
Private Sub Form6_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.REKOD_PELAJARTableAdapter.Fill(Me.LcrsdDataSet4.REKOD_PELAJAR)
[Code].....
View 10 Replies
Jun 26, 2011
Using: VB 2008 Express?I created an application that connects to my MySQL, and everything works fine, but...
1. On my development computer, Windows 7, 64bit, I add the MySQL.data.dll file as a reference. I publish the program, run the setup.exe, and sucess.
2. I then copy my published folder to my test computer, Windows Vista 32 bit, and upon running the setup, the program fails to work because it cannot find the Mysql reference.
3. I then transfer my entire project over to my Vista computer, publish the program, run the setup.exe, and sucess.
4. I finally found out what was happening. My Windows 7 comptuer was not including MySql.Data.dll.deploy file in the Application Files published directory; but when I compiled it on the Vista machine this MySql.Data.dll.deploy was included.
So, in the end, I cannot compile the program on Windows 7, because it fails to create the .deploy file, and use it on Vista or XP (for some reason Win7 doesn't need this .deploy file?); but I can publish it on the Vista machine and install it fine on Windows 7, Vista, or XP. My targe CPU setting is Any computer.
View 3 Replies
Oct 10, 2009
how to do the followings when creating the Set-up project for a program I created.The Page which appears when the "Setup" project is successfully finished, shows a menu bar in the "Solution Explorer". The "Custom Actions Editor" gives a list of (1) Install, (2) Commit, (3) Rollback & (4) Uninstall. I couldd do anything on this. Why these folders are there? How can I use this to create an "Uninstall" utility? What are they meant for? 1) How to include "Uninstall" part for aa program? (I want it appears in the Program menu on moving the Cursor on the Program. 2) How to create the "Uninstall" for a program?3) I couldn't make my program to appear in the list of Program Menu after installing (I'd to make a "Shortcut" of the program in the Program Menu), it didn't appear in the Desktop also - again I had to make a Shortcut on the Desktop also manually.The Tutorials didn't explain anything about this but only showed these options are available.
View 1 Replies
Apr 28, 2010
i have a problem where i've hard coded the file path of an access database i'm using with a VB.net program. this means that if i publish the program the database doesn't publish with it and i have to "ship" the program with the the database file separately and create another form so the user can say where the file is held. i don't want to do this.is there any way to get the access database file to publish with the program and then access that file path by code? for example the database file is held in the same folder as the installed program and then is accessed by code so there is no need to use a specific file path.
View 1 Replies
Jul 26, 2009
I have a multi-project .NET 3.5 solution. It's ASP.NET based with c# code-behind in all projects except one.I'm attempting to access members from a C# project called "Core" from a VB.NET project. I set a dependency to the Core solution in my solution properties. However, Core. brings up nothing. Furthermore, my other C# projects that have Core-Project as a dependency (in the solution settings), are able to declare Core objects. Example: Private Core.ObjectName InstanceName; Also, Intellisense brings up plenty of info in the C# projects.how I can hook into these members from my VB project?
View 1 Replies
Feb 16, 2010
I have access to a database table that has been added as a datasource in project (A). Is there any way to refer to this database table from project (B) WITHOUT adding it to project (B)'s datasource?
ProjB.databasetable.GetDataSetSchema
View 2 Replies
Feb 16, 2012
I'm using VS 2010, and I did a project using VB and a database in Access. The problem is that when I try to put that "application" on other computers, sometimes, is not working. I thought it can be because on these computers they don't have access, but on one computer, is running another app which is using Access and there is no Access installed. How can I check if my application requires Access to be installed or not?
Here is a example of how I did the connection:
Public AccessOLEDBConnString= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & myfullpath & ";Jet OLEDB:Database Password=password"
Function getConnection() As OleDb.OleDbConnection
[CODE]...
And when I want to have access at the data I'm doing like this:
dim conn as Oledb.OledbConnection
dim sql as string
dim ds as Dataset
[CODE]...
View 9 Replies
Aug 15, 2011
I have two projects: SQLtesting and Controls. Their physical locations are:
[Code]...
View 5 Replies
Aug 15, 2011
I have two projects: SQLtesting and Controls. Their physical locations are:
C:My DocumentsVisual Studio 2010ProjectsSQLtestingSQLtesting [forms reside here]
C:My DocumentsVisual Studio 2010ProjectsControlsControls [forms reside here]
The code shown below works fine. I run it from the project SQLtesting. It loads a listbox and a checkedlistbox with the controls found on a form. I can change the value of the FormName field to any form within the SQLtesting project and get the form's controls. The forms are not actually opened/shown.I would like to be able to access forms in other projects i.e.
C:My DocumentsVisual Studio 2010ProjectsControlsControls
while running the code from the SQLtesting project.
Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click
Dim <strong>FormName </strong>As String = "Form1"
Dim FullTypeName As String
[code]....
View 4 Replies
Dec 10, 2009
I�d like to pass data from my VB 2008 project to data fields set in Word. Can it be done and if so
View 10 Replies
May 3, 2009
i have 2 projects in my solutioni want these project to access the same dbhow can i know the path without hard code it?????
View 7 Replies
Jan 25, 2012
I have written a small project that saves data in a data set, this part works fine, but I have some errors with the code I have written for importing excel data to the datagridview and exporting data from the data grid view.
This is a test project for me to learn how to do this stuff, so I will post the code for the entire project so you can see what I have done from start to finish.
[Code]...
View 3 Replies
Oct 11, 2010
I am working with VS2005 using VB.net I have two project (Project A, Project B), project A is the startup project with form1, while project B is dependent on project A, both under the same solution. I have established the project dependencies so that Project B is now Dependent on Project A. Also i added references to both projects to each other so that i can access controls on Project B forms through Project A (Like changing the value of a textbox on B through A). My problem is that whie trying to access controls on Project B Forms it doesnot show up.
[Code]...
View 10 Replies
Dec 3, 2011
I'm just starting to explore VB.NET datasets but I'm stuck on a (probably) trivial problem.I have declared a dataset (let's call it 'Fred') as public in a VARs module.In the main form in a sub routine called at the start of the project I connect to an Excel spreadsheet and read it into the 'Fred' dataset into one table (called 'Table')I then bind the dataset table to a datagridview and I can see the spreadsheet. Which is very nice :-)
Having loaded the dataset I want to be able to get some values so I created a button and used the following [code]....
View 5 Replies