SDE on SQL Server

[Howard Butler]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050315/00fc6861/attachment.htm>