473,327 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

SQL 2005 compatability mode

Hi,

We currently have a fairly old product, which was originally only
compatible with SQL 2000.

When we upgraded our server to SQL 2005, the client product gave us a
"This product is not compatible with this version of SQL server"
error.
We put the server into SQL 2000 compatability mode, and things worked.

Then I tested a Windows Vista workstation client. The error returned.

I realise that if we are simply dealing with a client incompatability
with Vista, then I'm in the wrong forum, but what I'm hoping is that
someone knows anything server side, perhaps where SQL 2000
compatability mode becomes ignored for some reason, when the client is
running Vista.

The vendor pretty much no longer exists, and nothing I've been able to
do with Vista's compatability modes has been helpful so far.

Feb 23 '07 #1
1 3689
(js****@visinet.com.au) writes:
We currently have a fairly old product, which was originally only
compatible with SQL 2000.

When we upgraded our server to SQL 2005, the client product gave us a
"This product is not compatible with this version of SQL server"
error.
We put the server into SQL 2000 compatability mode, and things worked.

Then I tested a Windows Vista workstation client. The error returned.

I realise that if we are simply dealing with a client incompatability
with Vista, then I'm in the wrong forum, but what I'm hoping is that
someone knows anything server side, perhaps where SQL 2000
compatability mode becomes ignored for some reason, when the client is
running Vista.
There are several ways that the product could perform this test. None of
which where the client operating system would matter. But if the check
is against @@version of the like, you will always get the message. If
the check is against the compatibility level of the database, it helps
setting it compatibility mode.

You can use Profiler to determine what the application sends to SQL Server.

Maybe the vendor was sloppy, and the message for incompatieble OS is the
same as the message from SQL Server.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Feb 23 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Mark | last post by:
In the Visual C++ 7.1 compiler is there a legacy code mode? This is for non-GUI code. Its easy enough to bring the project in but of course I get a lot of clashes with ISO std C++ conventions. ...
11
by: Mark Broadbent | last post by:
This post is not intended in inflame, so please provide only positive or informative replies. Personally I'm getting a little fed up over certain changes to Framework classes and such -whereby...
6
by: Nak | last post by:
Hi there, I was wondering if anyone knew of a way to maintain compatability with assemblies providing the interfaces remains the same? At the moment if I re-compile an assembly without actually...
2
by: Jack Richardson | last post by:
I am wondering if there is a way to install VS 2005 to run side by side with VS 2003. I would like to begin development using 2005, but do not want to disrupt my current development projects in...
1
by: abbu | last post by:
Hi, Can anybody explain the difference between standard and compatability mode compilatin in C++? Regards, abbu
0
by: David | last post by:
I am trying to migrate a .net 1.1 Web Application to a 2.0 Web Application. I am experiencing issues when putting a strongly typed dataset into session, and then navigation to a page where...
1
by: jrett | last post by:
I need to create a large number of VS 2005 .csproj files from an equal number of VS 2003 .csproj files so that I can use msbuild with MSBee to build .NET 1.1 software. My question, is there a...
4
by: Brent | last post by:
Ok i just went from XP Professional to Vista Ultimate x64 last night. I installed vs 2005, sp1, and the update for sp1 for vista. I started up VS2005 and still got the warning message that deals...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.