<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal" style="margin-bottom:12.0pt;background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Why does OSGeo FDO Provider for SQL Server Spatial try to access the wrong database?
<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt;background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">I was wondering if you could tell me if this is a bug or else how to configuring this correctly? I receive the following error
when trying to test my connection using the OSGeo FDO Provider for SQL Server Spatial in Autodesk Studio 2014 to a MS SQL Server Spatial server (v 10.50.4000). I have also cross-posted in Autodesk and Microsoft since it could be any one of the three...<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt;background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">An exception occurred in FDO component.<br>
RDBMS: [Microsoft][SQL Server Native Client 10.0][SQL Server]The server principal "myLoginHere" is not able to access the database "WrongDatabaseNotMyDefault" under the current security context. (Cause: , Root Cause: RDBMS: [Microsoft][SQL Server Native Client
10.0][SQL Server]The server principal "myLoginHere" is not able to access the database "WrongDatabaseNotMyDefault" under the current security context. )<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Additional details:<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">- The database listed in the error above is not what I expected. I was expecting the FDO to try and connect to the default database configured to my
login id – the default database is a Spatial database.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">- I
<u>am able to connect and see data</u> but <u>am not able to define geometry</u> from AIMS Studio using the OSGeo FDO Provider
<u>for ODBC</u>.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">- I
<u>am</u> able to connect and see data and geometry rows using Microsoft SQL Management Studio.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">- The author of the SQL Server Spatial database is able to access the geometry from other products (AutoCad I believe).<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">- I can see other database names from Microsoft SQL Management Studio but I do not have permissions to view any details about these databases.<o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">- The first database listed in the databases names I can see is the "WrongDatabaseNotMyDefault" database from the error – the default database for
my login is the thirteenth (13<sup>th</sup>) database down the list!<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt;background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt;background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Thanks For Your Help,<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt;background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Nathan<o:p></o:p></span></p>
</div>
</body>
</html>