|
oracle connection in background workernew
48mins ago
I have a class (Query) that dimensions a new background worker and a new oracle connection. Each instance of the query class is supposed to query the database, wait a specific amount of time then query again. The first time a trigger an event (which creates a new instance of the query), the background worker RunWorkerCompleted event will not fire, however everytime I trigger an event after that (whether its the same one or a different one), the event will work fine. If I remove the oracle database connection instance (and all related code), this problem goes away. Does this make any sense to anyone. I dont even need to use the connection instance, as long as I try to create a new one, this keeps happening. I am so confused!
Any help would be great
Public Class Query
Implements IDisposable
Private m_trigger_time as Datetime
Private m_cfg as TriggerCfg
Private m_handle as System.Threading.AutoResetEvent
Pivate m_connection As Client.OracleConnection
Private WithEvents m_bgworker as System.ComponentModel.BackgroundWorker
Public Sub New(ByRef cfg as TtriggerCfg, ByVal time as DateTime)
m_cfg = cfg
m_trigger_time = time
m_handle = New System.Threading.AutoResetEvent(False)
m_bgworker = New System.ComponentModel. BackgroundWorker
m_connection = New Client.OracleCOnnection(My.Settings.OraConnectionString.ToString)
m_bgworker.RunWorkerAsync
End Sub
Private TriggerAction(ByVal sender as Object, ByVal e as System.ComponentModel.DoWorkEventArgs) Handles m_bgworker.DoWork
...Do db query
m_handle.Wait(New TimeSpan(0,0,10),False)
...Do db query
End Sub
Private Sub Completed(ByVal sender as Object, ByVal e as System.ComponentModel.RunWorkerCompletedEventsArgs) Handles m_bgworker.RunWorkerCompleted
Dim worker as System.ComponentModel.BackgroundWorker = Ctype(sender, System.ComponentModel.BackgroundWorker)
If e.Error IsNot Thing Then
MsgBox(e.Error.Message)
Else If e.Cancelled Then
MsgBox("Cancelled")
Else
Me.Dispose()
End Sub
End Class
|
|
|
|
|
Hi all,
I am using Visual Studio 2008 and Sql Server 2005
I am use some CLR Programming in my windows application and it goes fine.
But I got Some Error during Transaction in my application.
Error : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
So, What is the Problem and How Can I Solve this Type of Problem.
Thanking you very much.
Arindam Banerjee
Sr. Software Developer
Rance Computer Pvt Ltd.
Kolkata (India)
|
|
|
|
|
You should be asking this in the SQL Forum. It has nothing to do with VB.NET.
|
|
|
|
|
I have developed a VB6.0 application and created Report using Crystal Reports 9. When I run the application, and opened the reports, the reports showed up correctly in my machine in which crystal reports is installed. When I build the EXE and run it in another machine without VB & Crystal Reports, My application is opening up but the Report is not opening up, instead it gives an error message "Run-time Error 429. Activex component can't create Object"
I feel probably some DLL or OCX files to be registered to make crystal reports work in the client machine. I also tried copying some DLL files and OCX files to system32 folder, but in vain. Probably some more files are missing.
Anybody Pls provide me the complete package of files to be copied in the client machine to make my Reports open up.
Thanks in advance
|
|
|
|
|
Why on earth would anyone use VB6 ? It's rubbish, it was always rubbish, and it's been a dead language for many years now.
Your VB app doesn't need the compiler to work, but your report DOES need Crystal Reports to be on the client machine.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Some of my colleagues also insisted the same solution to install crystal reports in the client machine. But it seems that there is an alternate way that doesn't need the Crystal Reports to be installed in the client machine. It only requires registering a set of DLL and OCX files. FYI i am using windows XP. Can u pls tell me the alternate way.
|
|
|
|
|
Search for "Crystal Reports distribution files" or some such thing... it is a long list of files that need to be part of your installer.
|
|
|
|
|
Search the web for the 'Crystal reports merge modules'
(name of the file is CRRuntime_12_0.msm' at least the one I have)
Add this merge module to your setup project and it will install everything it needs to run Crystal reports. (right mouse click on the project --> add --> merge module)
A little warning your setup file will grow with approximatly 40Mb
|
|
|
|
|
Is it possible to run a separate setup to install the files required for Crystal Reports alone. Since my application is a small one, I am jus going to copy the EXE alone and no other files.
|
|
|
|
|
I guess you could just create a setup project and only add those merge modules (and the exe if you want) using Visual studio.
If you do this be shure to uncheck the .NET framework condition in the setup project otherwise it will try to install that aswell and you don't need it, don't know if CR needs it tho, you might want to check that.
|
|
|
|
|
VB6 doesn't use .MSI based setups. Merge module wont do him any good unless he's using a third party packaging solution, which I doubt.
modified on Monday, November 24, 2008 9:51 AM
|
|
|
|
|
It does - you can use the MS Installer to create the MSI.
|
|
|
|
|
It's not integrated with the IDE in VB6 and is a seperate product. MS Installer is not a product to create installations, but it is a service used to install .MSI databases. The only thing that MS has that can edit .MSI's is Orca, I believe. You'd have to use a third party product, that is friendier than Orca, to generate an MSI installation and use the merge modules.
|
|
|
|
|
Oops... it's not MS Installer... Visual Studio Installer[^] is what I meant. 
Yes, it is not integrated with the VB6 IDE, but you can create MSI files using this app.
|
|
|
|
|
Google for "Crystal Reports runtime install" or "Crystal Reports redistributable" and you'll find the installer to do this.
|
|
|
|
|
since your app is a small one why not rewrite the app into dotnet and move away from a dead product. You will be lucky to find the installation files for VB6/CR.
You can distribute the appropriate DLLs and register them. Finding them will be a challenge.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
manohar_balu wrote: I have developed a VB6.0 application
Why? VB6 has been dead for at least 5 years. If you are going to be doing VB programming, you should stick to VB.NET. It'll look better on a resume or c.v. than VB6 ( unless it is completely maintenance work you are doing ).
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Dear Fellows,
I have created a Windows service, which is supposed to start a notepad.exe. But the problem I am experiencing is that my service never starts but gets stuck at the myService.Start() in the following lines of code, I am able to start the service when i include a form_Load or Button_Click. Can somebody please help and tell me is it important to include a windows form to my service project to get the service started. Here is my code:
Private Sub CheckService()
' Verify to see if the service is installed.
Dim installedServices() As ServiceController
Dim tmpService As ServiceController
Dim i As Integer = 0
installedServices = ServiceController.GetServices()
For Each tmpService In installedServices
If tmpService.DisplayName = "MyService" Then
myService = tmpService
myService.Start()
End If
Next tmpService
End Sub
Thank you in Advance
|
|
|
|
|
It's been a while since I've done a windows service, if I remember correctly you should be able to just instantiate the service control by name and then start the service. You shouldn't have to loop all services for the correct name.
dim oService as New ServiceController("MyService")
oService.Start
1. Ensure your service is installed in the windows services.
2. Ensure the service is started and working.
3. Create a sep. project for the GUI. The windows service project shouldn't have a form itself. The GUI project will be responsible for starting, restarting, etc the service. Use a notifyIcon if necessary.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Well thank you for your time, the stupid thing i was doing is that I was not implementing a separate project, but was doing everything in the same class. Well i could start the service now. I would really be thankfull if you help my new problem. The problem is that I need to run an exe from this service. i tried the Process.start in the service onStart() sub, but ended up with nothing. i have set the service property to "Interact with desktop", but no luck! Please help if possible.
|
|
|
|
|
Does it stop on the myService.Start() line when trying to start the service in the Services applet in Windows or when running the project locally in Debug mode?
Keep It Simple Stupid! (KISS)
|
|
|
|
|
Well thanks Ben for your time, the stupid thing i was doing is that I was not implementing a separate project, but was doing everything in the same class. Well i could start the service now. I would really be thankfull if you help my new problem. The problem is that I need to run an exe from this service. i tried the Process.start in the service onStart() sub, but ended up with nothing. i have set the service property to "Interact with desktop", but no luck! Please help if possible.
|
|
|
|
|
Hello All,
I am trying to create a screensaver slideshow that displays a set of images from a folder. Also I would like to be able to control the delay between each showing. I've seen many articles but thus far the ones I came across are different from what I'm trying to do. If you know of a good article on this, please let me know. Thank you in advance for your help.
|
|
|
|
|
|
Hello,
Thank you so much for responding, but I still need to know if there is a tutorial or an article out there on how to create this program.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
