SQLDMO not generating network server list

• ankur.bhargava

  Mr or Mrs. 500

  Points: 561

  More actions

  December 18, 2007 at 9:23 am

  #70536

  Hi All

  i hv successfully installed SQLDMO at client end but unable to get list of sql server. i am getting automation error.

  Machine configurations is

  1) Windows 2000

  2) Office 2000

  Does any body know what is wrong?

  ankur

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  December 18, 2007 at 9:32 am

  #761107

  Could you post the code and the exact error?

  It sounds like the object is not being created successfully.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• hb21l6

  SSCommitted

  Points: 1647

  More actions

  December 18, 2007 at 9:32 am

  #761108

  What Client OS are you using?

  is the local FW enabled? its more then likley that the PC can't see the server.

  is the SQL servers FW enabled?

  cheers

  Dave

• ankur.bhargava

  Mr or Mrs. 500

  Points: 561

  More actions

  December 18, 2007 at 9:37 am

  #761110

  thanks for your reply.

  i installed mdac2.8 on the machine and it works fine. anybody can tell me which set of dlls required or any other things done by mdac.

  i hv to include all these files in an installer and dont want ti include full mdac into it

  thanks