Visual Basic

25-Sep-06 8:56

Hi - We have an interface which call a stored proc, sends in input parameters which in turn then inserts into the table.

This sp by itself, exec "sp name", runs for 6 minutes, don't ask, it is a huge dB!! I have set a command timeout of 400 seconds and my interface still comes back with a timeout issue.

Is there anything else we could set?

Thanks!

nlindley725-Sep-06 9:42

nlindley7

25-Sep-06 9:42

I'm sure you've already tried but I would suggest putting it at 500; maybe it takes a little more than 6 minutes? Otherwise it shouldn't time out... let me know if you've tried that, and i'll look into it a little more.

Nate Lindley, .NET Aficionado

VK-Cadec25-Sep-06 9:48

25-Sep-06 9:48

Yes - I have tried that as well, setting it to 500.

Exact Error Message: system.data.sqlclient.sqlexception: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Right now only changing the Command timeout property - should we change the commandtimeout for connection object as well?

thanks.

Dave Kreskowiak25-Sep-06 9:59

25-Sep-06 9:59

Yes, you can do that. But, 6 minutes is a LONG time to wait for a command. I would recommend seting this up and running the SP without waiting for any return values. You can use SQL Server's Notification Services if you want something returned.

Dave Kreskowiak
Microsoft MVP - Visual Basic

VK-Cadec25-Sep-06 10:02

25-Sep-06 10:02

What do you mean - like a task?

I have a message - after the user clicks submit button to upload the data, it comes back with "successful" message.

You mean something that runs in the background? How would they know if it was successful?

Thanks.

Dave Kreskowiak25-Sep-06 10:10

25-Sep-06 10:10

SQL Server support sending COM-based notifications back to registered clients. For SQL Server 2000, you have to install Notification Services seperately. For 2005, SQL Server comes with it.

Notification Services[^]

Dave Kreskowiak
Microsoft MVP - Visual Basic

VK-Cadec26-Sep-06 4:36

26-Sep-06 4:36

Hi - solved this by setting the command timeout to 0 - this implies unlimited - the customer doesn't mind waiting how ever long it takes - as long as it is done successfully.

Thanks.

Dave Kreskowiak26-Sep-06 12:34

Re: .NET's BindingNavigator

26-Sep-06 12:34

6 minutes?? Wait until there's more data in there. 6 minutes will be an eternity to wait. I would have long since thought the app failed by then.

But, I'm not bashing you at all!! Sometimes the customer just doesn't know what they're getting into...

Dave Kreskowiak
Microsoft MVP - Visual Basic

.NET's BindingNavigator

nlindley725-Sep-06 8:33

nlindley7

25-Sep-06 8:33

Hey,

My question, if you couldn't already guess, has to deal with the .NET BindingNavigator. I'm using it to sort through some records and thats all fine and dandy. But my question is, when I am trying to search for a record based on its PK, is there an easy way to do it via the BindingNavigator? Or do I have to open a connection, fill a new dataset, and search for the pk via data table/data row access? Anyone who has used the BN for this purpose, or anyone who just wants to comment on the situation, let me know what you think and it will be much appreciated.

Thanks!

Nate Lindley, .NET Aficionado

Dave Kreskowiak25-Sep-06 9:56

25-Sep-06 9:56

The BindingNavigator doens't expose any method of searching, so no, it's really not cut out for this. You're best method is to get the PK, open a new connection and fill a dataset with a query specific for returning records with that PK.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Key event handlers

neosri25-Sep-06 7:15

neosri

25-Sep-06 7:15

Hello,
I am facing a problem in key event handler for datagrid textbox cells. The event is fired for all the function key presses except for F2 and F5 keys. Any ideas or pointers are welcome.

Thanks,
Neo

Re: Key event handlers

Dave Kreskowiak25-Sep-06 9:51

25-Sep-06 9:51

F2 is reserved by the DataGridView to trigger editing whichever cell is currently selected. Change the DGV's EditMode property if you want to use this key for something else.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Key event handlers

neosri26-Sep-06 3:39

neosri

26-Sep-06 3:39

Thanks...

But we are using dotnet 1.1. I guess this editmode feature is not available in 1.1... Is there any other alternative to make this work?

Re: Key event handlers

Dave Kreskowiak26-Sep-06 5:09

26-Sep-06 5:09

Not as far as I can tell. F2 is still reserved for the DataGrid. Keyboard shortcuts for DataGrid[^].

The keys are being handled by the DataGrid control before they're getting to the grid's TextBox. That's why you can't see them in that handler.

Dave Kreskowiak
Microsoft MVP - Visual Basic

database problem

amaneet25-Sep-06 6:40

amaneet

25-Sep-06 6:40

Sir,
can i find out whether the database sqlserver is installed on the machine before making the connection.
Thanks

Re: database problem

Dave Kreskowiak25-Sep-06 6:53

Re: Print Document from vb

25-Sep-06 6:53

On which machine? The local machine you application is running on, or on the remote server you're trying to connect to?

In either case, there's alot that can go wrong, other than not being installed, with trying to connect to an SQL Server, so I fail to see what the advantage of seeing if it's installed gives you.

Sure, it can be installed, but is it running? Is there a network path to the server? Is there a firewall in the way, blocking access? Is the database you're trying to connect to available? ...?

Dave Kreskowiak
Microsoft MVP - Visual Basic

Print Document from vb

Tomic25-Sep-06 5:54

Tomic

25-Sep-06 5:54

kindly help in fixing the code below

Dim dprinters As Printer<br />
 For Each dprinters In Printers<br />
 Printer.Print dprinters.DeviceName; " on "; dprinters.Port<br />
 Next dprinters<br />
 Dim a As Integer<br />
Dim b As Integer<br />
a = 5<br />
b = 7<br />
Dim s As String<br />
s = "are figures"<br />
Printer.Print a; Spc(1); b; Spc(1); s

when the code was placed in form_load it printed but when moved to the cmdprint_click it did not load.
how can I print from clicking a command button

Also how can I specify the size of the paper I want to use because i want to use a custom paper to print.

Fikunmi Feyijin
Hicad Systems
Nigeria

Dave Kreskowiak25-Sep-06 7:11

Class terminates immediately VB6

25-Sep-06 7:11

The code should work just fine. It doesn't matter which event handler you put it in.

To change the paper size, all you have to do is set the Height and Width propeties of the Printer object:

Printer.Height = paper height in twips
Printer.Width = paper width in twips

where 1" = 1440 twips.

Printer and Printers documentation[^].

Dave Kreskowiak
Microsoft MVP - Visual Basic

Dustin_B25-Sep-06 4:17

Dustin_B

25-Sep-06 4:17

I am trying to instantiate a class from an external COM application. After stepping through, it seems as though the instance is being initialized and then immediately terminated for some reason. This also happens when I try to debug the problem using the immediate window from the project that contains the class I am trying to reference.

Here is how I am trying to instaniate the class:

Public moServer As Wrapper.CommConnector
Private WithEvents mwDeviceCommMgr As Wrapper.CommManager
...
    Set moServer = New Wrapper.CommConnector
    Set mwDeviceCommMgr = moServer.CommGateway

This program throws an error on

Set moServer = New Wrapper.CommConnector

because the class terminates immediately.

Here are the initialization and termination methods for Wrapper.CommConnector:

Private Sub Class_Initialize()

    Set xCommConnector = New Server.CommConnector

End Sub

Private Sub Class_Terminate()
    On Error GoTo Unanticipated_Error
    
    Set goCommConnection = Nothing
    Set xCommConnector = Nothing

End Sub

Server is a VB.NET application that is known to be solid code.

Thanks,
Dustin

Dave Kreskowiak25-Sep-06 6:55

25-Sep-06 6:55

It would help to know what the error message is. The VB6 code looks good, so the only "quick" things to check are the .NET assembly is registered properly (using REGASM, not REGSVR32) and that the .NET Framework version that your assembly needs is installed properly.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Dustin_B25-Sep-06 10:39

Dustin_B

25-Sep-06 10:39

The error message I get when I try to run the external application alone in debug mode is "Wrapper.exe has encountered a problem and needs to close." Then if I click Debug, I get the Visual Basic error dialog:

Runtime error '-2147023170 (800706be)':
Automation error
The remote procedure call failed

If I start the Wrapper in debug mode and then run the external application in debug mode, I get "Run-time error 430: Class does not support Automation or does not support expected interface."

I am pretty sure the problem is that the CommConnector class immediately terminates in Wrapper.exe, and thus the external application cannot assign xCommConnector as an instance of Wrapper.CommConnection but cannot figure out why. When I step through the code it goes immediately from the End of the Class_Initialize Sub to the Class_Terminate Sub in the CommConnector class in Wrapper.exe

The assembly is registered through building the Server in debug mode in VS 2005 so it is registered correctly, and I have the 2.0 framework, which is what the Server was built on.

Dustin

Dave Kreskowiak25-Sep-06 13:37

25-Sep-06 13:37

You said that the VB.NET is known to be solid code. Is this something that your migrating to expose COM support? Is your VB.NET app only exposing this server when it's running or can any COM client instantiate it without the .EXE running?

Qualifying .NET Types for Interoperation[^]

Dave Kreskowiak
Microsoft MVP - Visual Basic

Dustin_B26-Sep-06 3:37

Dustin_B

26-Sep-06 3:37

I don't believe the problem is with .NET interoperability because I also have a VB6 COM version of the Server that exposes the same types, methods, and variables to the Wrapper as the .NET version. When trying to use the COM version through the Wrapper, I still get the same problem with immediate instance termination.

Dave Kreskowiak26-Sep-06 5:04