Just noticed a difference in the problematic database vs. another server
that works:
1. In SQL, right click on the database server (at the top of the tree)
2. Go to "General"
3. Look at "Server Collation".
1. In Production (and on Development) this says
"SQL_Latin1_General_CP1_CI_AS"
2. In DR and test, which work OK, this says "Latin1_General_CI_AI"
The questions are:
1. Is this difference what's causing the issue
2. Why and how did this change
As far as I can tell this is neither easy nor fun to change back.
On Fri, Nov 21, 2008 at 11:10 AM, Bill Bookers <[EMAIL PROTECTED]>wrote:
> We had considered that, but stopped short of trying it. In SQL, for the
> external table, under "column properties" it says data type = int, length =
> 4; in the Admin tool, it shows this field with a field length of 15. This is
> how it's "supposed" to be, and it works this way on other servers, so we've
> left that setting alone, for now.
>
> I might try changing this to see if it works, but I don't see that this is
> where the change occurred that is causing our problem.
>
> Thank you!
>
> On Fri, 21 Nov 2008 09:58:31 -0600, Grooms, Frederick W <
> [EMAIL PROTECTED]> wrote:
>
> >Out of curiosity ... You said in an earlier message the Database Input
> Length was 4 on the form for that column.
> >What happens when you change it to 5 (or 15)?
> >
> >Fred
> >
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
