<!doctype html public "-//W3C//DTD W3 HTML//EN">
<html><head><style type="text/css"><!--
blockquote, dl, ul, ol, li { padding-top: 0 ; padding-bottom: 0 }
--></style><title>RE: SDE on SQL Server</title></head><body>
<div>Given that information, I think your CONNECTION and DATA strings
should look like this:</div>
<div><br></div>
<div>CONNECTION
"BILLP4,port:5155,BOUND_SDE,sde,password"</div>
<div>DATA "BOUND_SDE.STATESP020,SHAPE"</div>
<div><br></div>
<div>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).</div>
<div><br></div>
<div>If you haven't already seen it, I've put together a document on
the wiki that outlines some more of this stuff. <<font
face="Lucida Grande" size="-4"
color="#000000"
>http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?MapServerSDE</font>>
</div>
<div><br></div>
<div>Howard</div>
<div><br></div>
<div><br></div>
<blockquote type="cite" cite>Hi Howard.<br>
<br>
No, the database name is BOUND_SDE, the username is
"sde".<br>
<br>
I have also tried:<br>
DATA "BOUND_SDE.STATESP020,SHAPE" as well as<br>
DATA "STATESP020,SHAPE"<br>
<br>
The client is windows, and I am not *yet* using FastCGI. (Though
that<br>
will likely change, based on one of your recent posts :)<br>
<br>
I also believe service packs are in sync, if that has any bearing.<br>
<br>
Thanks,<br>
<br>
Bill<br>
<br>
<br>
<br>
> -----Original Message-----<br>
> From: Howard Butler [mailto:hobu@iastate.edu]<br>
> Sent: Tuesday, March 15, 2005 9:25 AM<br>
> To: Bill Tenbroeck<br>
> Cc: MAPSERVER-USERS@LISTS.UMN.EDU<br>
> Subject: Re: SDE on SQL Server<br>
><br>
> Bill,<br>
><br>
> I have confirmed by looking through the code that the
"database"<br>
> argument *is* being passed into the connection creation function,
so<br>
> I don't think that is the problem. Is the name of your
"single<br>
> database model" database actually "sde"?<br>
><br>
> Is the client windows or unix (this shouldn't make much of a<br>
> difference)? Are there any complicating factors like
FastCGI going<br>
> on here too?<br>
><br>
> Howard<br>
><br>
><br>
><br>
> >Has anyone had any luck connecting using the "Single
database Model"<br>
on<br>
> SQL<br>
> >Server. (Each DB stands alone and has its own service and
port<br>
number.)<br>
> ><br>
> >I have 2 servers set up, one using the "multiple
database model" and<br>
can<br>
> >connect to Mapserver successfully. Against the single
database model<br>
> server<br>
> >I'm getting the following error:<br>
> ><br>
> >msSDELayerOpen(): SDE error. SE_connection_create(): Invalid
database<br>
> name.<br>
> >(-162)<br>
> ><br>
> >I am using the following in the layer definition:<br>
> ><br>
> > CONNECTIONTYPE SDE<br>
> > CONNECTION
"BILLP4,port:5155,sde,xxx,xxx"<br>
> > DATA
"BOUND_SDE.SDE.STATESP020,SHAPE"<br>
> ><br>
> >On the DATA line I have tried every permutation I can think
of; the<br>
> example<br>
> >shown is the way it shows up in ArcExplorer.</blockquote>
<div><br></div>
</body>
</html>