I am on a general scenario of deploying my vb.net database application on my client's computer.
Thinking of future problem of changing the database connection setting, i am planning to store it in a normal xml file in the app directory so that where ever it is installed, in order to make database configuration i only need to make change to that file and my program runs smoothly.
So is this idea of storing database connection setting to xml config file in app directory or is there any other better idea?
I have an application running with a access db. I have written some code to copy & zip the db file to another location (selected by the user) for the purpose of backup. (I am using sharpzipwrapper)Whenever I try to run the code for the copying & zipping it gives me an exception saying that the file cannot be zipped as it is use.Do I have to close all open connections in order to backup the .accdb file? If yes then how? else what do i have to do inorder to get 'access' to the file.Do I have to exit the application to close all connections? These connections are written in code for e.g. :
Using VB.Net and SQL Server 2008 R2: I have recently had a database that using sp_who2 reflects a connection ".Net SqlClient Data Provider" is still active even though the .Net application has closed and disposed of all connections.
i've been previously using Visual Studios built in wizards for manipulating data access to and from an MSAccess Database, however just recently i coded my own classes and connections to the database, ive been able to select, update and delete records effectively however my problem comes with inserting records.
I have a 3 tiered table database:Tbl_PO, Tbl_Parts, Tbl_Shipments each po has multiple parts, each part has multiple shipments.when i insert a record into the tbl_PO, i need to retrieve the ID used on that insertion.
I'm doing an application which uses the Database Wizard to link the textboxes, labels, and combo boxes to the data base. (Visual Basic in Visual Studio 2008). (Visual Basic 2008 by Shelly Cashman-Chapter 10)There are two problems: One of the combo boxes has the unique key identifier. You are supposed to be able to use the combo box arrow to select one of the unique keys. Every time I click on one of the unique keys to see the records connected to it, VB acts like I'm trying to input a duplicate key. My teacher hasn't been able to figure this one either. If I was connecting the code, I could fix this but I have no clue since I have to use the Database Wizard on how to fix it.
This may have been answered but my search hasn't found what I was looking for. Basically, I am developing an application which allows the user to build a query at design time, i.e. for users with no prerequisite knowledge of SQL The application thus far allows the user to select which table(s) from the database they wish to start querying (I won't go into the details of the rest for now)
My confusion is this; I already have the connection to the database in a subroutine which obtains the schema information and filters it to display only the available tables within the database, which then compiles the data into a listbox, here is that sub:
I have implemented the filestream feature of SQL Server 2008 in a VB.Net application. I can insert files, and then retrieve/view them just fine. However, I have huge problems trying to update a file. Eg. The user selects a file from the grid which I execute via process.start. If that file is a .txt file, the user may choose to edit it. In case that happens, I need to save the changed file back to the database. So far I have failed to do that.
What I do, is take the retrieved file, copy it (cause i got some errors about it being used), and then Process.Start it. After that, via .NET filestream, I convert the file to bytes and try to update the record. SQL Profiler and a manual SELECT on the varbinary(max) column tell me that the file is updated properly, but the very next try to retrieve it I get an unchanged file.
After that I also tried to update the file by changing its File-System Version, but the file still wouldn't seem to update. Does Anyone have a code sample of how I can achieve this operation? Like 500 sites on the internet have examples of how to Insert And Retrieve the file, but not a single example on how to update. This is how my second attempt of trying to update the file via the filesystem looks like. The code for inserting/retrieving is very similar and it works properly. [Code]
I have an multi-database ODBC connection through a DSN. There is a primary database and two auxiliary catalogs. The Add Tables dialog in Microsoft Query only shows the tables in the primary database. If I pick one and continue on, the lists of columns in other parts of MS Query show all the columns in both the primary and auxiliary databases. If I pick a column, MS Query will look for that column in the primary database (great if it happens to be there, not so great if it doesn't). If I don't use any of the drop-down lists and just write a query in the freeform SQL editor, fully qualifying everything with the catalog names, the query runs fine.It looks as though MS Query is assuming only one database and one (default) catalog, and doesn't realize that it actually connected to several databases with separate catalogs.I get the same results with Office 2003 and Office 2007.Are multiple databases / multiple catalogs through a single DSN supported in Excel / Microsoft Query?
I'm running a program where I call a function which creates a database connection and then runs a stored procedure. I call this function four times from four separate threads. I get an error (Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.
Exception Source: .Net SqlClient Data Provider) when I use multiple threads, but if I have the threads run one after another I have no
I just want to know, What parameters or attributes should be taken in connection string so as to handle high traffic enterprise applications? Like in general we use server, initial catalog, userid, passwd. Some times we add timeout , and in some scenario pool etc. But i don't know what attributes should i take in as my common practice apart from above.
I am extremly new to this concept of aps.net and vb. all the tutorials I see are c# based or very basic for vb. What I have is a contact forum with some basic information. I got the whole "check if the user has input information correctly down pat how ever Its this whole, connecting to a database (sdf) if in another vb file ands calling that method into aspx file and proessing forum input to say "take this, insert into bla..." I come from java, JSP and J2ee bak ground where its not that diffrent and I dont have all week to read books and take baby steps. I have until tuseday morning to finsih this. Right now I am as far as forum validation....
I want to save a zip file at a sql database. I tried to to the same like saving txt files, but if I want to open the saved file (it was created from a stream) the zip file is corrupted!
Saving zip file as stream Dim fs As New FileStream(tmpPfad, FileMode.Open, FileAccess.Read) Dim bytData(fs.Length() - 1) As Byte fs.Read(bytData, 0, bytData.Length) fs.Close() Dim i As Integer [Code] .....
I have an application which connects to a database, retrieves a username from a user's table and matches it against the username retrieved with System.Security.Principal.WindowsIdentity.GetCurrent.Name.On my localhost, everything works fine. The database exists on the development server but the application lies on my localhost. All of my authorization and authentication techniques are running smoothly.However, when I publish my application to the development server, I'm faced with the following error.Cannot open database requested in login 'databaseName'. Login fails.Login failed for user 'DevelopmentServerNameASPNET'.
Join Date: Dec 10 Posts: 10 caba11 is an unknown quantity at this point (<10) How to save binary file to database. Ineed to save files into database. I cant find why it is not working...
This is my code: Public Sub importfiles(ByVal sFileName As String) Dim cnSQL As SqlConnection Dim cmSQL As SqlCommand Dim strSQL 'Validate form values [Code] .....
Without try it says "cmSQL.ExecuteNonQuery()"-"Failed to convert parameter value from a DataGridViewTextBoxColumn to a Int32."
I have everything done, but I forgot one simple little thing, how to save the database to a textfile, I have two forms with this application, the first one has all the information in it (textboxes) and a listbox in it to see all the contacts, then the second form has all the textboxes (contact ID, First name, Last name, telephone, address, city, zip code, and email) that the user can put information in and hit add item to add it, it has a save button that will save it to the application, but I forgot to add a save button so it saves to a text file and loads from a text file,
i know how to save a text file to a sql database, the problem is on when will be the process is executed because i need to monitor the operation of an existing system..
I have a java class that is used to for ssl connections to a web server. I have got some of it converted however there are serveral java libraries that i have been unable to figure out how to call or reference in vb.net. First off i'm not even sure if it's possible to reference them
This is what i need my program to do...I have a form with 1 textbox and 2 buttons (save and load) If i type information into the textbox and then click save, i need it to encrypt the text first and then save the file to database If i click the load button i need it to decrypt the file and display the decrypted data into the textbox i just need a way to save my text files so the information inside them cant be changed without using my program but yet again i find myself at a loss as to how i do this.
I'm using VB Express 2008 in Windows 7 64-bit. I'm working on a project with a datagridview bound to a MS Access 2007 database. I want to use the datagridview to add, delete and update the data in the MS Access database. When I added the database file to the project through the Datasource Configuration Wizard, I selected 'No' to copy the file to the project folder. The connection string automatically placed in the project settings is: Provider=Microsoft.ACE.OLEDB.12.0;Data Source="F:My MoneyDoBillsDoBills2009.accdb"* The 'Copy to Output Directory" property for the DoBills2009DataSet.xsd is set to '*Do not copy*'(and I've tried every other setting available). So, as I understand it, I am working with the original file, not a copy, and any changes (additions, deletions, field changes, etc.) are made directly to the original file. I have added the following code to the datagridview rowleave event: [code]I'll figure out a way to skip the update if nothing is changed, but for right now, it doesn't work. I've searched MSDN, the MS Community forum and several other forums for a solution and all I have found is what I already have and it doesn't work.I can make changes at run-time alright, but the exception it triggered when I change rows, and the data is not saved to the database file.When I close/re-run the app, the changes to the data are not thereThere has to be a way to save changes to the datafile, but I'm just not finding it.
I'm using VB Express 2008 in Windows 7 64-bit. I'm working on a project with a datagridview bound to a MS Access 2007 database. I want to use the datagridview to add, delete and update the data in the MS Access database. When I added the database file to the project through the Datasource Configuration Wizard, I selected 'No' to copy the file to the project folder. The connection string automatically placed in the project settings is:Provider=Microsoft.ACE.OLEDB.12.0;Data Source="F:My MoneyDoBillsDoBills2009.accdb" The 'Copy to Output Directory" property for the DoBills2009DataSet.xsd is set to '*Do not copy*'(and I've tried every other setting available). So, as I understand it, I am working with the original file, not a copy, and any changes (additions, deletions, field changes, etc.) are made directly to the original file. I have added the following code to the datagridview rowleave event:
Private Sub dgvSortBills_RowLeave(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgvSortBills.RowLeave Try
I'm using VB Express 2008 in Windows 7 64-bit. I'm working on a project with a datagridview bound to a MS Access 2007 database. I want to use the datagridview to add, delete and update the data in the MS Access database. When I added the database file to the project through the Datasource configuration Wizard, I selected 'No' to copy the file to the project folder. The connection string [code]...
I'm using VB Express 2008 in Windows 7 64-bit. I'm working on a project with adatagridview bound to a MS Access 2007 database. I want to use the datagridview to add, delete and update the data in the MS Access database. When I added the database file to the project through the Datasource Configuration Wizard, I selected 'No' to copy the file to the project folder. The connection string automatically placed in the project settings is:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source="F:My MoneyDoBillsDoBills2009.accdb"* The 'Copy to Output Directory" property for the DoBills2009DataSet.xsd is set to '*Do not copy*'(and I've tried every other setting available). So, as I understand it, I am working with the original file, not a copy, and any changes (additions, deletions, field changes, etc.) are made directly to the original file. I have added the following code to the datagridview rowleave event:
Private Sub dgvSortBills_RowLeave(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgvSortBills.RowLeave Try
I am coding this app on my home pc, but when complete it will be run on individual pc(s) (each pc has it oun HD) on a local network. I have a world of questions but right now how do I set the path to my database? is there a way to set a default if its not found.Database(s) that the app use's are stored in a folder on the server. i.e.: P:MyServerNameDeptFolderData for example.OLEDB or TableAdapters which would be the better choice.I understand that MS Access DB is rather resticting.
i would like to upload a File with the Fileupload-Control to a MSSQL 2005 Database. I use Visual Studio 2010 an VB.NET I have also wirte a Code, but i get a Error-Message if i klick die Upload-Butten. "The Website is not available"Why the error-message cam? or can i optimize the code more?
Importing an excel file?first the program should be able to browse for an excel file and then,the values in an excel file will be imported to the datagrid and save all the data in the database.
