SDE on SQL Server

[Bill TenBroeck]

That did the trick.

I did need the original form for the DAT string:

DATA "BOUND_SDE.SDE.STATESP020,SHAPE"

I had looked at the wiki, but was confused at the connection piece re: the
sde user.

Thanks a bunch!

>Given that information, I think your CONNECTION and DATA strings
>should look like this:
>
>CONNECTION "BILLP4,port:5155,BOUND_SDE,sde,password"
>DATA "BOUND_SDE.STATESP020,SHAPE"
>
>The 3rd argument there is the dbname, which should be bound_sde.
>Also, it is generally bad practice to use the "sde" user for anything
>but maintenance, as it can be confusing, and because user tables can
>muck up the sde schema (I've never had this cause explicit trouble,
>but it can make things messy).
>
>If you haven't already seen it, I've put together a document on the
>wiki that outlines some more of this stuff.
><http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?MapServerSDE>
>
>Howard
>
>
>>Hi Howard.
>>
>>No, the database name is BOUND_SDE, the username is "sde".
>>
>>I have also tried:
>>DATA "BOUND_SDE.STATESP020,SHAPE" as well as
>>DATA "STATESP020,SHAPE"
>>
>>The client is windows, and I am not *yet* using FastCGI. (Though that
>>will likely change, based on one of your recent posts :)
>>
>>I also believe service packs are in sync, if that has any bearing.
>>
>>Thanks,
>>
>>Bill
>>
>>
>>
>>>  -----Original Message-----
>>>  From: Howard Butler [mailto:hobu at iastate.edu]
>>>  Sent: Tuesday, March 15, 2005 9:25 AM
>>>  To: Bill Tenbroeck
>>>  Cc: MAPSERVER-USERS at LISTS.UMN.EDU
>>>  Subject: Re: SDE on SQL Server
>>>
>>>  Bill,
>>>
>>>  I have confirmed by looking through the code that the "database"
>>>  argument *is* being passed into the connection creation function, so
>>>  I don't think that is the problem.  Is the name of your "single
>>>  database model" database actually "sde"?
>>>
>>>  Is the client windows or unix (this shouldn't make much of a
>>>  difference)?  Are there any complicating factors like FastCGI going
>>>  on here too?
>>>
>>>  Howard
>>>
>>>
>>>
>>>  >Has anyone had any luck connecting using the "Single database Model"
>>on
>>>  SQL
>>>  >Server. (Each DB stands alone and has its own service and port
>>number.)
>>>  >
>>>  >I have 2 servers set up, one using the "multiple database model" and
>>can
>>>  >connect to Mapserver successfully. Against the single database model
>>>  server
>>>  >I'm getting the following error:
>>>  >
>>>  >msSDELayerOpen(): SDE error. SE_connection_create(): Invalid database
>>>  name.
>>>  >(-162)
>>>  >
>>>  >I am using the following in the layer definition:
>>>  >
>>>  >     CONNECTIONTYPE SDE
>>>  >     CONNECTION "BILLP4,port:5155,sde,xxx,xxx"
>>>  >     DATA "BOUND_SDE.SDE.STATESP020,SHAPE"
>>>  >
>>>  >On the DATA line I have tried every permutation I can think of; the
>>>  example
>>>  >shown is the way it shows up in ArcExplorer.
>