Using Pyhon to connect to a versioned SDE datasoure running on SQL Server

BobJohnson — Tue, 25 May 2010 17:15:43 GMT

Hi,

I've written some Python scripts that I can use to connect to SQL Server Express on my local machine. My plan was to develop the scripts there and then to point the scripts to our geodatabase on a SQL Server instance on a remote server.

The scripts are working, now I'm having a hard time getting them to connect to the remote database server. Given the following parameters, what would the connection string look like that I would use in a gp.updatecursor(FeatureClass, WhereClause) look like?

Server: qServerS5
Service: 9901
Database: DBig
Username: Clyde
Password: password
Transactional Version: DBO.BobsTestVersion

Thanks in advance for your help.

Bob J

Re: Using Pyhon to connect to a versioned SDE datasoure running on SQL Server

KenHartling — Thu, 02 Sep 2010 11:37:10 GMT

Hi Bob,

The first parameter is just the path to your feature class. The path to an ArcSDE feature class in GP must be done through a .sde file with the appropriate connection info contained within it in order to specify the feature class. For example:

fc = r'c:\temp\connectionToArcSDE.sde\fcname'
whereClause = "<whateverUwant>"
gp.updatecursor(fc, whereClause)

If you don't already have a .sde file and want to create it on the fly in your script you can use the GP tool CreateArcSDEConnectionFile() (New at 10) to create it.

Ken

topic Using Pyhon to connect to a versioned SDE datasoure running on SQL Server in Geoprocessing Questions

Using Pyhon to connect to a versioned SDE datasoure running on SQL Server

Re: Using Pyhon to connect to a versioned SDE datasoure running on SQL Server