October 29, 2002 at 11:50 am
Very occaisonally I see this error
"You must upgrade your SQL Server Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server"
The conditions for latest report was this:
The SQL server is up to date with latest service packs etc.
The machine where the software is installed also has SQL Server 2000, but only client components (Query Analyzer etc.)
My theory is this. When SQLServer 2000 is install OVER SQLServer 7 not all dmo components are upgraded. In fact there can be several instances of SQLDMO.dll on the client machine. When referencing SQLDMO in a client app. it will in fact still reference the old SQL7 SQLDMO dll and be unable to login to a SQL2000 server (using DMO).
Finding and deleting the old SQLDMO dlls will fix the problem.
But it has been sometime since I have encountered this issue and I am not positive I am write. If I am I am not sure which version to remove (by version number).
Any ideas on this?
TIA, Brian
Brian Lockwood
President
LockwoodTech Software
Brian Lockwood
President
ApexSQL - SQL Developer Essentials
October 29, 2002 at 1:50 pm
Install SQL Server 2000 client tools (including SQLDMO components) does not overwrite the SQL Server 7.0 files if default installation is choosed. Both of them have different installation directory.
You may check the system parameter 'path' in machine system property --> Environment to see the sequence of directory of both SQL 2000 and 7.0.
I have both SQL 2000 and 7.0 client tools installed in my machine. Here is part of path value. C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\MSSQL7\BINN
October 29, 2002 at 3:12 pm
quote:
Install SQL Server 2000 client tools (including SQLDMO components) does not overwrite the SQL Server 7.0 files if default installation is choosed. Both of them have different installation directory.You may check the system parameter 'path' in machine system property --> Environment to see the sequence of directory of both SQL 2000 and 7.0.
I have both SQL 2000 and 7.0 client tools installed in my machine. Here is part of path value. C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\MSSQL7\BINN
thx for reply - can you see what version of sqldmo.dll is the sql7 one?
i will reccommend to client to find it, unregister it and delete it so SQL2000 will ALWAYS be used when dmo is referenced.
Brian Lockwood
President
LockwoodTech Software
Brian Lockwood
President
ApexSQL - SQL Developer Essentials
October 30, 2002 at 7:42 am
2000.28.09
October 30, 2002 at 7:56 am
quote:
2000.28.09
thanks
Brian Lockwood
President
LockwoodTech Software
Brian Lockwood
President
ApexSQL - SQL Developer Essentials
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply