SQLDMO and .NET

[HRoarke]

Hi all -

Regarding SQLDMO and .NET: any easy way to connect a SQLDMO.SQLServer (or SQLServer2) object using an existing SQLClient.SQLConnection object? I could obviously parse the SQLConnection.ConnectionString to get the UserName and Password to use with the SQLServer.Connect method, but it is unknown until run-time whether we're using Integrated Security or an authentication pair. Any straightforward and/or clever ways to accomplish this?

Thanks a mil,

Roarke

<bw>
"I swear by my life and my love of it that I will never live for the sake of another man, nor ask another man to live for mine."
— John Galt
Atlas Shrugged

If you want to get the best response to a question, please check out FAQ222-2244 first

 

[ClayG]

The way SQLDMO references the server is not a SQL connection, and it does not use a connection string. You probably will have to pick the values out of the connection string.