Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
We have a 6 running that can't be upgraded and now it's in need of some TLC.
MikeIt's been a while but i seem to remember. SQL 7 client can connect to SQL
6.5, but SQL 7 EnterPrise Manager can't control SQL 6.5 installs.
If you've got a spare client PC give it a try...
HTH. Ryan
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike|||"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike
I don't remeber or sure, but I don't think you can do it.
You may be stuck with isql and/or osql.
Rick Sawtell
MCT, MCSD, MCDBA|||Correct. The 7.0 QA and the MDAC that came with 7.0 can connect downwards. B
ut EM 7.0 can only
connect to 7.0 instance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:utaUTY6FGHA.2652@.tk2msftngp13.phx.gbl...
> It's been a while but i seem to remember. SQL 7 client can connect to SQL
6.5, but SQL 7
> EnterPrise Manager can't control SQL 6.5 installs.
> If you've got a spare client PC give it a try...
> --
> HTH. Ryan
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
>|||Thanks all. Unfortunately this application was purchased many years ago and
is only validated on SQL 6.5. The company has since gone out of business.
I
may have to write a new app.
Thanks
Mike
"Rick Sawtell" wrote:
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> I don't remeber or sure, but I don't think you can do it.
> You may be stuck with isql and/or osql.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
No comments:
Post a Comment