sql7\sql200 connectivity
This is a discussion on sql7\sql200 connectivity within the SQL Server forums, part of the Microsoft SQL Server category; --> Im trying to access a sql200 database from a sql7 hosted stored procedure and this is not working. I ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 05:57 AM
| ||||
| ||||
 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      |
|
02-29-2008, 05:58 AM
| |||
| |||
| Re: sql7\sql200 connectivity 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" <nick.fletcher@apdcomms.com> wrote in message news:3abc9d93.0411260152.63f9caa9@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 |
|
02-29-2008, 05:58 AM
| |||
| |||
| Re: sql7\sql200 connectivity Nick (nick.fletcher@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, esquel@sommarskog.se Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp |
|
02-29-2008, 05:58 AM
| ||||
| ||||
| Re: sql7\sql200 connectivity "Erland Sommarskog" <esquel@sommarskog.se> wrote in message news:Xns95ADEF2E44C3EYazorman@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, esquel@sommarskog.se > > Books Online for SQL Server SP3 at > http://www.microsoft.com/sql/techinf...2000/books.asp |
Linear Mode
