<!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.2722" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=411203817-30102006><FONT face=Arial
color=#0000ff size=2>On a similar note, SQL Server DateTime and SmalDateTime
type fields don't show up in Studio (although the tables
do).</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Warren Medernach
[mailto:warren.medernach@imaginit.ca] <BR><B>Sent:</B> 30 October 2006
17:21<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SQL Server Provider vs. FDO Provider for a feature
join...<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335361117-30102006>Update...</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335361117-30102006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335361117-30102006>It seems that this might not be a user/permission
issue... After more digging I have discovered something that seems
extremely bizarre to me...</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335361117-30102006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335361117-30102006>If I have a table that has a field(s) defined as
'ntext'... the table WILL NOT show up in Studio.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335361117-30102006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335361117-30102006>If I change these fields to say 'nvarchar', the tables
WILL show up in Studio...</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335361117-30102006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335361117-30102006>Can anybody shed some light on
this?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335361117-30102006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335361117-30102006>Fyi
Dave, at this point I'm using the sa user just to try to get this working.</DIV>
<DIV dir=ltr align=left><BR>Warren</SPAN></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Dave Wilson
[mailto:dave.wilson@autodesk.com] <BR><B>Sent:</B> Monday, October 30, 2006
10:02 AM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SQL Server Provider vs. FDO Provider for a feature
join...<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=184565915-30102006><FONT face=Arial
color=#0000ff size=2>The master database is the default when using SQLServer if
I am not mistaken. What login are you using to access the tables? It should be
one with at least select privileges against 1 or more tables within your
database. You should ensure you are using SQLServer authentication and not
windows.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=184565915-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=184565915-30102006><FONT face=Arial
color=#0000ff size=2>Dave</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Warren Medernach
[mailto:warren.medernach@imaginit.ca] <BR><B>Sent:</B> Monday, October 30, 2006
7:51 AM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SQL Server Provider vs. FDO Provider for a feature
join...<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=542324814-30102006><FONT face=Arial
color=#0000ff size=2>Ok, I got a little further on this...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=542324814-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=542324814-30102006><FONT face=Arial
color=#0000ff size=2>In my ODBC Connection I was changing the 'default database'
to use my dbase, and doing this it wouldn't show me any tables. If I
toggle this 'Off', it then shows me the master db tables...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=542324814-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=542324814-30102006><FONT face=Arial
color=#0000ff size=2>I'm starting to wonder if this is a 'permissions' issue
with my db?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=542324814-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=542324814-30102006><FONT face=Arial
color=#0000ff size=2>Warren</FONT></SPAN></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Warren Medernach
[mailto:warren.medernach@imaginit.ca] <BR><B>Sent:</B> Monday, October 30, 2006
8:37 AM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SQL Server Provider vs. FDO Provider for a feature
join...<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=446193114-30102006><FONT face=Arial
color=#0000ff size=2>Thanks for the Info Keith!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=446193114-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=446193114-30102006><FONT face=Arial
color=#0000ff size=2>Did you need to specify or change any settings in your ODBC
connection?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=446193114-30102006><FONT face=Arial
color=#0000ff size=2>Are you using SQL Server or NT Authentication in the ODBC
connection?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=446193114-30102006><FONT face=Arial
color=#0000ff size=2>What credentials are you using on the MapGuide Studio
side?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=446193114-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=446193114-30102006><FONT face=Arial
color=#0000ff size=2>I don't know what else to try?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=446193114-30102006><FONT face=Arial
color=#0000ff size=2>It won't 'Show' me the tables, or save the Coord Sys with
the Connection in Studio?....</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=446193114-30102006>Warren</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Campbell, Keith A
[mailto:keith.campbell@atkinsglobal.com] <BR><B>Sent:</B> Monday, October 30,
2006 8:01 AM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SQL Server Provider vs. FDO Provider for a feature
join...<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=294075213-30102006><FONT face=Arial
color=#0000ff size=2>Hi Warren,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=294075213-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=294075213-30102006><FONT face=Arial
color=#0000ff size=2>I'm not sure that this is going to be much help other than
to confirm that you should be able to do what you want. I can't see anything
you're doing wrong based on your description.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=294075213-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=294075213-30102006><FONT face=Arial
color=#0000ff size=2>Firstly, yes, the ODBC option is the way to go to create
your join. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=294075213-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=294075213-30102006><FONT face=Arial
color=#0000ff size=2>I have got this arrangement working, though I have not had
the problem you mention regarding assignment of the coordinate system. I've
saved an arbitrary coordsys in my data connection and everything works.
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=294075213-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=294075213-30102006><FONT face=Arial
color=#0000ff size=2>Are you using version 1.0.2? It has a number of
enhancements in this area. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=294075213-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=294075213-30102006><FONT face=Arial
color=#0000ff size=2>I've also found that if the SQL database is not local to
the MapGuide Service, this significantly impacts the performance, making
configuration of the join / layer frustrating to say the
least.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=294075213-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=294075213-30102006><FONT face=Arial
color=#0000ff size=2>Keith</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Warren Medernach
[mailto:warren.medernach@imaginit.ca] <BR><B>Sent:</B> 27 October 2006
16:50<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SQL Server Provider vs. FDO Provider for a feature
join...<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=101384915-27102006></SPAN><FONT face=Arial
color=#0000ff size=2><SPAN
class=101384915-27102006>Correction...</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=101384915-27102006>Subject should read: SQL Server FDO Provider vs.
ODBC Provider...</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=101384915-27102006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2>W<SPAN
class=101384915-27102006>arren</SPAN></FONT></FONT></FONT><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Warren Medernach
[mailto:warren.medernach@imaginit.ca] <BR><B>Sent:</B> Friday, October 27, 2006
9:01 AM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B>
[mapguide-users] SQL Server Provider vs. FDO Provider for a feature
join...<BR></FONT><BR></DIV>
<DIV></DIV>
<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><BR><BR><FONT style="BACKGROUND-COLOR: #ffffff">
<P align=center><FONT style="BACKGROUND-COLOR: #ffffff">This message has been
scanned for viruses by </FONT><A
href="http://bluepages.wsatkins.co.uk/?4318150"><FONT
style="BACKGROUND-COLOR: #ffffff"
color=#000000>MailControl</FONT></A></P></FONT><BR><BR>
<P align=center><FONT style="BACKGROUND-COLOR: #ffffff"
color=#ff0000><STRONG><FONT color=#000000>This email and any attached files are
confidential and copyright protected. If you are not the addressee, any
dissemination of this communication is strictly prohibited. Unless otherwise
expressly agreed in writing, nothing stated in this communication shall be
legally binding</FONT>.</STRONG></FONT><A
href="http://www.blackspider.com/"><FONT style="BACKGROUND-COLOR: #ffffff"
color=#000000></FONT></A></P></BODY></HTML>