I'v created a program with a Ms SQL database, registration form and login form. Everything was working well so i detached the database and added it to my program as an existing item before so as to deploy the program. But now i recieve an error when i try to login to the database. The error states that there is a failure connecting to the database and the database cannot be opened
View 10 RepliesI created a small program which one uses the SQLite database. I have a simple table employees, composed of the name and password. I can not write sql script correctly. application code is:
Imports System.Data
Imports System.Data.SQLite
Public Class Form1
Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click
[Code]...
Over the last couple months I've created a fairly substantial program for a friend in vb 2008 express to deal with the management of a fantasy football league, for its data storage it uses mainly an sql server 2008 express database for all the data, however there are a couple of text files for some unrelated fixed values.
I have spent the last week or so putting some vague finishing touches on it so that I can give it to said friend to test for me. However after working perfectly fine for me for the duration of the construction and also working fine on a couple of computers I installed and tested it on, upon giving it to my friend I find that (after installing) as soon as he opens up any form which relies on database data it spits out an error akin to the following:
Exception Text:
System.Data.SqlClient.SqlException: 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)
[CODE]...
Loaded Assemblies:
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4918 (NetFXspW7.050727-4900)
CodeBase: file:/Q:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
[CODE]...
I have used a combination of LINQ and SQL statements to query and and update the database, with LINQ for querying and SQL for the updating, due to this most of the database communication is done through a LINQ to SQL datacontext using the pre-generated connection string in my app.config file: <add name="FFL.My.MySettings.FFLv2ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\FFLv2.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
The only other time a connection string for the database is used is in an SQL execution function which uses the following: Dim connectionString As String = "Data Source=.\SQLEXPRESS;AttachDbFilename='" + Application.StartupPath + "\FFLv2.mdf';Integrated Security=True;User Instance=True"
The textfiles are also referred to using the 'Application.StartupPath + "folders/filename"' method
As for other details; I started this program on vb 2008 express but upon finding that the express version didn't have much in the manner of deployment facilities, downloaded a 90 day trial of visual studio 2008 pro to deploy the program as an msi install file. Operating system wise, I started the project on XP before converting over to Vista home premium + latest service pack (I think) which is what I've finished it on and am using currently, the 2 computers I successfully installed it on were both running XP SP3 and my friend runs a dualboot of Windows 7 and Vista (not sure what edition), he's tried it on both to no avail.
And for reference; to the above code/error, the database is called FFLv2.mdf and the project FFL.
The pre-requisites for my program (as highlighted by vb) are as follows:
.Net Framework 3.5 SP1
Windows installer 4.5
SQL Server 2008 express edition
I've tried changing the connection strings to specify a specific filepath, but that didn't help.
When I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?
View 1 RepliesI have created an access database which i want to search with vb.net, I tried a few thing but it didnt work as desired.
Firstly the program is suppose to display items in the database base on the criteria selected by the user. what i've succefssfully done so far is I've added a datagrid 2 combobox, 1 (searchcbo) with the columns in the database and the other (searchcbo1) will autoload the items under the column selected in and a button (searchbtn) but i have no clue of the code to put in the button. i also tried the fill method but that didnt work as i wanted to. ultimately i want a combobox with the list of columns and a textbox to enter criteria and of course a search button.
The searchbtn should act as the "WHERE" sql command, e.g. SELECT EmployeeNumber, Firstname, LastName, Phone, Location....etc FROM CallLog WHERE searchcbo.text = searchcbo1.text And display the results in the datagrid.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CallLogDataSet.CallLog' table. You can move, or remove it, as needed.
Me.CallLogTableAdapter.Fill(Me.CallLogDataSet.CallLog)
[CODE]....................
Attached image(s)
I have created a program in vb.net, something like a inventory system. a simple one.. my only problem is, how can i add a configuration option where my user can select which server he will use for the database?
I tried using a sqldmo.. but it has an error when i instlled my program to another pc. But ive already add a reference to it.
[Code] my issue is that now i need two cases, first i need a query that will return the date created and modified of the table and i also need to know if its possible to query a list of table names in the database ordered by date created but that have a certain thing in their names. for example the database contains the following tables: [Code] and what i need the query to return is the tables that contain "Data", settings and employees are for the other functions of the program. so the query should return the 4 data tables in order of date created. but i have no idea how to go about doing that in the query, does anyone know how this is done?
View 6 RepliesI finished creating my help file for my app using .chm program. Now, how do I go about associating that help file with my program so people can click on help and it's there. Do i need to bring it into my resources?
View 2 RepliesA weird thing just happened. I created a program wich creates folders and now when i want to "save as" an excel document in a folder created by my program this error occurs:[URL].. But this only error occurs if i try to save as an excel document
View 7 RepliesI have created setup file of my program & it shows error when I install it there in another pc which doesnt have visual studio. Even I have tried to install it there in another pc which has visual studio & it worked well. I am confused. I am use Vb.net 2008 and ur .net frame work will be 3.5 .It shows following error message
View 6 RepliesI want to check if database is created or not whne using the below SQL command
CREATE DATABASE IF NOT EXISTS 'DatabaseName'
from the below link i could able to get if database exists or not. and i tried the same way to catch the result od SQL command. but i could not. correct me if i wrong. below is my code. Having a form with 2 text boxes (txt_host,txt_db) and a button Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code]...
I'm facing problem while reference vb6 dll in .net project. When ever i refer a vb6 dll in .net project the interop dll is created with same version(1.2.0.0). Its creating problem for me as the setup used to deploy the application at client side does not replace the dll if the version is same as before. I want to change the version of the interop dll (created using vb6 dll). I read it cam done using tlbIMP but how to create tlb file for vb6 dll.
View 2 RepliesI created a VB.Net program in Visual Studio 2010 Pro. Everything runs fine in debug mode on my developement machine. I'm using setup builder installation and cryptolicensing for the license.dll. I have checked the setup program and all the files are installed on the test pc as required. The program was developed on the 4.0 client Framework. The problem is when I install the program on the test computer it will not open or run. No indication of why no messages, nothing. Can anyone steer me where to begin to find out why this is happening.
View 3 RepliesI created a paint type program for signatures, and now I would like to save my canvas as either a jpeg, bitmap, or gif file, but I am unsure how to go about this. Here is my code,
[Code]...
i have created a program which has a zoom split button. for single click zooming and percentage zooming, basically when i click the single zoom(can click forever to zoom) and clear the image, the picturebox size goes to a very small size, where as the default setting of the picture box is 590,649. is there anyway of writing abit of code so that when i clear the image after clicking the zoom button the picture box does not change when image is erased. i am working with vb.net. please help its completly thrown me. just to add i have a panel and picture box because on some zooming percentages i have scroll bars so you can pan the image by clicking and dragging mouse.
View 2 RepliesI have created a small test program for faxing.On some machines it works and on others it throws the following COM error when trying to send the fax:[code]Here is the source code from my test application.All it requires is a reference to FaxComExLib.[code]
View 15 RepliesClose a database that we created by programming?I have created a database with below codes[code]...
View 3 RepliesI created a Query in a database in Access. I want to attach it to a DataGridView in VB2010. I then went to VB and connected to a Database. Then I dragged a DataGridView onto the form. Up came a pop-up menu. I Clicked on Choose Datasource, Add a DataSource,clicked on all the next buttons, selected Tables and Views checkboxes and clicked finish.In the next view up pops a menu that lists my Database and it's tables, but not the created Query. The Query does exist in the Database and I am accessing the correct version.
View 3 RepliesI created some database already in my SQL server 2008. And im planning to show all this data via graph using VB.net..Is there anyone here can give me LINK, thread or the best is tutorial so that I can begin doing it.Usually my data is based on date only. So once the date inputted then it will SQL and get the exaxt data in Graph format.
View 3 RepliesI am writing a small aspx web application that takes in forum information after validation and then opens a database connection and populates the proper columns with data.note: The database is a .sdf file created in web matrix My issue is that even with: Import Namespace="System.Data.OleDb" on the page I am getting:
Type 'OledbConnetion' is not defined. I am extremly new to VB, I am coming from java and honestly I do not have all year to read vb code and take classes and read books. I need to finish this app for a client so I am kind of rushed.
[Code]...
i have mad e a database with the following tables...username varchar(50)password varchar(50)as you know it does the rest for you"now i have a form with..TextBox1 for username textbox2 for password
my database is called "jonno-laptopsqlexpress.username.dbo" now if i add usernames and passwords in to the correct tables how can i login via he textboxs?
I've been coding in VB.net for a while now, but still have never used the printing features. I've created a program which stores and creates customers and orders etc. I now require to print invoices related to these quotes.Is the following possible within VB.net when printing a document. Images i.e. Logo of company (which i've made already)Table of items orderedTotalshorizontal lines to split-up the design of the invoice/document.
View 2 RepliesPrivate Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
'Ceci cr�e un fichier *.TXT dans un endroit statique
[Code]....
So my app is supposed to make a exercice.bak out of the .txt file but whatever I do it says the program is accessing it... any hints how i could makw the program SAVE the file and stop it's constant access to it...?
I have this program:
Module Module1
Sub Main()
IO.File.Create("C: ext.txt")
[Code]....
How to make my program not to use the newly created file 'text.txt'? Notepad fails to open it, it says (The process cannot access the file because it is being used by another process).
I would like to get some advise from all of you. I created a program setup using standard procedure(adding new project.. setup and deployment, setup project). When I ran the setup and installed the program in computer, It's working. Then I decided to amend certain form in the program. I right click at solution"my program name" and click rebuild solution. then i try to run again the setup, there is nothing happen after that(It remain like before amendment). Did I miss anything here? I have never used this method before and this is my first time using it.
View 3 RepliesI'm converting a bunch of FOXPRO / FOXWEB apps to ASP.NET.
The underlying DB is still foxpro (for the moment).
I am passing a table to some VB.NET code that I want to have converted to a CSV file and sent back to the client for download. And it works! Sort of ... It works sometimes, but at other times, instead of asking me if I want to download the CSV file, it just spews the file to the browser window. [code]...
Please how can i publish an application created in vb.net along with a database which i created in SQL Management Studio?
View 4 Replieshow can i link form created using vb.net to sql server database.I created a database with sql server 2000 now i want to connect form created in vb.net to sql server database
View 1 RepliesI am an experienced programmer but am new to VB. To start, I am trying to create a simple database program. (My ultimate goal is writing a comprehensive database program in 6-8 months)I have created the database and bound the fields to a form.
But what I want to be able to do is add a field to the database and then also bind that new field to a textbox on the form.The new field appears on the list in the Server Explorer window (on my left) but not in the data sources window (on my right.) The data sources windows has a "refresh" option but that does not help.When I manually add a textbox and try going to DataBindings in the property window the new database field is not listed.
I am in the middle of the creation of an application using vb.net. I have a database created in MS.Access which includes 7 tables. I connected this one with my parent program code. Now the problem is that I want to display the data from each column. I have 12 columns and 14 rows in my first table. How can I display data from one column in a Combo box?
View 1 Replies