> > Have you set sendStringParametersAsUnicode in your JDBC URL? If > > not, set it to false and try again. > > fyi, how would i set that param in the jdbc url? here is my current: > jdbc:sqlserver:// server1 : 1433 ;DatabaseName=db1
I'm pretty sure you can just tack it onto the end: jdbc:sqlserver://server1:1433;DatabaseName=db1;sendStringParametersAsUnicode =false However, if you're using the DataDirect drivers, I'm pretty sure you can set this within the CF Administrator. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265849 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
