SDE on SQL Server

[Howard Butler]

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.