|
The .NET Framework SMTP classes currently do not support proxy connections.
|
|
|
|
|
Hi,
I know there's a load of articles about how to avoid the problem of "too many connections" and I have tried searching many of the forums and articles about the topic.
Is there a way to find out how many open connections to an Access mdb using VB.Net 2005.
My program has been used for a long time without any issues, but recently I bought a new PC (with dual core quad processor) and the "too many connections" problem is reappearing.
How is the best way to find out how many connections are open at any point in time.
Thanks for your help.
|
|
|
|
|
Not sure but you should try getting your connections from a pool instead. This is better practice.
|
|
|
|
|
I think you may be running up against the fact that Access is designed as a single user database and should not serve as a neworked DB. Having said that I used one for years with 8 users regularly hanging off it.
Also if you are directly connecting your forms to the database you may be creating a heap of uncontrolled connections. Are you using a DAL. If so use connection pooling.
I would consider the use of Access a fundamental shortcoming, look into converting to SQL Express/Server. This will give you all the control you need and it is a real database. The upgrade/transfer used to be painless (1998).
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
Thank you for your feedback. I am painfully aware of Access shortcomings.
Actually what would be great if someone could advise how to determine the number of open connections at any point in time - is there such a way to find this out?
Thanks in advance for any help.
|
|
|
|
|
maper1 wrote: how to determine the number of open connections at any point in time - is there such a way to find this out?
Since Access is a file-based database, with each client maintaining their own connection information, there is no central control of connections to the database. Because of this, there is no way to determine how many open connections to the database there are.
|
|
|
|
|
Easy question for someone.
Where do I get the control for MAPI
I have VB.Net 2005
|
|
|
|
|
.NET does not have MAPI controls . I used MAPI controls from VB6
'add 2 controls
Microsoft MAPIMessages (call it MAPIMessages1)
Microsoft MAPISession (call it MAPILogOn)
(AxInterop.MSMAPI.dll, Interop.MSMAPI.dll)
Public Class Form1
Inherits System.Windows.Forms.Form
#Region " Windows Form Designer generated code "
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim msg As String
msg = "This is a test email from Iouri."
With Me
.MAPILogOn.SignOn() ' use current user
Do While .MAPILogOn.SessionID = 0
System.Windows.Forms.Application.DoEvents() ' need to wait until the new session is created
Loop
Call SendToEmail("someone@somewhere.com", msg)
.MAPILogOn.SignOff()
End With
MsgBox("e-mail is sent")
End Sub
Private Sub SendToEmail(ByVal Email As String, ByVal msg As String)
With MAPIMessages1
'create a new message and address it
.SessionID = MAPILogOn.SessionID
.Compose()
.RecipDisplayName = Email
.AddressResolveUI = True
.RecipAddress = "smtp:" & Email
.MsgSubject = "VB GENERATED E-MAIL"
.MsgNoteText =msg
.Send(False)
End With
End Sub
End Class
Regards,
Dave
Dave Traister
Software Engineer
ComponentOne LLC
www.ComponentOne.com
|
|
|
|
|
Hi,
I wonder if anyone can help or even guide me in the right direction.
I am developing using VB.Net 2005 and have a Windows Server 2003. I am going to write a routine that can display all the user names in the active Directory as well as maybe other information i.e. computername and more importantly their IP Address.
Can this be done and if so can someone point me in the correct direction or can someone suggest a better way? I am open to any suggestions.
Thanks in advance.
|
|
|
|
|
|
This should be posted in the XML forum.
|
|
|
|
|
Thanks, i'll re-post it there and delete this one.
|
|
|
|
|
Hi! I'm bit confused about Format() (vb6 function) and DateTime.parse function for formatting a date.
i.e when to use which function.
Someone please help me in getting this clear.
Thanks!
Don't Quit
|
|
|
|
|
NEVER use VB6 functions. DateTime.Parse does not format dates, it tries to get a date out of a string. Use the ToString method, you can pass a format string as an argument to turn a date into any string format you like.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
how wil i interact with any hardware using dotNet..?
For example Barcode reader.
J A Nasir K
|
|
|
|
|
There are many kinds of barcode scanner that work in many ways.
If it is a serial one, you should look at the io.ports.serialport namespace.
If it is a "keyboard wedge" type (i.e. emulates keystrokes), then you dont need to do much except look at the "onkeydown" event of the form. Quite often this type of scanner will send a keystroke such as "F20" before the actual barcode.
If it has OPos drivers, there is the Microsoft POS for .NET SDK which you can download and have a look at.
As for other hardware - I've no idea.
|
|
|
|
|
This is a bizarre question. The answer is, read the manual that comes with the hardware. Not all hardware works the same way, as someone else has pointed out already.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi all,
I was wondering if anyone out there knew of good VB.NET beginner tutorials suitable for my 10yo nephew. He is a bit of a geek, but being only 10 I think a lot of the books and tutorials aimed at adults could be beyond his grasp.
If you have any experience with tutorials or books for the younger people out there, please let me know.
Thanks.
|
|
|
|
|
Visual Basic for Dummies is a good book. There are a lot of books about Visual Basic in your local library, with clear images. Your nephew is a quick learner, isn't he?
--Zaegra--
|
|
|
|
|
I don't know of anything specific for children, but the Head First series of books could have what you are looking for. It contains lots of fun ways of learning as well as crosswords and other puzzles at the end of the chapters as a way of retaining the information.
|
|
|
|
|
One book that I used/manipulated when I was first learning programming was: VB.NET Hacks & Pranks. The book is not as bad as it sounds, most of the examples are fun and easy to learn.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios[ ^]
|
|
|
|
|
Thanks for the answers. I was thinking about the Dummies book, but was unsure how good it was.
I will look for the Head First and Hacks & Pranks books.
Unfortunately we have a limited range of titles available here in my area of Australia. I end up getting most of my books from Amazon, but I can't flip through the books there, so I'll if these are available locally first.
Thanks again. Hopefully we'll have a new VB programmer in our midst soon
|
|
|
|
|
hai friends
i m creating a help file for my windows application project with "HTML work shop"
i m in starting stage
first i m creating html files
in one of the html files , i used a image and the image path is like this ..
"D:/Images/Img1.jpg"
my problems is my client can install the software in any drive
he may intall the software in "E" drive
then it is not displaying the image ..
plz help me ...
thanks in advance
vijay
|
|
|
|
|
use relative paths.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Try using Application.StartupPath .
This gets the folder where your application is currently running.
Good Luck!
--Zaegra--
|
|
|
|