connect to the SQL instance Using Vb 6.0

Question

Dear Friend

How I can connect to the SQL instance using SMO with vb6.0

Thank You

Answer 1

I don't think you can because Microsoft.SqlServer.Smo.dll is not an ActiveX DLL, but depending on what it is you want to do you may be able to accomplish it using SQLDMO. Unfortunately Microsoft is ending support for SQLDMO after SQL 2008. You can read more at http://msdn.microsoft.com/en-us/library/ms141187%28SQL.100%29.aspx