I installed SQLExpress 2008 on my computer this afternoon and have been trying to create a new database and open a connection to it. I found this code online and tried it:
Dim
conStr As
String =
"Server=MSSMLBIZ;Database=;Trusted_Connection = yes"
[code]....
I have a .mdf file that I open through an Open Dialog Box and use in a ConnectionStringBuilder (where I have the user instance set to True). Later, in one of my button clicks, I try to open the connection (connection.Open()). It then gives me an error as follows: "Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances."
Here is my code:
Option Strict On
Imports System.Data.SqlClient
Public Class frmMain
[code]....
I am currently working on a login page using vb.net. I would like to know how to make connection to an access database and verify that the user logged in is a valid user
View 6 Repliesi want to know how to open a connection to database from vb.net
View 3 RepliesI have produced an application which works with datasets but I now wish to provide the user the ability to add and admend records within the database.But i wish to do this in a seperate form.My current dataset instanciates classes onLoad.Should i try passing the Dataset to the new form class? although I have the problem where by when i pass the dataset to the form class using code below i get this problem:[code]Should i just create a create a new connection to the database and produce a new dataset for this form? or is there a better way to do this?
View 2 Repliesi am doin project using vb.net 2005 and using this sql query for connection
sql = "select username from login order by username"
con.ConnectionString = "Data Source=" & hostname & "; Initial Catalog=college;integrated security=sspi"
but m getting the following error:
Cannot open database "college" requested by the login. The login failed.Login failed for user 'CI4Admin'.
I am developing an application that is using a Jet database (Access 2007). The database is local to the project (e.g., on the same drive and in the project directory). Any time I attempt to access the database (to create another DataSet, etc., via designer, etc.), I get the ubiquitous "Failed to open a connection to the database" with:
No error message available, result code: E_UNEXPECTED(0x8000FFFF).
Opening the Database Explorer and attempting to attach to the database results in the above as well. There are no apparent locks on the file, etc., and I'm the sole developer for this.
I'm trying to a open a connection to a local database and no matter what I try it just won't work (I'm pretty new to SQL Server and VB for that matter) I tried using 'sqlconnection' with different connection strings but none of them worked or gave me any useful error messages so I tried using 'OleDBConnection' instead, this hasn't worked either and it gives me this error instead:"A first chance exception of type 'System.NullReferenceException' occurred in MyProgram.exe"
Here is the code I am currently trying:
Private Sub MemDetailsSearch_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
ConnectionString = ("Provider = Microsoft.Jet.OLEDB.4.0;" & "Data Source = Database.sdf")
DataConnect = New OleDbConnection(ConnectionString)
[code]....
I want to know what is the right way to close my Database connection while its open.
This is how i open my connection.[code..]
I have a connection string in my app.config:
Code:
connectionString="data source=.sql2008 ;Database=Database1; Integrated Security=FALSE; Persist Security Info=True;" />
How do I change to another database (one of many) without using multiple strings? Can I change while the connection is open?
Code:
Dim myConn As New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("ConnectionString"))
I am trying to open an Oracle database connection in vb.net 2008 in order to issue a Select statement and the populate a listbox with it.
My code is as follows:
Dim orclstr As String = _
"Provider=OraOLEDB.Oracle;" & _
"Data Source=10.0.0.77;" & _
"User ID=myuser;" & _
[code]....
Obviously, I am doing something wrong, but I can't figure out what.
I keeping getting an error.Seems to be the connection string.Error happens at connection.Open()
Error Message:Cannot open database "C:UsersJEREDocumentsVisual Studio 2008ProjectsBaseball2009Baseball2009DatabaseBaseball2009.sd"
requested by the login. The login failed. Login failed for user 'JERE-PCJERE'.
Imports System.Data.SqlClient
Public Class Field
Private Sub Field_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load[code]..........
I'm building application that will heavily use database (about 25k query's in few hours) , what is the best way to go:
A) use datareader and open new connection to the database on every client query.
B) load all the needed tables into dataset once the program loaded and use that dataset for the query's?
When using SQL connections in my program, will I have to open and close the connection and the data reader each time I want to access the database ?
[code]...
I wrote a small application in witch I create a connection to a database. I'm new to this, so I followed the steps in MSDN help. I first created a link to the database with the "Datasource" of the Visual Studio environement. Then, in the code, I create instances of the dataset in the datasource and use a tableAdapter to register my changes in the database.
Now I want to allow the user of the application to specify the path of the DB file he wants to use. How can I do so? Do I still can use the datasource in the VS environment? I don't know where to start.
im sure that there are plenty of people here that have the same problem as me, but i cant seem to find a forum that explains this to me. well basically i have a program i am creating to use as a phone list, but to save data to a database on a mapped hard drive. I want to give the user the option to set the path of the database just by typing it into a textbox. The database will be supplied with the program, with all appropriate tables, i just really would like to know how to set up a connection to a database using code, and to be able to display it into a datagrid veiw. I know this seems simple to you guys,and i am really sorry, i am just new at this.
and also if u could, could u describe to me how to make it search through the database for like certain names/numbers?
I have this code of sending sms but i dunno know how to make the connection for the below code to run my program.
[Code]...
Okay i have been looking around for some tutorials on databinding by code but all the ones i find use vb's built in function to create the connection to the database and then the binding but i need to do it manually. I am totally new to databinding as in i only learned about it from a previouse thread and have been fiddling since.
[Code]...
So im kind of going blind here, i dont know whats going wrong or if im even using the correct dim statment for the binding,
I have Visual Basic 2010 Express and SQL Server 2008 R2 (not Express) installed on my Windows 7 machine. In Visual Studio, I am attempting to create a Data Connection to a database in SQL server. Server Mgmt Studio is not running. When I attempt to add a connection in Database Explorer, to the AdventureWorks _Data database, I get the message "This file is in use. Enter an new name or close the file that's open in another program." There are no programs running except VB, except maybe for the SQL Server engine running the background.Please note that I can open and access tables within a database in code
within Visual Studio, I just can't add a connection in Database Explorer.Am I doing something wrong? I've been very frustrated on this issue for a long time
friends i m a newer for dotnet...and i m a student i m creating a project with a simple database connection
i need to make a setup of that project but whenever i create a set up it wont connect with my database
it'll shows a error how to make a setup in vb.net with a project with a database connection
how i can create a connection to a database when i open my program and then close that connection when the program closes, so that the user has a permanent connection while the program is running that can be used for multiple things depending on what the user decides to do.
View 5 RepliesI basically want to make this in my application, so our technicians have an easier time installing our software. So far, I made a form with 4 text boxes: Server name, user name, password, and a combo-box to select a database.Everything was pretty easy until the database selection code. Microsoft's wizard is very efficient, there's no wait time when the database combo box is being filled.[code]That code gets the databases just fine, but obviously if an exception happens the whole screen locks up and it might take a while to recover depending on what the database error is. My question is, can I make mine just as cool/efficient as Microsoft's?
View 1 RepliesThe fact is I'm making an application, which users can install by using a Setup file...once installed the data in the database can be updated by a centralized server. To do this, they can insert a DVD/CD-ROM and export the necessary data towards it. I need to do it that way, because some of the users who really need this data will be using stand alone computers.The application gets it's data from a mdb-file and the connection remains open as long a person works with the application (maybe not the best way to do, but I know :-) )...when the user uses the application, he can perform an export...this exports the .ini-file and pictures (which works fine), but he also needs to export the mdb behind the application...I already tried connection.close() before and connection.open() after the System.IO.File.Copy...but that doesn't seems to work.
View 2 Repliesi have an application. which is executed after every 5 mins. i have an open connection but it gives me the following error:
ExecuteScalar requires an open and available Connection. The connection's current state is closed.
my code is something like this. I have shown where all i am using ExceuteScalar()
Sub Main()
Try
connection.open()
cmd.ExecuteScalar()
[code]....
i make a class and when i call on form then that error occurs "ExecuteNonQuery requires an open and available connection, the connection Current stat is close "
Class Code isImports System.Data.SqlClientImports System.DataImports System.StringPublic Class DatabaseKits Dim Cn As New SqlClient.SqlConnection Public Function BuildConnection() As Boolean Try Cn.ConnectionString = "Persist Security Info=False;Integrated Security=True;Trusted_Connection=Yes;database=BizAimsPro2008;server=Server-2k3s" BuildConnection =
[code]....
I am trying to build a user control that will do exactly what the SQL 2005 Connect to Server interface do, eventually create a connection string and store in a app.config file. It should allow user to select server type, server name, authentication, user name and password. It should also automatically load available servers and domain login by default.
View 11 RepliesI am using VB 2008 Express and have created an application that connects to a SQL database to populate a datagrid.The application is working properly on my computer but will not on others 'remote connection permissions' error.After some googleing I found that the express version is crippled to only work on local machines that use a database.If I purchase Visual Studio 2008 Standard Edition, import and rebuild my application, will my application be able to run properly on other PC's?
View 7 RepliesTry If functionmode = "ADD" Then
[Code]...
I got this error..The connection was not closed. The connection's current state is open.
This is coding to add data in Ms access in vb...
Imports System.Data.OleDb Public Class Form1
[Code]...
I'm developing a device app in VB.net that will access a SQL Server database. I need to establish a connection when the app is launched, and keep the connection open until the app is closed. I've done the following:In the Master Module:
Public CNN
As SqlConnection
In the Main menu form load:
CNN =
New SqlConnection(sqlConnString)
CNN.Open()
Then when I want to read from the database:
Dim sqlDR
As SqlDataReader
SQL = "SELECT Name FROM Table"
[code]....
When I run the same code without the global CNN, but rather dim the connection inside the Select function, all works well.