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: > MS SQL 05 Express + CF8 + Vista > > I've already enabled TCP/IP, and open for 127.0.0.1 (localhost). I can > connect that account through tcp/ip no problem using management studio > express, but CF8 (with built-in Microsoft SQL Server JDBC driver) just gives > me this error message: > > Connection verification failed for data source: XXXX > java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Unexpected LCID: > 3076 > The root cause was that: java.sql.SQLException: [Macromedia][SQLServer > JDBC Driver]Unexpected LCID: 3076 > > > I purposely try a wrong password just to see what happen: > > Connection verification failed for data source: XXXX > java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login > failed for user 'cf'. > The root cause was that: java.sql.SQLException: [Macromedia][SQLServer > JDBC Driver][SQLServer]Login failed for user 'cf'. > > > So this means the connection works, but what the hell is LCID 3076? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:302353 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
