use SqlAssist in VS2008, VS2008 no response for long time.

Open an vs2008 database project,
1. Double click one file to edit;
2. switch between multi-files.
3. try to edit some file

It will take long time to connect to the database, it use the file name or the selected text as the ServerName(please see the following images), then the vs2008 has no response when the sqlAssist try to connect the database server that do not exists. Even after change the settings in the popup window and sqlAssist connected, it will happen again and again if swith to another file. It will waste too much time, so i have to disable the sqlAssit in most time. please fix it.

the sqlAssist should
1. keep and try the last connectString first.
2. popup the connect window every time, let user select first.
3. make the connect time short enough , should let the user to set it.

You got some problems with the installation. The connect dialog shouldn't appear at all. Please see http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=22943 for more info.

I should be an bug. I found that it happened when the project is under source control(Tfs) and the file is not checked-in. when switch to other file and switch back or switch to other program and switch to vs 2008. It seems that it do not happened on the files that checked-out. please fix it.

And http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=22943 is for SQL Management Studio. it seems that it work fine in SQL Management Studio. Now the problem is with VS2008 (Visual Stuido 2008)

Maybe there is some confusion…. SQL Assistant does require a valid database connection. It cannot be used without one. When you open a file from source control, does the editor connect to the database? If no, make it connect and that will fix the problem.

This is an issue with your SSMS connection. It a takes a long time, because SQL Assistant first waits for your editor to connect, then it tries to connect silently using Windows authentication and all that fails it then prompts you for the connection parameters. As you can see from this description, this is not an issue with SQL Assistant.

Why not read the problem carefully?

The problem happened when using SQL Assistant with "Visual Studio 2008" Not with "SSMS" (It has nothing to do with SSMS)
Even with "Visual Studio 2008", the problem only happened when that the file is not check-out. got?

NOTE: After sqlAssit popup the window and succeed to connect to the database, switch to other file and switch back will popup the window again. (you can see the image carefully) maybe you should try it youself. [the same problem happend on every computers]

So it is an bug.

Last edited by Jethrosoft on Fri Nov 13, 2009 2:37 am; edited 1 time in total

No, it is not a bug. It is an expected behavior in situations when the editor is disconnected from the database. Make the editor stay connected to the database and the problem will disappear.

Sorry for incorrectly naming your editor. That makes no difference.

Thanks for you reply first.

First , if it is not an bug, then it is an very bad design. if you use it, you will know it will not improve productivity BUT only decrease productivity.
And, many supported editors(notepad, ultraEdit and so on) will has no connect to the database, then how to use them?
And how to explain when the file checked-out, the problem disappeared? (vs2008 has no connection to database default)

So if it is by design, can you make the sqlAssist work in background BUT not to hang the editor? (Now it block the whole application for long time, so we can work without the SqlAssist to assit till it connect to database.)

It cannot work in the background because it needs that database connection right away.

You have 2 options:
1. Disable the Automatic Syntax checker – this will remove the requirement for an immediate connection and delay the Connect dialog until you start typing something.
2. If possible, in SQL Assistant Options customize settings for your target editor and tune SQL Assistant activation, so that in case you open file in a disconnected editor, it ignores that file and doesn't activate. For example, in the Advanced section you can specify mask for target title. Use % sign as a placeholder for the file name. and add other "fixed" text around that.

Hope this helps.

Thanks very much, i will try it.

But here is some suggestion: (To explan the work in the background )

SqlAssist can implemented in this way:
when the file is open, if there is an connection, then activate SqlAssist, if there is not an connection, then poll the editor for the connection state BUT not to block the editor utill timeout or the connection is ready. if timeout then popup the Connect dialog. I think this is the best way-- only activate SqlAssist utill the connection is ready or popup the Connect dialog when timeout, the timeout should be set by the user.

Thanks.

By the way, SqlAssist has 2 bugs :
1. The font is too small when on chinese windows, the main window is correct but the child window is not (e.g. you can try import/Expot function on chinese windows 2003 R2)
2. The Sql-Assist Options will be reset to the default (it means that all the modification is lost). (e.g. i usually remove all targets BUT SSMS and Vs and change Sql Referce version to MSSQL T-SQL 2008, but sometime all will reset to the default settings. when in 4.7.x, the Options can not be saved, in 4.8.x the Options can be saved but it will be short time to reset to the default).

The envireonment is Windows 2003 R2 standard edition sp2(Simple chinese) + Sql 2008(english) + VSTS 2008 SP1(english)

Thanks for the suggestions.

Can you attach your screenshot of "Import/Expot function on chinese windows 2003 R2" so we can see fonts appear on your screen?

Thanks.

you should check all the child window. it should be simple things.

Thanks! I've forwarded your screenshot to the development team.