I was using the 6 month trial on SQL 2008 and had to create the same database in SQL Express 2008. Both are identical with the same user ID and password to get into that database for both. When I set the default connection to SQL 2008 and start my application the log in appears instantly. When I set the default connection to SQL Express when I start the app there is a 60 second delay and then the Connect Manager appears. I simply SELECT the default connect of SQL Express and the login instantly appears. What can be going on? It is almost as though the delay is some kind of a timeout in relation to SQL EXpress that then causes the Connect Manager to appear. I am running the latest version of StrataFrame

I want to try to set the timeout on the connection to see if this helps. How do you do this in the program.cs file? I think I need to increase the timeout somewhere in the framework related to: SFSPreferencesBO.RetrieveSecurityPreferences(); This may be causing my problem above.

I also have SQL Express tools loaded on the client workstation. When I tried to connect to the SQL Express database, it times out. Then if I try immediately again it connects. I noticed the default connection timeout was 30 seconds on the SQL Manager Tools login. I changed this to 60 secons and it connected the first time with no time out. So from this I am assuming there is some setting at startup of the SF Frameout that needs to be changed to allow a greater amount of time before timeout.

 


 

It looks like you are getting a timeout while filling a BO, as it shows on your stack trace:

at visualOfficeNet.frmMain.tblUCompany_ParentFormLoading() in C:\visualOfficeNet\visualOfficeNet\frmMain.cs:line 525

If you would like to try to change the timeout prior to the filldatatable, you can use the CommandTimeout, increasing it or even telling it to wait forever:

        '-- Establish locals
        Dim loCommand As New SqlCommand()

        '-- Create the command
        loCommand.CommandText = "SELECT * FROM YourTable"

        '-- if you want to wait as long as it takes, set CommandTimeout to zero
        loCommand.CommandTimeout = 0

        '-- if you want to wait like 60 seconds, set CommandTimeout to 60
        loCommand.CommandTimeout = 60

        '-- Execute the command
        Me.FillDataTable(loCommand)