How to access the datasource of a connection manager ?

  • Hi,

    I was trying to retrieve the datasource of a connection manager that i have used to make a connection to the sql server. But the datasource property is not listed in the properties for the connection manager(It is listed in the connection string property of connection manager). I need to change the datasource of a connection at run time.What property should i set? Can anbody help me out as this is very urgent for me. Any help is highly appreciable.

    Thanks

    Kiran

  • Thanks for responding ASAP.

    I was able to access the Servername using the connection manager programatically(not able to retrieve the datasource info programatically)...however i have noticed in the designer that the ServerName and the Datasource are the same.Is my observation correct?

    Please let me know.

    Thanks

    Kiran

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply