September 17, 2008 at 1:07 pm
Hi folks,
I have a server where I run SQLExpress 2005 and in the network I have a station with Win98 and a SQL2000 client.
Can the SQL2000 client in the win98 station access the SQLExpress 2005?
Thanks,
Luiz.
September 17, 2008 at 1:17 pm
Using SQL Server 2000 client software to connect to SQL Server 2005 Express server should work. However, if you try using Enterprise Manager or Query Analyzer you would experience some odd behaviors, especially because of the new concept of schemas in 2005. For example, Query Analyzer will show tables as being "owned" by what seems like a random user, what's happening is that SQL Server 2005 is telling Query Analyzer what the schema ID is, but Query Analyzer is taking that and using it to get a user name. If you're not going to be using these tools you should be fine.
September 17, 2008 at 1:46 pm
What about Win98?
Would there be a problem? I know Express 2005 won't run on Win98, but only the client is in Win98 (SQL 2000 client)
Thanks,
Luiz.
September 18, 2008 at 10:49 am
you would probably need the latest MDAC update for the SQL driver
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2008 at 1:31 pm
Perry,
Do you know what is the latest MDAC?
Thanks,
Luiz.
September 18, 2008 at 2:26 pm
The SQL Server 2000 books online says that you can do a client install on Windows 98 machine. As for the MDAC, version 2.8 is supported on Windows 98:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply