|
There is an application in VB6 and n no. of user are using that application (.exe). In this applicatin (.exe) every user are interacting with a recordset of SQL Server 2000. If any of user update or delete any of row, a message should be sent to every users telling them that a specific id's row is updated or deleted by <username> in a message box.
I think this can be done by using recordset's dynamic property i.e. "Row Update Notification Property" and "Row Delete Notification Property". But i do'nt know exact coding for it.
Please guide me.
Thanks and Regards
Girish Kumar Sharma
|
|
|
|
|
Girish481 wrote: Row Update Notification Property
This won't tell you the backend database was modified, only that the row in that copy of the recordset was changed.
You're looking for SQL Server Notification Services[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks for your reply. Actually, i want that if any user update a specific column or delete the row in recordset; a message should be sent to every user at the same time.
Can you please provide me the way by which i can install SQL Server Notification Services. The link you provided me tell about services; but how to install?
Girish Kumar Sharma
|
|
|
|
|
Items 2 and 3 in this[^] list will let you download NS2.0.
And if you click on this previous link I gave you, there is a section dedicated to Installing it.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks. I downloaded the exe file for NS and will try to install on my system. I will let you know if, i found any error. I hope you will favour me in future also.
So many Thanks.
Girish Kumar Sharma
|
|
|
|
|
I downloaded the required exe file and run on my machine; but after installing it:- (I am using SQL Server 2000)
1. How can i start the Notification Service (NS) in Services.
2. How can i use Notification Service for my VB6 Application.
Thanks
Girish Kumar Sharma
|
|
|
|
|
i really can't walk you through the entire process. It would take more than an article to explain it all. Just follow the documentation in the first link I posted and you'll find everything you need. I don't know of any VB6 examples that are still on the Web. It looks like everything has been converted over to VB.NET.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
i have some problem doing my project i hope that all the kind hearted people around the world will somehow advice me how to go with it thank you. As for now i have to develop a client program that can download and upload to the server with Authentication. Using VB Graphic User Interface but programmed by C.
-- modified at 23:49 Monday 28th August, 2006
|
|
|
|
|
What you want to do is very labor intensive. It'll take so much code to do this that it's impractical. You'd be much better off writting the C code as a COM .DLL and calling it from the VB form.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I am trying to get this ActiveX control to work within Word 97:
http://www.codeproject.com/opengl/ntgraph3d_atl.asp[^]
I havr registered the control and made checked the box in the reference table, the control appears on the document as it should, but I just can't get it to draft any of the examples:
Private Sub CommandButton1_Click()
NTGraph3D1.ClearGraph
NTGraph3D1.AddElement
For i = 0 To 40
x = ((i - 20#) / 20#) * 3.15
For j = 0 To 40
NTGraph3D1.AddElement
z = ((j - 20#) / 20#) * 3.15
y = Sin(x) * Cos(z) + 2#
NTGraph3D1.ElementType(j) = 0
NTGraph3D1.ElementLineColor(i) = RGB(255, 0, 0)
NTGraph3D1.PlotXYZ x, y, z, j
Next
Next
NTGraph3D1.AutoRange
End Sub
Am I supposed to make any declarations or something?
Thanks
|
|
|
|
|
Is it possible to show image on a button??
I want to show a button in an image instead of just showing the text word.
***
I have found the solution, by setting the STYLE to Graphics then choose Select on PICTURES.
-- modified at 22:40 Tuesday 29th August, 2006
|
|
|
|
|
|
VB6 doesn't have an ImageButton.
The VB6 Button control does have an Image property. Being as I haven't used VB6 in about 6 years, I can't remember how it worked!
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I recently created a program that allows you to put in a url in the textbox
and from that url you can download a program from the site you put in the textbox (as long as it is a link to the download part of that site) without accessing the internet explorer or your internet browser being open.
my question is that to access the internet you have to type in your username and password (the internet is using a proxy server) the error I get is 407 proxy authentication error (in other words it is blocking the program from downloading and asking the program for a password and username to access the internet. WHAT CODE CAN I USE SO THAT I CAN DOWNLOAD ANY PROGRAM WITHOUT THE
PROXY ASKING THE PROGRAM FOR THE USERNAME AND PASSWORD.
my EMAIL IS amill141@eq.edu.au
|
|
|
|
|
A***** wrote: from that url you can download a program from the site
How are you downloading this file and from what type of server? HTTP or FTP? In the .NET Framework 2.0, there is the HttpWebRequest class that can download files from a web server, and also has a .Proxy property where you can supply the proxy server IP or name, username, and password for the proxy.
There is NOTHING you can do to get around the proxy server without specifying any credentials.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Coming from VB6, I'm jumping straight to Visual Studio VB.NET 2005 Express (skipping VB.NET 2003). When I search this site or the Web for VB.NET 2005 article or sample code I get a lot of hits for VB.NET 2003 articles and code.
1) Can I assume that articles and code for VB.NET 2003 will work in VB.NET 2005?
2) I'm particularly interested in File and Directory manipulation. Reading all file names in a directory tree, changing their names, creating directories, copying, deleting etc. Does VB.NET 2005 have significant improvements/changes in this area over VB.NET 2003?
Thanks.
|
|
|
|
|
A lot of the VB.Net articles use code that is not compatible with VB2003 (such as generic collections and the like) but it is not usually too much trouble to convert it back to 2003 (and even - shock, horror) VB2002.
|
|
|
|
|
Freddie Code wrote: Can I assume that articles and code for VB.NET 2003 will work in VB.NET 2005?
In most cases, yes. ASP.NET is potentially more problematic though.
Best thing to do is work with the 2003 articles and then search MSDN for what's changed between 2003 and 2005.
Kevin
|
|
|
|
|
Hello codeprojectusers, I am writing a very simple web server for no real reason and if does kind of work, but when I get a request from a client I get an error from visual basic 2005 .net. It says that access to the folder requested was denied.
this is the code i am having a problem with
Dim fs As FileStream = New FileStream(filename, FileMode.OpenOrCreate)
I have no idea how to fix this without using that request permission method which I cannot get to work, soooooo I would appreciate any help, Thanks
Aaron
|
|
|
|
|
Use application folder of system with system.environment.application. It will never give up access denied.
Thanks & Regards
Kumar Prabhakar
abc
|
|
|
|
|
Thanks I will try that.
Aaron
|
|
|
|
|
i finish my project in vb.net 2003 and sql server 2000 now i need to make setup package and i don't know how to install data base on target machine
i need to install database and msde on client computer
how?
ma_refay
|
|
|
|
|
I have a project I wrote that uses MSDE for a database and installs it with the program. If your interested email me and i will send you the program. It's pretty big though because of the MSDE so we will have to send it through messenger or some thing along those lines.
Pablo
|
|
|
|
|
Check out this link
http://msdn2.microsoft.com/en-us/library/49b92ztk.aspx
Navi
|
|
|
|
|
I am working with VB.Net 2003; I see a lot of programs being designed a lot like Outlook. With the left pane with options and the right pane showing like the data grid or something. Then you can click on something like add new record in the left pane then an input box will come up so you can enter the data for a new record and save it.
Is there a template that allows you to do this? If so, can someone tell me where to go to get it?
Thanks!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
