Dear Friends, Finally the is solved.
Thanks Bobby & Paul. While adding datasource in CF administrator , in server field I was wrongly trying as localhost, now I changed to "MICRO\SQLEXPRESS" as server and db name in database field along with check box checked for Enable High ASCII characters and Unicode for data sources configured for non-Latin characters. This solved the issue. Now am able to successfully connect CF9 with SQL server 2008 and Arabic text is displaying as well. Your valuable time & help is really appreciated. Thanks, Sathya.R On Thu, Aug 7, 2014 at 10:34 AM, Sathyanarayanan Ramanathan < sathya0...@gmail.com> wrote: > Dear, > > Thanks for your replies. But still am facing issue. > > @Paul, > > Yes. I was using ODBC socket datasource to connect CF with SQL server > database. In that the connection was successful but Arabic didn't display > properly in CFM page.(In db the datatype is correctly used nvarchar and I > can see Arabic data as well.) > > @Bobby, > > As per your suggestion, I tried to create datasource with Microsoft SQL > server driver. But am getting the below error. > " > > - Connection verification failed for data source: MCONSULT > java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer > JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. > Reason: Connection refused: connect > The root cause was that: java.sql.SQLNonTransientConnectionException: > [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and > port: 127.0.0.1:1433. Reason: Connection refused: connect > > " > I found few suggestions from net & tried below things but still issue > exists. > 1. In SQL server configuration manager I enabled TCP/IP protocol. > 2. In Windows Firewall I added inbound rule for TCP 1433. > > Both my CF9 & SQL server 2008 are installed in same machine. > > Please suggest. > > Sathya.R > > > On Thu, Aug 7, 2014 at 5:19 AM, Paul Hastings <p...@sustainablegis.com> > wrote: > >> >> On 8/7/2014 6:16 AM, Bobby wrote: >> > >> > He said the arabic text was actually in the database but only ??? when >> > retrieving/displaying with CF. Wouldnt it be garbage IN the db if it >> wasnt >> > an nchar/nvarchar data type? >> >> could be already garbaged as far as cf & unicode go. in the bad old days >> (pre >> cf/java unicode) that was actually the only way to work w/some encodings. >> >> doesn't matter to cf either way. the encodings match back-to-front but >> the text >> data is already garbaged or the encodings are mismatched & getting >> garbaged on >> the way to cf. >> >> >> just to be thorough, i suppose its probably prudent to ask if cf is using >> the >> JDBC driver to talk to the db and not some ODBC thing? >> >> >> >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359085 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm