SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Again SQL Server 2008 problem
Goto page 1, 2  Next
 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Again SQL Server 2008 problem
Author Message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Again SQL Server 2008 problem Reply with quote
With the release of SQL Server 2008 I've tried to use it with SQL Assistant but I can't connect it.
I've tried also to connect with Sql Management Studio 2008 to an Sql Server 2005 database but still can't connect.
With SQL Server 2008 Beta 2 worked but with final version doesn't.
Any ideas ?
Sorin
Wed Aug 13, 2008 3:44 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6515

Post Reply with quote
Which version of SQL Assistant are you using?
Wed Aug 13, 2008 11:14 am View user's profile Send private message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Reply with quote
3.5.30
Thu Aug 14, 2008 1:13 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6515

Post Reply with quote
I'm not sure what Microsoft changed/broke in the latest release. 3.5.30 was/is compatible with all previous SQL 2008 release candidates. So I guess a new compatibility update is needed again for supporting SQL 2008 in order to catch up with latest Microsoft changes.

By the way, the "final" release that you have mentioned was actually released to manufacturing on Aug. 6, which is less than a week ago and the on-line download is available only for a few days.. :)

I would expect that it is going to take several weeks before a compatibility patch become ready. On the other had, I don't know if there will be any new updates released for version 3. We are currently actively working on a new major version.
Thu Aug 14, 2008 1:53 am View user's profile Send private message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Reply with quote
Hi
Here are some screenshots






If you have a beta (build) of this new release I'll be happy to test it.
I was testing all versions of this product and I want to try to make it better (especialy on 2008 and Vista).
Thank's

Sorin
Thu Aug 14, 2008 2:29 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6515

Post Reply with quote
Thanks for the info.

A beta version is not yet available at this time. We will post an announcement on this board as soon we reach that milestone.
Thu Aug 14, 2008 8:35 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6515

Post Reply with quote
We have tried the latest SSMS release 10.0.1600.22 that comes with the latest build of SQL 2008 and so far we are unable to reproduce this issue. Could you please explain again what is wrong? Can you connect to SQL 2008 using Notepad and SQL Assistant configured to use ADO.NET connection type with Notepad? Is there a problem with SQL Assistant silently intercepting and sharing connections in SSMS 2008? The screenshot shows something really weird in the Server name property, displayed as SQLQuery1. Is that a shared connection or something you entered manually?
Sun Aug 17, 2008 10:54 pm View user's profile Send private message
lodmit



Joined: 25 Aug 2008
Posts: 4
Country: United States

Post Reply with quote
I am having same problem with SQL 2008 Management Studio release.
My configuration:
OS Vista Ultimate SP1
SQL assistant 3.5.30


[/img]



Mon Aug 25, 2008 3:26 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6515

Post Reply with quote
Can you connect with Notepad?

Please don't consider the above question stupid. We need to figure out whether the problem is caused by SSMS not providing a valid connection pointer or by the connectivity itself.
Secondary, which connection type is currently selected in the settings? ADO.NET or ODBC?
Mon Aug 25, 2008 3:37 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6515

Post Reply with quote
Which exact version and build of SQL 2008 Management Studio are you running?
Mon Aug 25, 2008 6:26 pm View user's profile Send private message
lodmit



Joined: 25 Aug 2008
Posts: 4
Country: United States

Post Reply with quote
Yes I can,
I can connect with notepad and with SQL 2005 Management Studio
here is the SQL 2008 Management Studio information.
Current connection is ODBC.


Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.3053
Operating System 6.0.6001
Wed Aug 27, 2008 12:25 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6515

Post Reply with quote
Thanks. this info is helpful.
Wed Aug 27, 2008 12:27 pm View user's profile Send private message
lodmit



Joined: 25 Aug 2008
Posts: 4
Country: United States

Post Reply with quote
I figured out.
In Vista I have to run SQL Assistant as Administrator.
It works now.



or use this:
http://www.howtogeek.com/howto/windows-vista/always-start-an-application-in-administrator-mode-on-windows-vista/
Wed Aug 27, 2008 1:55 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6515

Post Reply with quote
Cool. Thank you for the update
Wed Aug 27, 2008 5:15 pm View user's profile Send private message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Reply with quote
Doesn't work for me even with Administrator
I have same configuration as lodmit.
Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.3053
Operating System 6.0.6001

In notepad it's working.
Mon Sep 01, 2008 2:39 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.