<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Brad,<br>
<br>
You should use the ArcSDE provider.<br>
<br>
For the instance name, did you use sde:myserver\sqlexpress or
sde:sqlserver:myserver\sqlexpress?<br>
<br>
<br>
On 5/21/2010 9:26 AM, Brad Nesom wrote:
<blockquote
cite="mid:AANLkTinWn98ZP38us-76kcIJEJ7OrKZtCsOFmUpxVOst@mail.gmail.com"
type="cite">
<div>I have been trying to make an autocad map (2010,
2011) connection to sql2008 express with an arcsde 9.3.1 personal gdb.
I get several reactions depending on which connection and the values I
use. I tried going through autodesk support to get a resolution. I got
the following response from them. I have seen some responses on this
forum expressing that the connection is possible. Any help would be
appreciated.</div>
<div>Brad</div>
<div>My connection parameters...</div>
<div>sql server spatial</div>
<div>service name: sde:sqlsserver:myserver\sqlexpress</div>
<div>response: credentials are not valid or
provider is unable to establish a connection.</div>
<div>ArcSDE connection</div>
<div>server name: myserver\sqlexpress</div>
<div>instance name: sde:myserver\sqlexpress</div>
<div>response: no error on credentials but the data
store not populated</div>
<div>the sde:sqlserver:myserver\SQLEXPRESS syntax works in FME and
returns the geometry correctly</div>
<div> </div>
<div>Autodesk Response ...</div>
<div>
<p><span style="font-family: 'Verdana','sans-serif'; font-size: 8pt;">Here's
the official word from the product manager: </span></p>
<p><span
style="font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125);"><font
size="3">This is not a supported configuration. Not tested. I suspect
the "local connect" string is not understood by our provider. But even
if Map 3D did connect, you wouldn’t be able to "create a datastore".
FDO Provider for ArcSDE doesn’t allow creation of data store from Map
3D. you can only connect and edit existing ArcSDE Data Stores.</font></span></p>
<br>
</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
fdo-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:fdo-users@lists.osgeo.org">fdo-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/fdo-users">http://lists.osgeo.org/mailman/listinfo/fdo-users</a>
</pre>
</blockquote>
</body>
</html>