Indeed.. ;-)


-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of SteveNelson (sent by Nabble.com)
Sent: 16 May 2006 12:34
To: [email protected]
Subject: [farcry-dev] Re: Body Content Deleted



I've traced this back to Windows XP SP2. When SP2 came out they changed the
way SQL server datasources work. The built in firewall automatically blocked
SQL server. One of the quick fixes was to use an ODBC socket instead of the
MS SQL Server. I'm starting to remember now... I was having problems when
this first came out, so i switched to the ODBC socket method. Everything
seemed to work fine. I've been using ODBC socket ever since then.

Since I haven't done much of anything with unicode, using ODBC socket hasn't
affected me because I haven't been using the "N" (nvarchar, ntext) fields in
SQL server. 

By switching to the Coldfusion MS SQL Server datasource it works fine.  So
i'm now going to switch off of ODBC socket and back to MS SQL server because
this is a good reason to do it.

Steve
--

Sent from the FarCry - Dev forum at Nabble.com.


This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/farcry-dev
-~----------~----~----~----~------~----~------~--~---

Reply via email to