Database Connection - Post-install - Created A Fairly Substantial Program

Aug 7, 2009

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.

View 2 Replies


ADVERTISEMENT

Sql Server - .net Program Dataadapter Connection Closes After Fill But Database Still Shows Connection?

Aug 19, 2010

After running the following sub (VS debugger), I try to detach the database in SSMS, but it shows the connection open still and won't let me detach. If I close program in debugger, the database shows no connections. I check the dataadapter's connection in the finally block and is shows closed. What gives

Private Function ClientMasterDBFiles(ByVal MasterClientDBConnection As String, ByVal DBName As String) As DataTable

[Code]...

View 1 Replies

Created A Program With A Ms SQL Database?

Jun 5, 2011

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 Replies

Created A Small Program Which One Uses The SQLite Database?

Apr 28, 2011

I 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]...

View 4 Replies

Make A Simple Install Wizard To Install The Program?

Nov 10, 2009

I'm looking to make a simple install wizard to install my program (I know Visual Studio 2010 already has an installer) but anyway, I would like to make it myself, kind of line reinvent the wheel?

View 3 Replies

Make A Database Connection In Program?

Mar 9, 2008

I need to make a connection with an access 2007 database in VB 2005.[code]....

View 15 Replies

WIndows 7 Won't Run .NET MS Access Database Connection Program, But XP Mode Does?

Mar 16, 2010

I have written a simple VB.NET program that connects to a MS Access Database. This program runs in Windows 7 XP Mode, but does not run properly in straight Windows 7. Somehow, the Windows 7 does not connect properly or read the MS Access database data properly with the DataAdapter.Fill method. I have dual monitors, so I can run the identical program side by side (one in Windows 7 and the other in XP Mode) - one works and the other doesn't (it doesn't crash, it just get "nothing" from the database when accessing - acts like it's not connected). Has anyone else run into this, or similar, problem with VB.NET and MS Access connectivity?

View 14 Replies

Simple Payroll System - Program That Shows Connection Of Database(sql Or Access)

Mar 4, 2010

I think its better if i attach my files for you understand what i wanted to happen in my program.

We are now in our finals and for our project we need to make a program that shows connection of database(sql or access) and vb.net so dont mind if it has a problem in design or anything bcoz the objective of this project is to show what we've learn in our subject IT Programming 1 (vb.net)

I dont know what to do in this part of my program. what to do first? why is it attaching zip files is not allowed?

View 4 Replies

Adodb.connection Error 0x80004002 When Trying To Install On Other Computers

May 24, 2011

Just got this error in my vb2008 programs when trying to install on other computers (customers running XP and Vista). I am on a Win7 computer and are using MS Access 2007 databases. Up to now everything was just perfect - but now.... Tried to search the net for solutions, but got a lot of mumbo-jumbo I can not understand. what to do in order to supply a set-up program which works.

View 2 Replies

Check If Bluetooth Connection Closed Or Cannot Be Created?

Jan 22, 2012

I have create a simple app in vb.net that receive data from a bluetooth device ( data are simple strings like "90123.9mm"). Is there a way to check if the device has closed the connection ?

[Code]...

View 2 Replies

IDE :: Changing Connection Of A Wizard Created Tableadapter

Jun 16, 2009

I added an .xsd file to my project using the IDE After that, I right-clicked and chose Add->Query I chose a dummy connection and then >SQL statement->Update Then I changed the Query's modifier to public

Dim ta As New dsCC2000TableAdapters.UpdatesTableAdapter
ta.UpdateQueryTest()

The problem is... I can't seem to modify the connnection object at runtime (by using ta.connection = XYZ) It doesn't show up on ta variable's intellisense!

View 6 Replies

IDE :: Changing Connection Of A Wizard Created Tableadapter?

Feb 9, 2012

I added an .xsd file to my project using the IDE After that, I right-clicked and chose Add->Query I chose a dummy connection and then >SQL statement->Update Then I changed the Query's modifier to public

Dim ta As New dsCC2000TableAdapters.UpdatesTableAdapter ta.UpdateQueryTest() The problem is... I can't seem to modify the connnection object at runtime (by using ta.connection = XYZ)It doesn't show up on ta variable's intellisense!

View 2 Replies

Created Some Buttons To Start A Remote Connection With Some Server?

Jun 22, 2009

i created some buttons to start a remote connection with some server.Private Sub Button15_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button15.Click Dim RetVal

RetVal = Shell("mstsc.exe /v 10.100.6.11")End Sub But now the remote connection starts minimized, how can i fix this so it starts maximized,i dont want to use /span because some people use 2 monitors and don't want it "widescreen"

View 2 Replies

Display Connection Properties Dialog For Connection String Browsing(for Database) In Run Time?

Feb 5, 2010

Is there a way to display the connection properties dialog for connection string browsing(for database) in run time?

As I want the user to be able to connect to various database using the GUI.

View 6 Replies

Changing A Connection String At Runtime For A Tableadapter That Was Created Using The Wizard?

Jun 21, 2010

I've created two forms of which two separate datasets/tableadapters were created by adding a datasource and dragging and dropping the fields onto my form.I was testing the program using a db that was located on my local drive. Well after publishing the app to the users machines, I noticed that the binded information was still being pulled from my local machine and not the database that the user is working off of.I've set the connection modifier properties for both tableadapters to Public, and I have written the following attempting to change the connection strings:

Private Sub btnSaveSettings_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSaveSettings.Click
Dim pap As New frmPap
My.Settings.dbLocation = txtSettings.Text

[code]....

View 9 Replies

Post Xml To Php URL In Program?

May 7, 2011

I need to 'post' xml to [url]...

How can I accomplish this in VB.net?

View 1 Replies

Make Program Install In Program Files?

Jun 9, 2011

Im having kind of trouble looking for this info, but i created a POS program that when i install it, it install under Local SettingsApps2.0labla

So what i want to know if how can i make my system install like any other program, "Under Program Files/POSystem/" like so

View 2 Replies

How To Post An Executable Program

Oct 4, 2009

I want to share an executable program that I was working on.

View 3 Replies

VS 2010 Add Post In VBulletin By Program ?

Sep 22, 2010

i want add post in my vBulletin by my program

how i can't do that

View 1 Replies

Make A Program That Allow To Post A Quote Out Of A File?

Jan 16, 2010

how do make a program that allows me to post a quote out of a file and put it on todays quote and a new one will come up

View 2 Replies

How Do Publish A Vb Express 2008 Program With "terms Of Use" Clause The User Must Agree To In Order To Install The Program?

May 26, 2009

I have a program in vb express 2008 which I would like to publish in a little more professional manner than provided in the standard vb express package. I would at least like to include a "Terms of Use" document the user must agree to before installing the program. I have dovnloaded and installed web developer, c# and vs 2008. Do any of these include a professional installer? If not are there any free installer packages available? I am 72 and live on a limited budget so I cannot aford an expensive package for one program.

View 3 Replies

Use 'Data Source' Tab To Create Database Will That Database Be Automatically Created / When Use Software On Another Machine?

May 18, 2010

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 Replies

How To Run After Install Program

Jul 24, 2009

How would you after the user install your program have it run? Is they code you can add to your program so after install it runs?

View 8 Replies

Install A Program Lib?

Feb 16, 2010

How do you install VB Libs ? the .DLL's ?

View 6 Replies

Install My Program To A Xp OS Pc?

Apr 20, 2011

I create the program using wndow vista. and i want to install it on other cmputer and it using wndow xp pro.

View 4 Replies

Created An Access Database - Display Items In The Database Base On The Criteria Selected By The User

May 29, 2009

I 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)

View 3 Replies

Database Connection Dll - Error "database Connection Is Not Opened"

Nov 7, 2010

i am using access database for my program. now i have connected to the database in MDI form of main exe, and ir also works, user can log in, it gets verified etc etc etc. now here is the problem, when i load a form from dll and try to use any sql query on that form, i get message, "database connection is not opened". so what i did was, i added the connect() (a function i designed to connect to database) in the load part of the dll's form, it made the trick, query's started to run, everything went fine, and when i reload the form i.e after closing the form, i load it again from MDI form, i get error, connection already open..

[Code]....

View 3 Replies

Create And Post An Html Page From Code Behind In Program?

Mar 30, 2011

I have a NameValueCollection in vb.net and I need to be able to iterate through it and create an html form that posts automatically to a 3rd party site.

I have this to go off of as an example, but I am not sure exactly how to do this from code behind and end up with an html page that actually posts.[code]...

View 1 Replies

Can't Install My VB Program On Other Computers

Jun 14, 2011

I recently finshed a program and made a finshed copy of it when I tested it on my computer it installed correctly but when I tryed to use it on a nother computer I got a error saying application download did not succeed.Check your network connection, or contact your administor or network service provider.[code]...

View 1 Replies

Cannot Install 10 Program In Window Xp

Jan 23, 2011

i programmed software in vb10 but i could not install it in windows xp?

View 6 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved