Stephen, Yes the old native client works fine but doesn't support the Failover parameter for autofailover when using a witness, which was the main reason for installing the mirrors.
There are lots of parameters for the client and one is AutoTranslate which specifically mentions Varchar(max) fields but it doesn't seem to do anything. However it may be me because the documentation switches between Autotrans= and Auto_Trans= and the following parameter being "true/False" or "Yes/No" so I guess I need to try out all possibilities. The other parameter I found was Typeversion which matches the client to the server version and affects character translation. Yopu can set it to the parameter value "Latest" which will automatically match the client to the SQLServer version used but again it seems to have no effect. Finally I have checked all the ANSI Code page values on the server and they are all set correctly so it is DEFINITELY the client driver. Oh, and the Microsoft documentation is just crap .... unless you are a C++ developer where it goes into great lengths but all the parameters are different. Oh well, been at it now for 14 hours and at least we are stable and mirroring... Thanks all of you for your help and concern .... Another day tomorrow! Dave -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Russell Sent: 13 February 2012 16:33 To: ProFox Email List Subject: Re: [NF] Urgent M$SQL help On Mon, Feb 13, 2012 at 10:16 AM, Dave Crozier <[email protected]> wrote: > Stephen, > It would seem to be the new 10.0 client that is causing the problem. > Reverting to the standard preinstalled SQL Driver sorts the problem out so at > least I know now that the database integrity is intact which was my main > concern. > > There is obviously a setting in the new driver that is stopping the app > seeing the blob data correctly so I'll investigate more but the problem is > now not so urgent. The main problem with the old drivers is that they don't > support the failover which is why I am doing all this data transfer as we > have two servers now mirrored which at least I can now use, albeit only with > manual failover until I sort out this problem.... but at least I have a > working system and not 500 people baying for blood because all their document > scans and pictures have disappeared!!! > > I'll keep you all posted. > ---------------- Was the client updated to be referenced in the connection string? I was guessing YES otherwise it would not have received any data, and you are only having a problem with varchar(max) data. If the former client works keep using it! ;-> -- Stephen Russell 901.246-0159 cell [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.
