Opening an SDE Direct Connection to SQL Server

DavidWilcox — Wed, 26 Jun 2013 15:27:40 GMT

Hi All,

I just upgraded to ArcGIS Server 10.1 and I'm trying to work without any sde application code on the server. However, I haven't been able to establish a direct connection from the client using ArcObjects. Is there a new interface or a new parameter I need to set? The instance just seems to take me over to the services file. Here's a code snip:

    Public Shared Function openSDEWorkspace(ByVal pServer As String, _
         ByVal pInstance As String, ByVal pDatabase As String, ByVal pUser As String, _
         ByVal pPassword As String, ByVal pVersionName As String) As Geodatabase.IWorkspace
        Try
            Dim pSDEWorkspaceFactory As Geodatabase.IWorkspaceFactory = New DataSourcesGDB.SdeWorkspaceFactory
            Dim pPropertyset As esriSystem.IPropertySet = New esriSystem.PropertySet
            With pPropertyset
                .SetProperty("Server", pServer)
                .SetProperty("Instance", pInstance)
                .SetProperty("Database", pDatabase)
                .SetProperty("user", pUser)
                .SetProperty("password", pPassword)
                .SetProperty("version", pVersionName)
            End With
            Dim pWorkspace As Geodatabase.IWorkspace = pSDEWorkspaceFactory.Open(pPropertyset, 0)

Thanks for any ideas!

- Dave Wilcox
VIMS, College of W&M

Re: Opening an SDE Direct Connection to SQL Server

DavidWilcox — Sat, 11 Dec 2021 11:52:20 GMT

I think I've figured it out. An instance of "sde:sqlserver:[serverinstance]" seems to work.- Dave

    Public Shared Function openSDEWorkspace(ByVal pServer As String, _
         ByVal pInstance As String, ByVal pDatabase As String, ByVal pUser As String, _
         ByVal pPassword As String, ByVal pVersionName As String) As Geodatabase.IWorkspace
        Try
            Dim pSDEWorkspaceFactory As Geodatabase.IWorkspaceFactory = New DataSourcesGDB.SdeWorkspaceFactory
            Dim pPropertyset As esriSystem.IPropertySet = New esriSystem.PropertySet
            With pPropertyset
                .SetProperty("Server", pServer)
                .SetProperty("Instance", pInstance)
                .SetProperty("Database", pDatabase)
                .SetProperty("user", pUser)
                .SetProperty("password", pPassword)
                .SetProperty("version", pVersionName)
            End With
            Dim pWorkspace As Geodatabase.IWorkspace = pSDEWorkspaceFactory.Open(pPropertyset, 0)

Thanks for any ideas!

- Dave Wilcox
VIMS, College of W&M

topic Opening an SDE Direct Connection to SQL Server in ArcObjects SDK Questions

Opening an SDE Direct Connection to SQL Server

Re: Opening an SDE Direct Connection to SQL Server