471,090 Members | 1,382 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

sql7\sql200 connectivity

Im trying to access a sql200 database from a sql7 hosted stored
procedure and this is not working. I know that SQL7 is not compatible
with the MDAC for SQL 2000. Does anyone know if this is what is
causing me my problems and if so is it possible to upgrade the SQL7
MDAC without breaking it?

Thanks
Jul 20 '05 #1
3 1846
Hi

You do not state what errors you are getting and exactly how these servers
are trying to be accessed.

AFAIK MDAC should not stop you accessing the server, what versions are you
running?

John
"Nick" <ni***********@apdcomms.com> wrote in message
news:3a**************************@posting.google.c om...
Im trying to access a sql200 database from a sql7 hosted stored
procedure and this is not working. I know that SQL7 is not compatible
with the MDAC for SQL 2000. Does anyone know if this is what is
causing me my problems and if so is it possible to upgrade the SQL7
MDAC without breaking it?

Thanks

Jul 20 '05 #2
Nick (ni***********@apdcomms.com) writes:
Im trying to access a sql200 database from a sql7 hosted stored
procedure and this is not working.
Could you be more specific about what "not working" means? Do you get an
error message (please post it in such case), or does it just hang, or
you get unexpected results?
I know that SQL7 is not compatible with the MDAC for SQL 2000. Does
anyone know if this is what is causing me my problems and if so is it
possible to upgrade the SQL7 MDAC without breaking it?


Since we don't know what your problems, we can say what's causing it. But
you should be able to access a linked server running SQL 2000 from SQL 7.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #3

"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...

Since we don't know what your problems, we can say what's causing it. But
you should be able to access a linked server running SQL 2000 from SQL 7.

I in fact do that on a regular basis.


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Axel Dachtler | last post: by
3 posts views Thread by Omegamon | last post: by
3 posts views Thread by junaid | last post: by
3 posts views Thread by Niks | last post: by
1 post views Thread by Darren McDowell via .NET 247 | last post: by
1 post views Thread by ohs | last post: by

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.