Visual Basic

18-Jan-07 1:08

Hi.

I read on microsoft comparison chart that VB express 2005 does not support remote databases which im guessing is that same as shared network database.

is there no other way , perhaps a 3rd party app that can allow this.

Please let me know so i can consider upgrading if need be.

Regards

Robbo

Christian Graus18-Jan-07 1:43

Christian Graus

18-Jan-07 1:43

I suspect this means you can't connect to a remote DB within the IDE, I'm sure the end code can run a DB from anywhere.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

vbbeg18-Jan-07 3:57

18-Jan-07 3:57

Hi Christian

I guess without confusing myself, Im wanting to find out if im able to setup a shared network database. so basically i want to create a multiuser app using a centralised MDB Database where multiple users can read and write to the same database.

can you please confirm if this can be done in VB EXPRESS 2005.

Many thanks

Robbo

Dave Kreskowiak18-Jan-07 8:15

Dave Kreskowiak

18-Jan-07 8:15

Yes, you can. Like Christian said, the code you write can interact with the database without any problem. It's just htat the Express Editions of Visual Studio don't supply and Designers that will write any database code for you.

Dave Kreskowiak
Microsoft MVP - Visual Basic

vbbeg18-Jan-07 8:18

18-Jan-07 8:18

Thanks Dave. Its amazing how your always around to assist us all. I'll do some good searching for some examples etc. and of course if one comes to mind from you it will be very much appreciated. Smile | :)

Robbo

Steven J Jowett19-Jan-07 4:29

Steven J Jowett

19-Jan-07 4:29

I use MS SQL Express 2005 for a Weighbridge application I have written and access the database from other computers on the network, including PC access over a WAN connection.

You should be aware that SQL Express, when installed, is configured as a stand-a-lone database, i.e. does not allow remote connections. You will need to change this within the SQL Server Configuration Manager program.

Steve Jowett

vbbeg19-Jan-07 6:01

How to disable PrintScreen button

19-Jan-07 6:01

Hi Steve

Thanks for you reply. basically at the moment my app is built with an MDB Database and was looking to get into how i can make it a mulituser app. is it only as simple as setting MODE=share deny non to connectionstring. Im sure there more to read on etc. can you offer and more assistance or material i can use.

Thanks a million.

Robbo

emadkemo18-Jan-07 0:07

emadkemo

18-Jan-07 0:07

is there any way to disable the print screen button

Re: How to disable PrintScreen button

Christian Graus18-Jan-07 1:46

Christian Graus

18-Jan-07 1:46

A system wide hook, perhaps ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: How to disable PrintScreen button

emadkemo18-Jan-07 3:38

emadkemo

18-Jan-07 3:38

Thanks a lot for your reply
but I don't Know what you mean by
A system wide hook

Re: How to disable PrintScreen button

IqbalVB20-Jan-07 16:35

IqbalVB

20-Jan-07 16:35

You can unplug the keyboard cable, or don't press the prinscreen button. Ha ha that's a joke.
Actually, you can handle it by add some action like showing a message when user press it and delete the image file from picture taken, by this:

Private Sub formname_keydown(Byval sender as object, byval e as system.keycode)<br />
If e.keycode=key.printscreen = true then<br />
msgbox("Sorry, you can't print the screen for a reason","Warning",vbcritical)<br />
system.clipboard.clear<br />
End If<br />
End Sub

Write service to fail or crash.

japel17-Jan-07 23:22

japel

17-Jan-07 23:22

Hi All

I am writing am app that I can call from the windows services recovery tab that emails me when the service fails.

At present I have a written a service that has a counter that has a 10 second delay that throws an exception.

But on testing the service it counts 10 ten sec's and crashes but never launches the test app from the service recovery tab (Notepad).

Is the unhandled exception the same as a service failing?

How do I write an app that crashes for testing?

IDEAS....

P.S. What is even more annoying is that if I was writing a service it would have heaps of errors to debug and now the apposite Mad | :mad:

Thanks

When people make you see red, be thankful your not colour blind.

Re: Write service to fail or crash.

Jason McBurney18-Jan-07 6:09

Jason McBurney

18-Jan-07 6:09

Take a look at dainel's article on exceptions:
Exception Best Practices[^]

It has a lot of good informaiton regarding general exception handling. Also a service should deal with the errors raised from within. In the case where an error is unhandled the domain error handler will attempt to catch it. You may wish to install a error handler in the System.AppDomain.CurrentDomain.UnhandledException
Event. This can of course call your:

japel wrote:
test app from the service recovery tab (Notepad).

You can only be young once. But you can always be immature.
- Dave Barry

Re: Write service to fail or crash.

japel18-Jan-07 14:27

japel

18-Jan-07 14:27

The article was interesting from a error handling point of view.

I was looking for the opposite, I need a service to fail the triggers the service recovery option and let's me run a program.

Thanks

When people make you see red, be thankful your not colour blind.

Re: Write service to fail or crash.

Jason McBurney19-Jan-07 3:14

Jason McBurney

19-Jan-07 3:14

Will your requirements allow you to start recovery process from within the service? Or does it have to be in a differnt app domain?

~Jason

You can only be young once. But you can always be immature.
- Dave Barry

Find text from a web page

samiknandi17-Jan-07 22:39

samiknandi

17-Jan-07 22:39

My problem is that i am not able to collects from a URL automatically.
For example
i am created one window form.there is three control 1) text box for URL 2) Button for Get Data 3) textbox for

showing get data. now i want to put into URL text box -

http://www.pricerunner.co.uk/sound-and-vision/vision/tv/712631/prices. then i should click the get data button.

then it will return pricerange i.e £1437.75 - £1999.99 or lowest price only £1437.75. and that value will displat

into show data textbox.

pls let me help, how can we do this work. if we can sucess we will do it into a batch process.

We can use any techenology into .net framework

thanks in advance

Samik nandi

ChandraRam17-Jan-07 22:53

ChandraRam

17-Jan-07 22:53

samiknandi wrote:
http://www.pricerunner.co.uk/sound-and-vision/vision/tv/712631/prices. then i should click the get data button. then it will return pricerange i.e £1437.75 - £1999.99 or lowest price only £1437.75. and that value will displat into show data textbox

You will need to parse out the price range from the data you get.

samiknandi17-Jan-07 23:07

samiknandi

17-Jan-07 23:07

Thanks for the reply. can you give me the example.

samik nandi

ChandraRam17-Jan-07 23:11

ChandraRam

17-Jan-07 23:11

You take a look at the complete data, see if you always will find the words "Price range:" in all of such pages that you want to view, and pick up the data from after the position of the string "Price range:".

You will need to look up functions to search for a substring with in a string and another for extracting a substring from another string.

HTH

samiknandi17-Jan-07 23:40

samiknandi

17-Jan-07 23:40

thanks again for the reply.
if you kindly give me some code example for button click, so i can try with that. otherwise i am not able to do that.

thanks in advance