Author |
Message |
sangha
Joined: 19 Dec 2006 Posts: 18
|
|
SQL Assistant crashes Notepad |
|
In the Target tab I have set Notepad to use SQL Server.
Now in notepad when I type SELECT and press SPACE I get the SQL Assistant Connect dialog. When I press connect Notepad crashes and I am getting "An unhandled win32 exception occured in notepad.exe".
|
|
Tue Dec 19, 2006 8:04 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
I am unable to reproduce this. Could you please provide more information about the connection? Is that an Oracle or SQL Server connection? What client version do you have installed? Can you connect to other servers?
|
|
Tue Dec 19, 2006 10:31 pm |
|
![](templates/GreenTech/images/spacer.gif) |
sangha
Joined: 19 Dec 2006 Posts: 18
|
|
|
|
I am using SQL Server connection.
SQL Assistant version 1.0.55
Notepad version 5.1
I tried wordpad. It works fine there. But I found a little problem while calling the shortcut to open Target Options form. This problem is also with the Connect form. Check the caption of the form. Looks like some font problem while setting the caption.
|
|
Tue Dec 19, 2006 11:28 pm |
|
![](templates/GreenTech/images/spacer.gif) |
sangha
Joined: 19 Dec 2006 Posts: 18
|
|
|
|
Also I found out while using Wordpad. Everytime I open wordpad I have to go through the connect form. Is there any way to skip this step by saving connection details.
|
|
Tue Dec 19, 2006 11:30 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Connection properties (server, user, password) are saved automatically unless you disable that option. On the Connect dialog you can select one of the previously used connections from the Server Name drop-down list.
The Connection dialog doesn't appear only if you use SQL*Plus, SQL Analyzer and some other database programs which we call "known IDE" and where we can intercept the existing database connection established by the editor and join that connection. So if we can join this connection the Connect dialog is not needed. In all other cases we show the Connect dialog.
|
|
Tue Dec 19, 2006 11:56 pm |
|
![](templates/GreenTech/images/spacer.gif) |
giggles220
Joined: 01 Dec 2006 Posts: 22 Country: USA NY |
|
|
|
Is Management Studio part of the list where we shouldn't get the connect dialog b/c I do get it there. I find it annoying but not annoying enough to not use sql assistant. It would be great if I didn't have to "connect" just to use sql assistant especially since I just connected via SSMS.
|
|
Wed Dec 20, 2006 8:40 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
Is Management Studio part of the list where we shouldn't get the connect dialog b/c I do get it there. I find it annoying but not annoying enough to not use sql assistant. It would be great if I didn't have to "connect" just to use sql assistant especially since I just connected via SSMS. |
There are several versions of Management Studio that come with different versions of SQL Server and Visual Studio/Team. We can handle connection intercept in some of them but not all. These versions have some differences that make it impossible to apply the same technique to all of them not to mention using different connection methods ODBC/ADO/etc… We are working on improving the algorithms and adding support for more protocols. Connection intercept is probably the most complicated part of the product and requires a lot of hacking in a good sense of that word and a lot of debugging. Please stay tuned and download new builds/versions as they become available.
|
|
Wed Dec 20, 2006 9:36 am |
|
![](templates/GreenTech/images/spacer.gif) |
sangha
Joined: 19 Dec 2006 Posts: 18
|
|
|
|
I tried using Notepad on another machine. It crashed there too. Th OS on both the machines is Win XP Pro SP 2. And the connection I used was SQL Server in both the cases.
|
|
Wed Dec 20, 2006 4:57 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
We are checking this issue. I will post an update when available.
|
|
Wed Dec 20, 2006 5:11 pm |
|
![](templates/GreenTech/images/spacer.gif) |
yuan
Joined: 28 Dec 2006 Posts: 1
|
|
having exact same problem on XP when connecting to Oracle |
|
Just ran into the same problem when running SQL Assistant with Notepad as Target.
My system environment is Windows XP, and connecting to an oracle database.
the following is the screenshot showing the error. it looks like a security violation problem.
![](http://upload5.postimage.org/49337/notepad_crash.jpg)
|
|
Thu Dec 28, 2006 3:39 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Hi,
We found the cause of this issue and will have a fix available next week.
|
|
Thu Jan 11, 2007 12:19 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Please upgrade to version 1.0.60 or later
|
|
Tue Jan 16, 2007 10:07 am |
|
![](templates/GreenTech/images/spacer.gif) |
|