Can you try "mssql2005" as the dbtype? I don't remember what the differences where that required a separate db gateway, but this issue may be related.
Blair On Tue, Apr 2, 2013 at 8:39 AM, Might Aswell <[email protected]> wrote: > MSSQL 2005 - Collation: SQL_Latin1_General_CP1_CI_AS > > > > On Tuesday, March 26, 2013 5:26:20 PM UTC-7, Jason Barnes wrote: > >> Can you paste the db collation >> >> On 27 March 2013 11:21, Might Aswell <[email protected]> wrote: >> >>> I'm using MSSQL2K5 I dont believe any case sensitive settings have been >>> set.. >>> >>> >>> On Tuesday, March 26, 2013 4:17:47 PM UTC-7, Blair McK wrote: >>> >>>> Jason gave me poke to take a look at the dumps. The second dump you >>>> sent (tablemetadata) is the struct that FarCry compares with the DB as it >>>> is. You've mentioned refCategories, nested_tree_objects, and dmHTML - all >>>> three have an "objectid" property in their array of fields, and FarCry >>>> should only suggest dropping a field if it ISN'T in that struct and IS in >>>> the database. I think we can firmly rule out memory corruption / ColdFusion >>>> weirdness. >>>> >>>> What DB are you using? Is it possible you have case-sensitivity >>>> enabled? - that has caused problems for us in past. >>>> >>>> Blair >>>> >>>> >>>> On Wed, Mar 27, 2013 at 6:43 AM, Might Aswell <[email protected]>wrote: >>>> >>>>> Any thoughts? >>>>> >>>>> >>>>> On Wednesday, March 20, 2013 10:53:13 PM UTC-7, Jason Barnes wrote: >>>>> >>>>>> Not sure if my previous post worked but cfdump the following two >>>>>> scopes for debugging and attach as txt files to this thread: >>>>>> >>>>>> application.fc.lib.db.**tablemet****adata >>>>>> >>>>>> application.stCoapi["dmHTML"] >>>>>> >>>>>> >>>>>> >>>>>> On Thursday, March 21, 2013 3:50:51 AM UTC+11, Might Aswell wrote: >>>>>>> >>>>>>> Hi all.. just a quick ? for anyone that might know... just upgraded >>>>>>> from 6-0-15 to 6.2.7 and see a lot of schema changes.. I notice >>>>>>> objectid is >>>>>>> to be dropped in many tables.. should I be worried about this.. seems >>>>>>> like >>>>>>> I use objectID in a lot of places... >>>>>>> >>>>>> -- >>>>> You received this message cos you are subscribed to "farcry-dev" >>>>> Google group. >>>>> To post, email: [email protected] >>>>> To unsubscribe, email: farcry-dev+...@**googlegroups.**com >>>>> >>>>> For more options: >>>>> http://groups.google.com/**group**/farcry-dev<http://groups.google.com/group/farcry-dev> >>>>> ------------------------------****-- >>>>> Follow us on Twitter: http://twitter.com/farcry >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "farcry-dev" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to farcry-dev+...@**googlegroups.**com. >>>>> >>>>> For more options, visit >>>>> https://groups.google.com/**grou**ps/opt_out<https://groups.google.com/groups/opt_out> >>>>> . >>>>> >>>>> >>>>> >>>> >>>> -- >>> You received this message cos you are subscribed to "farcry-dev" Google >>> group. >>> To post, email: [email protected] >>> To unsubscribe, email: farcry-dev+...@**googlegroups.com >>> For more options: >>> http://groups.google.com/**group/farcry-dev<http://groups.google.com/group/farcry-dev> >>> ------------------------------**-- >>> Follow us on Twitter: http://twitter.com/farcry >>> --- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "farcry-dev" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/** >>> topic/farcry-dev/fAT9Z3jy-LE/**unsubscribe?hl=en-GB<https://groups.google.com/d/topic/farcry-dev/fAT9Z3jy-LE/unsubscribe?hl=en-GB> >>> . >>> To unsubscribe from this group and all of its topics, send an email to >>> farcry-dev+...@**googlegroups.com. >>> >>> For more options, visit >>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>> . >>> >>> >>> >> >> >> >> -- >> Jason Barnes | CTO | Daemon | p. 02 8999 8885 | http://www.daemon.com.au >> > -- > You received this message cos you are subscribed to "farcry-dev" Google > group. > To post, email: [email protected] > To unsubscribe, email: [email protected] > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry > --- > You received this message because you are subscribed to the Google Groups > "farcry-dev" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry --- You received this message because you are subscribed to the Google Groups "farcry-dev" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
