I Can''t connect to SQL Server 2005 via SQL-DMO
-
Hi,
I can't make a legacy application connect to SQL Server 2005, the app is using SQL-DMO to connect.
Error message :
[Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO).
I've tried to read about how to "switch" DMO on on the server but no luck sofar.
Any tips anyone ?
/Regards Anders
-
You need to install Legacy Components.
Go to Add/Remove, click, Chcange ,go through to components and select Legacy Components.
-
Thanks for the reply.
I've tried that a couple of times but haven't found anything that I haven't installed.
A little bit confused when you say Add/Remove I used Change...do I have to reinstall ?
If i try yo install Integration services again it just tells me that everything is already installed.
Maybe some switch somewhere must be turned on ?
//Anders
-
It's under Client Components on the Feature Selection page (Advanced button) of SQL Server 2005 Setup.
You dont need to reinstall the whole thing, you just need to select the Legacy Components. With MSIs you are able to do Change, where you might expect to see remove/uninstall. Change fires up the same setup program, and when it comes to the components you select ones to remove or add.
-
Thanks for the tips, I found it.
But, the installation says that I already have installed these parts.
Perhaps I should try to reinstall these parts..
//Anders
-
What made it work was "Feature Pack for Microsoft SQL Server 2005 - November 2005".
Download and install..heureka !
/Regards Anders
-
my 2 ct...
SQL Server Management Objects (SMO) is the replacement for SQL-DMO.
Check it out !
Maybe conversion is not _that_ hard
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Yup, but if you have a mix of customers using both SQL Server 2000 and 2005 I don't think it's possible.
//Anders
-
From SQLServer 2005 BOL :
Because SMO is compatible with SQL Server version 7.0, SQL Server 2000, and SQL Server 2005, you easily manage a multi-version environment.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
OK, but you have to add SQL Server 2005 client software on the customers machines,
or perhaps have them download it from MS site, quite a bit of work if you are shipping to
approximately 1500 and they want to test and son on...
But, perhaps it's a good solution in the end.
/Regards ANders
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply