The options field value is using bit flags... so just break the option # you are using into it's proper pieces for each bit value.
131609 = 131072+512+16+8+1 This is equivalent to a number where the bits 17,9,4,3,0 are set. Looking at the MyODBC reference this is equivalent to: FLAG_SAFE + FLAG_PAD_SPACE + FLAG_NO_PROMPT + FLAG_BIG_PACKETS + FLAG_FIELD_LENGTH At 08:28 AM 9/13/2007, you wrote: >Eugene Vital wrote: > >>> This is the specific setting that affects it. > >>> > >>> 16384 |FLAG_NO_BIGINT| Change BIGINT Columns to > Int Change |BIGINT| > >>> columns to |INT| columns (some applications can't handle |BIGINT|). > >>> > >>> > >>> > >>> > >> I just wish it were easy to see the compilations of the different values > >> to come up with that final magic number. > >> > >> > >> > > Well in this case, 16384 there is no compilation that would add up to > > that number. > > > > There is only one way to achieve the 16899, 16384 + 512 + 2 + 1 > > > >I'm not using any BIGINT columns...INT works just fine for me...so I'm >curious as to what other flags I was using in my 131609 value. > >-- >Michael J. Babcock, MCP >MB Software Solutions, LLC >http://mbsoftwaresolutions.com >http://fabmate.com >"Work smarter, not harder, with MBSS custom software solutions!" > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
