Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Connection to SQL 2000 Server

27 Oct 2009   #1
Lloyd Clinton

Windows 7
 
 
Connection to SQL 2000 Server

I know the SQL 2000 client is not compatible with Win 7. However, we have a program that just uses an ODBC connection to the SQL 2000 database. If the application runs in 7, it should be able to talk to the 2000 database without damaging it, correct? When asked that specific question, here is how the vendor replied:

"We are just finishing up certification of Windows 7 with XXX Xxxxxxxxxx, but it is not completed yet. If Microsoft does not support the SQL 2000 Client on Windows 7 then you will need to consider upgrading your SQL Server to 2005 or 2008. Microsoft support for SQL 2000 is expired as well. (We all knew this part)

So, you will need to wait a bit before using XXX Xxxxxxxxxx on this machine if it is upgraded to Windows 7 and it may not support SQL 2000 at all.
"

First off, they did not answer the question. Second, I have installed a dozen of the clients, and not once did it install the actual SQL 2000 client, I only had to setup an ODBC connection to the SQL server. Thanks!


My System SpecsSystem Spec
.

07 Dec 2009   #2
josemo

XP-64
 
 
Msde sql 2000

Hello, I do have the same problem. I was able to connect from win 7 to full SQL server 2000, but not to MSDE. Did you find anything?

Kr
Joe
My System SpecsSystem Spec
15 Jun 2010   #3
PCnetMD

Windows 7 Enterprise
 
 

Quote   Quote: Originally Posted by josemo View Post
Hello, I do have the same problem. I was able to connect from win 7 to full SQL server 2000, but not to MSDE. Did you find anything?

Kr
Joe
Josemo,

I am unable to connect Win7 Ent to a full SQL Server 2000 using ODBC. How did you manage this.

Thank you,
Randy
(PCnetMD)
My System SpecsSystem Spec
.


Reply

 Connection to SQL 2000 Server




Thread Tools





Similar help and support threads
Thread Forum
Windows 7 unable to Access file server on Windows Server 2000
Hello, I have a problem to access file server on Windows Server 2000 from a Windows 7 PC. For your information, due to some reasons, both Windows 7 and Windows Server 2000 are in different domain. I have tried all suggested solutions which are : i. to unchecked both attributes in 'Network...
Network & Sharing
SQL Server 2000 Installation Error in Windows 7
When I am going to Install SQL Server 2000 Personal Edition on Windows 7 in administrator login,it shows an error "InstallShield Engine has Stopped Working".Pls advise and check the attached files.
Software
HELP! Win 7 map drive on advance server 2000
I am pulling my hair out on this one:mad: I set this server up 7 years ago with Advanced Server 2000. One of the only versions of windows that had a native drive mirror option since NT4. Anyways, There is no domain controller just a simple workgroup. I created local accounts on the file server...
Network & Sharing
Windows 2000 Server Approaching End of Life
More...
News
Unable to log in to Server 2000 machine from W7
I have a Win 2000 machine thats in "WORKGROUP". I can't connect from my new Windows 7 Professional (32bit). I can see the machine, it ask's for my username and password but I keep getting the response "login failure: unknown username or bad password" I can log in to the Win 2000 machine from an...
Network & Sharing
Windows 2000 Server, Windows 2000 Client and Windows XP
More...
News

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 23:55.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App