1

I'm working on a toolbar for modifying an SDE database in acrmaps. My code works in a file geodatabase so I'm trying to use this function to make it work in an ArcSDE. I've gotten every other variable in this function figured out, but I have no idea how to find the service variable. I did find some commands for that in arcmaps 9.3, but I am using 10.3 and the command console has been removed.

How do I figure out what the ArcSDE service name or TCP port number is? Is there a better way to do this?

Here is the documentation on the function:

http://desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/create-arcsde-connection-file.htm

  • Is using direct connect an option, desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/…? This is preferred as SDE services (Three Tier connections) are depreciated. If must use a three tier connection your SDE administrator will be able to tell you the service name, 5150 and 5151 are the most common ones I have come across (they correspond to the port number). – Dowlers May 25 '16 at 20:27
  • @Dowlers what's the difference? I'm pretty new to this as it is. Do they do the same thing? How would I know if it weren't an option? I'm looking at it now and I don't seen any reason that it wouldn't work. – user66821 May 25 '16 at 20:52
  • "Direct connect" connects directly to the database instance. "Three Tier" or "SDE service" connections connect to an SDE service. The SDE service handles the connection to the database behind the scenes, kind of like a proxy. Try making a new database connection in ArcCatalog under Database connections<add Database Connection . By default it will give you direct connect connection type. See if that works. – Dowlers May 25 '16 at 21:10
  • @Dowler I need a solution that works in a script for a toolbar I'm making. Your explanation does make a bit of sense though. Can I use this to connect to a versioned editing session? For some reason I can't open a workspace in a version session. I found a question here that made a script written for a file geodatabase work for an SDE database. I think this is the logic used there. – user66821 May 25 '16 at 21:15
  • 10.3 doesn't have application servers, so the point is moot. If you design your tool to consume a connection file (.sde), you can remove all the wheel reinventing. – Vince May 25 '16 at 21:42
1

Is using direct connect an option? This is preferred as SDE services (Three Tier connections) are depreciated. If must use a three tier connection your SDE administrator will be able to tell you the service name, 5150 and 5151 are the most common ones I have come across (they correspond to the port number).

  • How do I make this point to my version? – user66821 Jun 20 '16 at 21:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy