<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=160475114-27102006>Hello
all,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=160475114-27102006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=160475114-27102006>I want to create a
join from and SDF feature source, to a SQL Server database.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=160475114-27102006>I read in the list
that the SQL Server FDO Provider is only for accessing datastores within SQL
Server (datastores created with Autodesk Map). </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=160475114-27102006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=160475114-27102006>So, that would leave
the ODBC Provider to connect to SQL Server for the join. However, I cannot
get this to work... I can choose the ODBC Provider, and specify the DSN to
my SQL Server, Test Connection is successful, but when I try to set the
coordinate system, this is never 'saved'. This causes a problem,
as it seems to give an error anytime you try to join a feature source that
doesn't have a coordinate system assigned.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=160475114-27102006><FONT face=Arial size=2>Btw, I was
successful in getting this to function with an Access
dbase...</FONT></SPAN></DIV>
<DIV><SPAN class=160475114-27102006><FONT face=Arial size=2>Any help and/or
guidance would be greatly appreciated.</FONT></SPAN></DIV>
<DIV><SPAN class=160475114-27102006><FONT face=Arial
size=2></FONT></SPAN> </DIV><FONT face=Arial size=2></FONT><FONT face=Arial
size=2></FONT><FONT face=Arial size=2></FONT>
<DIV align=left><SPAN class=160475114-27102006><FONT face=Arial size=2>Warren
Medernach</FONT></SPAN></DIV></BODY></HTML>