[fdo-users] Arc SDE 9.3

Thu Oct 23 20:27:27 EDT 2008

Thanks Robert.

As I understand it, to use the sde user, the tables would need to be 
moved to the sde schema. Is that correct? If so, I am not sure if I 
could get the GIS administrator to go for that.

If I can not get the schema changed, is there a rough idea of when the 
provider would support the dbo user.

Thanks again.

George

Robert Fortin wrote:
> George,
>
> Using dbo instead of sde user is new to 9.3 and we are looking into fixing this issue in the provider.
> Unless you switch to using a sde user, it will not work at the moment.
>
> Robert
>
> -----Original Message-----
> From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of George McLean
> Sent: Thursday, October 23, 2008 11:56 AM
> To: FDO Users Mail List
> Subject: Re: [fdo-users] Arc SDE 9.3
>
> It looks like it is dbo.SDE_state_lineages. Does this mean the current
> provider will not work?
>
> Thanks
>
> George
>
> Jack Lee wrote:
>   
>> Hi,
>>
>> In SQL Server Management Studio, do you have a table named sde.SDE_state_lineages or dbo.SDE_state_lineages?
>>
>>
>> -----Original Message-----
>> From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of George McLean
>> Sent: Wednesday, October 22, 2008 8:36 PM
>> To: FDO Users Mail List
>> Subject: Re: [fdo-users] Arc SDE 9.3
>>
>> I am getting the error when retrieving the versions.
>>
>> I am not sure if I am using the sde user. How can I verify that? When I
>> connect directly to the database through SQL Server Management Studio, I
>> see the user defined in the security tab. Does the user need to be
>> defined for sde separately?
>>
>> Thanks
>>
>> George
>>
>> Jack Lee wrote:
>>
>>     
>>> Hi,
>>>
>>> Fdo 3.4 dlls are not binary compatible with Map 2009 which uses Fdo 3.3.2.
>>>
>>> Are you using the dbo user or sde user?
>>>
>>> Did you get the error message when retrieving the versions?
>>>
>>>
>>> ________________________________________
>>> From: fdo-users-bounces at lists.osgeo.org [fdo-users-bounces at lists.osgeo.org] On Behalf Of George McLean [gmclean at gorge.net]
>>> Sent: Wednesday, October 22, 2008 6:05 PM
>>> To: FDO Users Mail List
>>> Subject: Re: [fdo-users] Arc SDE 9.3
>>>
>>> Hi Robert,
>>>
>>> I am not sure how to try the 3.4 build but this is what I have done so far:
>>>
>>> I downloaded the fdosdk_3.4.0_win32_release_G032.tar and copied the
>>> dills and providers.xml file into the FDO\bin folder in my map 2009
>>> installation. When I do this and start Map 2009,  mapstartwspace fails
>>> so I do not get the task pane. Should this approach work? I am guessing
>>> that I do not understand all the steps required to make this work.
>>>
>>> I tried connecting to ArcSDE using the version 3.3.2 providers but that
>>> failed with the error: DBMS table not found (-37).The GIS Administrator
>>> has been able to create a feature class using ArcCatalog with the same
>>> account I am using to access the data store so I don't think this is a
>>> permissions issue.
>>>
>>> Any suggestions? Thanks again for the help.
>>>
>>> George
>>>
>>> Robert Fortin wrote:
>>>
>>>
>>>       
>>>> George,
>>>>
>>>> As long as you don't use a dbo user, it should work.  See my response to Jason too.
>>>>
>>>> Just remembr that this is unofficial build of 3.4 so it's WORK-IN-PROGRESS still.
>>>> See the road map page for the release plan for FDO 3.4 http://fdo.osgeo.org/content/road-map
>>>>
>>>> Robert
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of gmclean at gorge.net
>>>> Sent: Tuesday, October 21, 2008 2:35 PM
>>>> To: fdo-users at lists.osgeo.org
>>>> Subject: RE: [fdo-users] Arc SDE 9.3
>>>>
>>>>
>>>> Thanks Robert, this does help. I was not trying to
>>>> stir things up too much with the thread I posted. I
>>>> just needed to know how relevant it was compared to
>>>> the present state of FDO and ArcSDE so I could take
>>>> that information back to the GIS administrator I am
>>>> working with.
>>>>
>>>> If I understand you correctly, the weekly build will
>>>> support SQL Server with SQL Server Authentication. Is
>>>> that correct?
>>>>
>>>> Thanks again.
>>>>
>>>> George
>>>>
>>>>
>>>>
>>>> ------- Original Message -------
>>>> >From    : Robert
>>>> Fortin[mailto:robert.fortin at autodesk.com]
>>>> Sent    : 10/21/2008 9:30:00 AM
>>>> To      : fdo-users at lists.osgeo.org
>>>> Cc      :
>>>> Subject : RE: [fdo-users] Arc SDE 9.3
>>>>
>>>>  George,
>>>>
>>>> The thread you mention is not only 1.5 years old but
>>>> also talks about Map 2007 which has been released in
>>>> April 2006.  It is using much  older version of the
>>>> ArcSDE FDO provider. Since then Map 2008 and Map 2009
>>>> have been released on updated FDO version and support
>>>> for 9.2 has been added to ArcSDE Provider.  Some of
>>>> the problem discussed there are of course outdated
>>>> mainly the multiple connection issue inside Map.
>>>>
>>>> We already posted an unofficial version of the ArcSDE
>>>> provider supporting 9.3. At the moment, it won't
>>>> support dbo user (on SQL Server) or Windows
>>>> authentication but it is the plan to support those
>>>> features in the 3.4 release.  Unofficial build can be
>>>> downloaded from here
>>>> http://download.osgeo.org/fdo/3.4.0/weekly/.
>>>>
>>>> Some user on this thread have actually indicated that
>>>> they used the existing provider using 9.3 client
>>>> components against 9.3 server without any problem.
>>>>
>>>> As Romy mentioned, you can download the latest patch
>>>> for the provider depending on the version of FDO you
>>>> want to use.  Go to the FDO download page
>>>> http://fdo.osgeo.org/content/downloads.
>>>>
>>>> Hope it helps.
>>>>
>>>> Robert
>>>>
>>>> -----Original Message-----
>>>> From: fdo-users-bounces at lists.osgeo.org [
>>>> mailto:fdo-users-bounces at lists.osgeo.org]  On Behalf
>>>> Of gmclean at gorge.net
>>>> Sent: Tuesday, October 21, 2008 11:56 AM
>>>> To: fdo-users at lists.osgeo.org
>>>> Subject: [fdo-users] Arc SDE 9.3
>>>>
>>>> Is there any estimate on when FDO will support ArcSDE
>>>> 9.3?
>>>>
>>>> The GIS administrator I am working with pointed me to
>>>> the thread below from an ESRI forum that says some
>>>> interesting things about FDO and SDE. I would be
>>>> interested in other FDO users experience with SDE
>>>> regarding stability, locking tables, database
>>>> connections etc. I realize the thread is over a year
>>>> old and there may have been some changes since these
>>>> comments were posted.
>>>>
>>>>  http://forums.esri.com/Thread.asp?c=2&f=59&t=216609&mc=9
>>>>
>>>>
>>>> Thanks
>>>>
>>>> George McLean
>>>>
>>>> _______________________________________________
>>>> fdo-users mailing list
>>>> fdo-users at lists.osgeo.org
>>>>  http://lists.osgeo.org/mailman/listinfo/fdo-users
>>>>
>>>>
>>>> _______________________________________________
>>>> fdo-users mailing list
>>>> fdo-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>> _______________________________________________
>>>> fdo-users mailing list
>>>> fdo-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>>
>>>> No virus found in this incoming message.
>>>> Checked by AVG - http://www.avg.com
>>>> Version: 8.0.175 / Virus Database: 270.8.2/1737 - Release Date: 10/21/2008 9:10 AM
>>>>
>>>>
>>>>
>>>>
>>>>         
>>> _______________________________________________
>>> fdo-users mailing list
>>> fdo-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>>> _______________________________________________
>>> fdo-users mailing list
>>> fdo-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>>> ------------------------------------------------------------------------
>>>
>>>
>>> No virus found in this incoming message.
>>> Checked by AVG - http://www.avg.com
>>> Version: 8.0.175 / Virus Database: 270.8.2/1738 - Release Date: 10/21/2008 2:10 PM
>>>
>>>
>>>
>>>       
>> _______________________________________________
>> fdo-users mailing list
>> fdo-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>> _______________________________________________
>> fdo-users mailing list
>> fdo-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>> ------------------------------------------------------------------------
>>
>>
>> No virus found in this incoming message.
>> Checked by AVG - http://www.avg.com
>> Version: 8.0.175 / Virus Database: 270.8.2/1738 - Release Date: 10/21/2008 2:10 PM
>>
>>
>>     
>
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com 
> Version: 8.0.175 / Virus Database: 270.8.2/1741 - Release Date: 10/23/2008 7:54 AM
>
>   