I'm trying to incorporate TransactionScope into my code and am failing at the first hurdle. I am unable to open a connection inside TransactionScope block. I get exception Connection Not Open.
Public Sub PerformDBWork()
Dim cnA As New OleDbConnection(My.Settings.DB_CONN_BUSINESS)
Try
cnA.Open()
[code].....
My cnA.Open() fires as expected but my call to cnBusinessDB.Open() fails.
I'm currently working on a legacy project in VB.NET 2.0.The project has a very funny DAL-layer which does not incorporate transactions :-|Anyway, it's my job to make some parts of the program transactional and I don'thave access to the DAL layer code.So I'm trying to put entire sections of code inside single TransactionScope.
View 1 RepliesDoes the database connection have to be set inside a TransactionScope?
Or can I set it in the ctor and then have instance methods create up a TransactionScope?
EDIT: e.g.
Public Sub New()
Dim conn = new SqlConnection(...connection string)
Public Sub SomeClassMethod()
[Code].....
the question is do you need to create the connection to the database after you've created a TransactionScope or can it be done before?
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'm importing several fields, and that is, about 25 lines of code each importing one field (in my case, there's really no other way).It's in a try-catch block, but there are some times, that this field doesn't exist in the source, but I have to get the rest.
from 20.
I get 10
the 11th one doesn't exist (exception)
I still need from 12 to 20.
In case I don't want to test the existence one by one, I'd like to know how try works. in case of an exception, it doesn't execute the rest, right? what could fit for me ?
obs: it's way more than 20, I want a smart-and-non-poluting solution for it.
How I can change Autocad information inside block Attributes(I think on width, rotate, text style, layer, height..etc ) in visual basic? For example, We have some block with 2 attributes and I want replace width factor.
View 2 Repliesim new to coding (started coding last month) so im a little stuck on how to do this, im making some emulation programs to learn coding with, and a part of it is to point the app to a .iso/.bin file and scan the data inside of the iso/bin to check if a file exists.[code]My issue is i cant find any class examples, or any information etc on how to code it so my application can see the data inside of the iso/bin instead of just see'ing the iso/bin file, so that i can then check the data inside the iso to see if the file exists etc.Im a novice still at coding so making a new class myself to look inside the iso/bin is to complex for me.
View 1 RepliesI'm having a problem with some users, my vb tools always check at the splash screen a response from a server with a simple:
Dim MyResult as string = oWebclient.DownloadString("www.mydomain.com/page.php")
This actually works for most users but in some clients the firewalls I think they block this call or bypass or something like that, I found that after telling the user to turn off the firewall everything works ok, now I have some users that according to them they don't have a firewall or they already disable and still they have the problem.
You can see from the image the error message they receive, so my question is do you know any kind of free tool that I can send to the user to maybe log what program or whatever is blocking the program to connect?
Is there a way I could block connections to an IP address (Incomming and Outgoing) in visual basic 2008? I have a different method, using the windows hosts file. I could make it redirect, but on the host file, could I make it launch a certain application when it blocks an IP. Like, launch a file called blocked.html that says "Webpage blocked" on it? and if u get this far, how can I see when an app attempts to connect to the internet. Like on bit defender firewall, say aim6.exe trys to connect to a server, how could i warn the user of this???? (Maybe using winsock)
View 1 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]....
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].....
I would like to block the ability to open the same project twice.Like in VB6... you could not open the same vbp again.
View 2 RepliesI have a application which reads from ini at startup, What i want is a vb code that will block the user from opening the ini file manually, program could be running as service eg: C:config.ini. program should block the user from opening the file.
View 1 RepliesIn 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 RepliesI have created my own object, wich contains a SerialPort. I have a sub in my object wich handles the .DataRecieved-event. I'm trying to access my DataSet from that sub, but for some reason I'm unable to do that. It keeps telling me that my tables contains 0 rows, but I'm 100% sure that they contains several rows.
View 10 RepliesCan anyone tell me how I close an opened SQL connection inside a Function?
I call a Select Function like this:
[Code]...
I'm building a TCP/IP server that sends small strings and updating my database, every time the client connect i get this Exception:
unable to read data from the transport connection: an existing connection was forcibly closed by the remote host. The client successfully able to connect to the server and everything working fine even though this Exception raise, but if i send 3-8 request in the same second the database do get updates in all of them but the server failing to send "OK" response to the client in about 3-4 of those requests, the line i get the error is this: bytesRead = mClient.GetStream.Read(readBuffer, 0, BYTES_TO_READ)
I am getting following exception:
[Code]....
I am unable to access the TableLayoutPanel feature inside the toolbox in Microsoft Visual Basic Express 2010, I was wondering if this is a feature that is excluded from this package or is it something that I need to download.
View 1 RepliesI am trying to send messages from my application to a yahoo account and I am getting the following error:failure sending mail..Unable to read data from the transport connection: net_io_connectionclosed.Is this because of the LAN and work or something else/ [code]after the line mailobj.send executes it stalls for a while and then the application ends.I checked all the parameters and they seem correct
View 4 RepliesI am faced with the prospect of having to completely rewrite the application.I have suddenly started to get this error message all the time - it seemed to start after I added a table to the schema, but deleting the table makes no difference. I can't see anything wrong with the connection string, but as it seems to be entirely undocumented, that doesn't mean much.
The connection string contains DataSource=.SQLEXPRESS;AttachDbFilename=|DataDirectory| est.mdf;Integrated Security=True;User Instance=Trueand certainly the string works when I use "test connection" from the application setting edit box. I am assuming that for some reason it is not evaluating the Data Directory , but can't see any reason why it shouldn't. Any ideas gratefully received! What might be a clue though is that I can't get rid of the table I added. I have deleted it from the database, deleted it from designer and saved the file, but it just keeps reapearing! Even when it is not showing, there is still a
table adapter in the .xsd file. I am reluctant to start editing this manually because of the danger of screwing something else up - I did try but it caused an error somewhere else (VS helpfully didn't say where)
I have the following routine:
[code]...
Running this against both our production and test Oracle 11g database sporadically (or if there is a pattern, I haven't found it yet) generates the Oracle Error:ORA-02049: timeout: distributed transaction waiting for lock Since this is the only process running against the test database, there shouldn't be any issue with different users competing for a lock.
I came accross TransactionScope as I try to resolve an issue bothering on the use of Transactions on Typed DataSets. But when I tried to implement it, my intellisence does not recognise it. I have to Import System. Transaction. TransactionScope but it is not recognised. How do I use it cos it seems like it holds some clues to my problem?Only performance counts!
View 5 RepliesI've posted this question in asp.net web forum but no one replied.
I can't open "ONE" page of .pdf file using IE8 and give me an error message "the file is damaged and could not be repaired" when retrieved from SQL Server 2008, but more than one page I can open with no problem.
With Chrome I can open any number of .pdf pages.
The same page that I can't open using IE8 from DB, can be opened directly from hard disk using IE8.
My code in .asxh file:
context.Response.ContentType = "application/pdf"
Dim strm As Stream = ShowNewsImage(imgName)
If Not strm Is Nothing Then
[Code].....
I'm running windows vista. I get the upgrade for sp1 via windos auto updates. I then it adminstration by right clicking on the shortcut. I open up visual basic, I can't open my projects.I can click on the link, do it via file. None of the files will load up or open.
View 6 Replies