so as to open an MySQL connection how can i have a procedure to open a connection to an MySQL server duly passing my connection variable name in to my procedure as a parameter like some thing the fallowing one is not opening the connection
[Code]...
Can I use two command object with one open connection in one procedure at VB.NET?
View 2 RepliesI have been creating some asp.net sites that connect to an AS400 for data and I use a SQLDataSource for this with the following connection string (changed for security reasons). Now I need to create a winform application in VB.NET and am wondering how I would do this? I have only used MSSQL in winforms and use the sqldatareader for Select statements and execute non-query for others. I need to call some stored procedures on the AS400 passing parameters. I was hoping to do this by code like I do with MSSQL rather than drop in controls to bind to.
Provider=IBMDASQL.DataSource.1;Data Source=192.168.100.2;Password=xxxxx;User ID=xxxxx;Initial Catalog=S12345;Default Collection=AABBCC
In my program, I have a timer with a inteval set to 1000ms. The timer is executing a MySQL-command, and right now I'm opening and closing the connection each time.
View 5 Repliesam trying to open a connection to an access db using the following:
vb
Dim cmd As New OleDb.OleDbCommand(QUERY, New OleDbConnection(CONNSTRING))
cmd.Connection.Open()
'dim dr
cmd.ExecuteReader
On the cmd.ExecuteReader line an error is being thrown whose message is unknown .
The connection string is as follows:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MYDB.MDB;Jet OLEDB:System Database=MYWG.MDW;User ID=USER;Password=PASSWORD;
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.
How hard is make listening connection? Game? Program? Example: Server where people can connect? Just ready opened connection example where another program connects or something? (Console where you see when people connects and disconnects.....=>)
[Code]...
i 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 know there is a lot of open source projects out there but I can't seem to find any VB stuff. I have to come up with an application that will keep track of eqiupment we sell, service and repair.
View 2 RepliesWhen 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]...
Try 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.
I'm trying to insert a new records into database, one of those records is a "datetime"...when I type a wrong date, and try to insert those values into database, i get an error (about wrong typed date etc.)...ok, that's fine, things need to work that way. But here comes the problem, I correct the date, and then try to insert values again...here I get an error from the post title. And this doesn't work until I close that form and run it again...here's part of my code:
Dim cvLicence As New SQL
Try
cvLicence.upis("INSERT INTO blabla (itsnotimportant) VALUES ('something')")
MsgBox("everything's fine", MsgBoxStyle.Information)
[code]....
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
exitwithout()
[code].....
My problem is when I change computers, I have to change the drive letter the jump drive is located. Currently, I have the following code and have to comment out the connection to the letter drives I do not need to use.
' Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:Grad ProjectProject.mdb;")
' Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
[code]......
This emailing code wont seem to work in my program. I get an exception "The SMTP server requires a secure connection or the client was not authenticated. The server response was 5.5.1 authentication required."
Imports System.Net.Mail
Public Class emailStudent
Private Sub sendEmailButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles sendEmailButton.Click
SendMail()
[code]....
I have a class set up to hold values on a registration form (VB.NET, MVC), and among the properties is a Password property:
[Code]...
I have a simple scraper. It works on some websites, but on some there is this Error:
Quote:
IOException was unhandled Unable to read data from the transport connection: The connection was closed
It is occuring at "Dim htmlresults As String = Urlcontents.ReadToEnd()".
'Create the HttpWebRequest object
Dim req As HttpWebRequest = WebRequest.Create(URL)
'Set the timeout to 1 second (or 1,000 milliseconds)
req.Timeout = 10000
[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 creating a login form together with sql as may databse but when i run may program an error occur at "myData = myCommand.ExecuteReader()" stating that "Connection must be valid and open" what should i do on that to make it fix? [code]
View 7 RepliesI 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'm trying to connect to a database and keep the connection open for any amount of user activity/queries within the database. Currently I have a connection that opens and closes for any query (save, update, etc...) which requires the logon process to the back-end every time the user saves etc... Is there a way to simply connect and leave the connection open so there won't be a lag time when running the query due to the logon process? This is what I'm using:
Private sConStrFormat As String = "Provider=TDOLEDB;Data Source=TDDEV;Persist Security Info=True;User ID={0};Password={1};Default Database=bcpm_ddbo;Session Mode=ANSI;"
[Code].....
i want to know how to open a connection to database from vb.net
View 3 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'.
In our application we use IDataReader which actually call function from one.dll where weExecureDataReader()
We have many calls in application and in some places For some reason I am getting error message "DataReader already open" but I am not sure where.What will happend if I simple close that conection in the that .dll? Am I going to make trouble to database because one datareader left opened? I assume closing connection will close reader too and gargage collector will manage that left opened datareader..
SQL connections confuse me sometimes In almost every SQL related code on the internet the routine is like this;
* Open connection
* Execute SQL command
* Close connection
Is it good practice to just open a connection when the application starts and use that connection until the application closes?I know that sequential connections are required when processing more queries, but what if I need to poll a certain Table every x seconds? Isn't is better to keep that single connection open for as long as the application is running (and re-open when a failure occurs) instead of opening a new connection every x seconds?
I'm trying to insert data into a mysql database, I'm using xampp as well if thats of any relevance? I keep getting this error: Connection must be valid and open.
on cmd.ExecuteNonQuery()
I'm following my Microsoft Access application that I've also written as a reference and that works perfectly.' This is the code for inserting into an access database which works and is tryed and tested:
Imports System.Data.OleDb
Public Class frmEnterDetails
'text box variables
[code]....
Public Class app_mainform
Dim mssqluname As String
Dim mssqlpword As String
[code].....