I have made a small app with a SQL Database, published and installed it on my desktop pc with the express version.What directory does .net place the database in that has been installed.
View 3 RepliesIn the past I have written VB6 and VB NET 2005 programs that are installed and on the user's computer. This had to be done because the salesmen in our company have has a set of local data on their laptops so that they could do work and not be connected to our network. I would then sync the files when they connected to the network. (This same program is used by the rest of the company as well, but everyone else uses network data.)We are now at the point where we are not using any local data. Our salesmen access our network data using an iPad, VPN, and a Citrix server, which works fine
View 2 RepliesI have published a vb.net application and installed it on my PC. When I try to locate the installed application, I dont find the location where its been installed.
How to install a publish application on a specified location in C:Program FilesProject?
I put database in bin->debug and i also call from that folder using DataDirectory Business_Card_Database.accdb when i publish the project database not found error is occur note I also tried
1. System.IO.Path.GetFullPath
2. Application.StartupPath
3. System.IO.Directory.GetDirectories
Above all are not working to find database after published I'm using
1. vb.net 2010 express edition
2. Access database 2010
I have connected my vb .net forms to the MYSQL database but when i comes to publishing, i do not get the database on the published application.
View 4 Repliesdim cn as oledbconnection
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:valid.mdb")
[code]......
I have a vb.net application that will not connect to an oracle database on the PC that I publish the app too. It works fine under my pc both in design and when I publish it to myself. But it will not connect under the pc I publish it too. I do have oracle installed on the pc and have the connection setup exactly as I have on my own pc. I am sure it is a file path issue, or at least I believe it to be that.
View 5 RepliesI have the same problem as in this thread [URL].
I am connecting to a SQL database on a hosted server and everything is ok but if I publish the application then it fails to connect which is a bummer because then I can't debug it!
I have tried turning off windows firewall and that doesn't make any difference.
My project which includes an access database is published for distribution on a CD. The database properties are set Build Action - Content, Copy to Output Directory - Copy if Newer. I need to be able update the published project. I have used ClickOnce Publishing Process.
View 1 RepliesWhen I publish my program I get no errors, and then when I install it on another machine it says it gives me the error that it can't read the txt file that it stores data in. If I hit continue it also fails to read the database. The database file is stored in the bin/debug folder and I told my program to include it when I first added the data connection. Anything I can do to have these included so my program can run on other machines?
View 6 RepliesI am going through a problem, i want to add some dll in my Project from another location.
Scenerio:
1-I am using a third party control
2-Installed it
3-All dll are in reference list, if i add them from their default folder and make local copy true,it works fine
i want to add them from "MyFolder"??How to refer them in my project?? current it gives error like
"could not load file or assemblies..*.dll.."
I need to process a text file created by a Streamwriter. I have the Streamwriter object but the file location is determined by the user. The problem is, I need to process *the file* not the contents-so I need the location.
Steamwriter doesn't seem to have a Location or File property. Or am I just missing it? How can I tell what file a Streamwriter object is writing to?
I have a little problem here, when I point my mouse or move them around on the panel location, nothing have happens so far...
Form1
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
[code].....
i been creating a project for school that requires me to access a database for username and passwords
I have no problem doing this, but only if i "hard code" the location of the database.
[code]...
The user will enter a folder name in the combobox1 and clicking the create folder button the folder will be created in the applications bin folder; For doing this, i did this
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If ComboBox1.Text = "" Then
[Code]....
Now when the user enters a file name in the combobox2 and clicks the save button(Save button is not shown in the snapshot) then a .txt file with the name entered by the user in the combobox2 will be created in the folder whose name is specified in the combobox1.
So I have a string that I need to search through for certain strings. If they exist, then copy that string to a text box. There has to be an easier way to do this then what I have below
[Code]...
why error "Index and length must refer to a location within the string."appear when the process of the program is going to executeNonQuery, i'm looking the error for 2 day's i still can't find it.
[Code]...
I use VB2008 and database access and Crystal report.my problem : when ever I change location the database. I will always change location in my report from crystal report. It's very difficults and waste the time because I have many report. how to set up location only 1 place and impact to many report.
My VB Code :
Dim dbname1 As String = "D:AF_SoftwareDBDBAF1.mdb"
Public Strcon As String = "Provider=microsoft.jet.oledb.4.0;data source=" & dbname1 & ";jet OLEDB:Database Password=999"
make code in crystal report , if i want change drive to drive Z / or somthing else.now, i am go to the report and click change location.
I am pretty new to the vb community and very new to this forum. I am glad I found this place too because its an extremely helpful place due to how much time a lot of you have put in helping others and such; great work.
Well on to my question that I wasnt able to find out exactly using my search. What I want to do is use opendialog to select a location to an access database and then take that location, and use it to update my connection string db location. Would it be possible to edit the path at runtime like that using an opendialog? Also, if that is possible, would it be able to save that location to the program so that I wouldnt have to be edit again. The reason why I just dont hardcore the location into the database is because there will be many different computers that the program will be installed into and the person I am making this for wants the flexibility to move the database around at will.
In my database I have this "C:UsersLauraDesktopUni AnimationBluedot.gif" in a table called "images" and within a colomn called "image" I thought this code would work but I don't understand the error message I am getting. PictureBox1.Image = ds.Tables("Pipelining").Rows(inc).Item("image") If anyone could give me a hand that would be good
View 2 Replieswhy when i upload less than 10 item the program do but more than it like 15 and above the program give me error saying "Index and length must refer to a location within the string."
here is my codes below
For Each myDatarow In tblLocal.Select("sync ='0'") '
' tblServer.ImportRow(myDatarow)
' dataimpt = myDatarow.Item(4).ToString
[Code].....
the error appear when the program is going to update the 14th data... meaning from 1st to 13th data program works in the 14th it's not it gives me error "Index and length must refer to a location within the string
i am having a trouble about adding a file location (e.g. c:/bla/blahblah)to a database i have my code here
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\WindowsApplication2\Database1.mdb"
AxWindowsMediaPlayer1.settings.volume = 100
[code]....
everytime i add a mp3 file to listbox it should get the file location and pass to the database but it seems my database is empty?
I want to Backup my Database to a location and restore it afterwards. The problem is , i want to keep my program open. I seem to have a problem with this, the connection stays open. How can i do this , close connection and open it again without data loss?
View 7 Repliesi am using b.net 2005. i am generating a crystal report. but when i work in a different computer i have to set the location of the database of the report before i generate. is their any dynamic way to set my database location to the report.
View 1 Repliesi am generating a crystal report. but when i work in a different computer i have to set the location of the database of the report before i generate. is their any dynamic way to set my database location to the report.
View 2 RepliesI often need to change the location of my Access database. Since ini files are outdated can I create a dll file to store the location?
View 4 RepliesI need to change my [code]...
if i change it under settings it is working but i want to be able to change it in my running application, or when the application is opened for the first time i should be able to put in die path for the database.
I am developing a vb.net windows application with crystal report and ms access. My database is stored in bin folder. I cannot bind database to report after deployment. How can I set the database location in report?
View 3 RepliesI need my program to connect to a database within my application i.e.What I have:
m_cnADONetConnection.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source = C:Documents and SettingsmeroneyfMy DocumentsVisual Studio 2008ProjectsAsset Manager 2008inDebugDatabaseAssetManager.mdb"
What I need is: m_cnADONetConnection.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source = DatabaseAssetManager.mdb"
I have used:System.Windows.Forms.Application.StartupPath & "ImagesSystemDefaultImage.bmp"
for loading of images within the default directory. but this returns the app path but also includes "System.Windows.Forms.Application.StartupPath" in the string?
i am using an unbound datagridview so i can dynamiclly add rows. all that is working fine. but the grid is not is the location i have coded.. i am using the defualt form as a base then coding the unbound stuff in.. should i just create a blank class file and do everything? the only problem i am having is the grid must bees in the correct location according to the pixel point that i have given it. Right now it is placing the grid at point (0,0) no matter what point is entered on the line for location. so what am i missing??????
View 3 Replies