I can't connect to arcsde geodatabase

[ben_abdallahmhd]

hello
good morning
i have a problem to connect to an arcsde geodatabase with python and i need help please

i use arcsde for single use (trial version of ArcGIS Desktop10)
i have stored a geodatabase in sqlserver with arcsde
i try to connect to this geodatabase with this python code but the connection failed, help please, thank you

>>> import arcpy >>> import sys >>> import os  >>> arcpy.CreateArcSDEConnectionFile_management("C:/connectionFiles","connect.sde","MKT/otc","sde:sqlserver:MKT/p10","BDP10TN_SIG","OPERATING_SYSTEM_AUTH","dbo.DEFAULT","DO_NOT_SAVE_VERSION")

<Result 'C:\\connectionFiles\\connect.sde'>



message:

Heure de début*: Fri May 11 17:37:35 2012
WARNING 000565: Impossible de se connecter au serveur.
réussie à Fri May 11 17:37:35 2012 (temps écoulé*: 0,00 secondes)

[EmadAl-Mousa]

Hi,

the easiest way is to drage and drop your ArcCatalog SDE Connection to your python IDE from ArcCatalog.

[GarrettMoeller]

what if you want to do it without an sde database connection?
say I am setting this up to be activated from arcpad instead and the user is remote so I want to use the ip address.
what would the syntax look like?

[curtvprice · Accepted solution]

what if you want to do it without an sde database connection?
say I am setting this up to be activated from arcpad instead

I think what Emad was getting at is if you drag and drop, the proper syntax will appear in your code. You can then use that code in your ArcPad app, or use that code as a template to build an appropriate connection string for a different user/database etc.

Another approach that I have found handy with difficult syntaxes is to do the operation using a tool interactively in ArcGIS Desktop (for example, run the Create Database Connection tool, taking advantage of the help and validation [parameter checks] in the tool interactive interface), and then copy python snippets from the Results window (right click > Copy Python Snippet). This approach can save you hours of frustration!

[GarrettMoeller]

Excellent answer thank you!