August 29, 2008 at 1:52 am
Hi all
I know DMO is old but I just hope it works with SQL Server 2008, so I wrote some test code to get a list of installed instance via DMO and run it on Windows 2008 Server 64-bit with SQL Server 2008 64-bit.
I found out that it works well if the code is built into a x64 application but ListInstalledInstances will return a NULL list if the same cold is built into a win32 application. How can I make DMO work correctly with a 64-bit SQL Server in WOW64 environment? Is there anything special to do? I installed DMO from "SQL Server 2005 Backward compatibility" package.
December 15, 2008 at 3:15 pm
Hi,
I had the same issue. I found out that it does not work in a 32-bit application unless the service SQLBrowser is running. The 32-bit version of the SQL-DMO COM API must rely on the SQLBrowser service.
Give it a try and see if it solves your problem.
March 1, 2009 at 11:53 pm
Hi
I am also having the same problem. Were you able to solve it? Please let me know the solution if you solved it.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply