[fdo-users] Arc SDE 9.3

Robert Fortin robert.fortin at autodesk.com
Thu Oct 23 11:58:05 EDT 2008


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


More information about the fdo-users mailing list