I've fixed the problem by changing the Collation settings to one that gets recongnized by the MS SQL JDBC driver.
Thanks. >LCID = Locale Identifier... is your SQL installation the same locale as your >windows and jvm? I don't know that it matters, but you could check. > >I really don't know about the LCID error, but I can offer a few of my own >troubleshooting tips for getting CF to talk to SQL express on localhost. > >1 - make sure TCP/IP is turned on - this is in the sql server configuration >manager >2 - same tool, check the TCP port your SQL server is listening on - it's >usually not the standard one >3 - paste that port number into your CF admin >4 - make a sql server user account for CF to log into your database - make >sure to assign a password >5 - make sure the cf user account has appropriate access granted - for dev >work, I would just make it dba >6 - make sure you use the right database name & password in your cf admin > >And if that doesn't work.... check your windows firewall or other firewall >apps. Turn off other applications like Skype, restart the sql & cf services. >That's about all I know off the top of my head. > >-- >nathan strutz >http://www.dopefly.com/ > > > >On Mon, Mar 31, 2008 at 11:30 AM, henry ho <[EMAIL PROTECTED]> wrote: > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302359 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
