tags:

views:

52

answers:

2
+1  Q: 

SQL Server 2005 64 bit

hi, i have windows 7 64 bit. I have installed SQL Server 2005 32 bit in it. it installed properly but the native clients says its not proper or compatible to run in x64 mode.My question: Where can i get native client that can be run on 64 bit OR Is SQL Server 2005 there for 64 bit?

Thanks

+1  A: 

As far as I'm aware, SQL Server 2005 runs fine as a 32-bit app under WOW64.

There is also a 64-bit optimised version available.

Jason Williams  2010-01-09 08:44:03
thanks for the comment, but i guess Microsoft has stopped giving trial version of SQL 05 after 08.
Romil Nagrani  2010-01-10 07:07:19
+1  A: 

Try to install 64 bit Native Client. The server will work, but OLEDB tends to behave incorrectly when 32bit version is used on 64bit operating system.

Piotr Rodak  2010-01-21 17:35:39
I think you mean "when 32 bit version is used from a 64 bit process"
Ian Ringrose  2010-01-23 12:19:41
i got a solution to this where you need to install SQL Server 2005 SP3 which is for Windows 7. I did that but i didn't got Management Studio Interface (In win 7). It installed great in Win XP SP2.
Romil Nagrani  2010-01-28 05:54:23

related questions

Sql to query a dbs scheme
Transform Columns into Rows
SQL Client for Mac OS X that works with MS SQL Server
How do you get leading wildcard full-text searches to work in SQL Server?
SQL Server 2000: Is there a way to tell when a record was last modified?
What's the BEST way to remove the time portion of a datetime value (SQL Server)
I need to know how much disk space a table is using in SQL Server
What's the best way to determine if a temporary table exists in SQL Server?
Appropriate pagefile size for SQL Server
Have you ever encountered a query that SQL Server could not execute because it referenced too many tables?
ASP.NET MVC "CRUD" Database Sample
How do I unit test persistence?
Best Book for a new Database Developer
Can I logically reorder columns in a table?
Best way to copy a database in SQL Server 2005/8?
Is Windows Server 2008 "Server Core" appropriate for a SQL Server instance?
Why doesn't SQL Full Text Indexing return results for words containing #?
Client collation and SQL Server 2005
Editing database records by multiple users
Deploying SQL Server Databases from Test to Live
SQL Server 2005 implementation of MySQL REPLACE INTO?
Upgrading SQL Server 6.5
How do I version my MS SQL database in SVN?
How to export data from SQL Server 2005 to MySQL
Check for changes to a SQL table?