[fdo-users] Arc SDE 9.3

Fri Oct 24 10:14:31 EDT 2008

I'm not the ArcSDE installation expert but from what I understand, this is configured during the Arcsde installation process.
I don't think moving the table will do the trick or could cause ArcSDE to stop working.

Yesterday our developer did some code change and is conducting some test on 3.4.  If it all works ok,  we will have to backport it to 3.3.X branch and provide you with a patch to test with. Hopefully this could happen sometime next week if we don't encounter other problems.

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 8:27 PM
To: FDO Users Mail List
Subject: Re: [fdo-users] Arc SDE 9.3

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
>
>

_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users