RE: Blob/clob issue
> Is it possible that the SQL Server is using an instance other > than default? I.E. if your servername is "SQLServer" and the > instance is "mydb" than you may have to use "SQLServer\mydb" > as the servername in your connection. If you're using JDBC and TCP/IP to connect, you do not have to specify the name of the instance; in fact, unless that name is resolvable, you won't be able to - you have to specify a resolvable name or IP address. Each named instance listens on a different port. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277686 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blob/clob issue
>Well ... looks like there might be an issue with TCP/IP although it is >enabled, in fact, I unchecked it a rechecked it, restarted SQL Server. >Couldn't connect trying to telnet in using the IP of the box it's on and the >standard 1433 on the port ... I'm going to reboot the server in a bit after >everyone has left for the day and see what if any effect that might have. > >Bob > >user=22382.15322.4 Bob, Is it possible that the SQL Server is using an instance other than default? I.E. if your servername is "SQLServer" and the instance is "mydb" than you may have to use "SQLServer\mydb" as the servername in your connection. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blob/clob issue
Well ... looks like there might be an issue with TCP/IP although it is enabled, in fact, I unchecked it a rechecked it, restarted SQL Server. Couldn't connect trying to telnet in using the IP of the box it's on and the standard 1433 on the port ... I'm going to reboot the server in a bit after everyone has left for the day and see what if any effect that might have. Bob > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 10, 2007 5:08 PM > To: CF-Talk > > Your problem is likely one of these things: > - you don't have the TCP/IP listener enabled on the database server, > - you are specifying the wrong server and/or port in the CF datasource, > - there is a firewall blocking either your application server's outbound > traffic or your database server's inbound traffic on the port in question. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ user=22382.15322.4 ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277679 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Blob/clob issue
> Dave this is what I've run into with every attempt so far: > Connection verification failed for data source: Faculty_Profile2 > java.sql.SQLException: [Macromedia][SQLServer JDBC > Driver]Error establishing socket. Connection refused: connect > The root cause was that: java.sql.SQLException: > [Macromedia][SQLServer JDBC Driver]Error establishing socket. > Connection refused: connect Your problem is likely one of these things: - you don't have the TCP/IP listener enabled on the database server, - you are specifying the wrong server and/or port in the CF datasource, - there is a firewall blocking either your application server's outbound traffic or your database server's inbound traffic on the port in question. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277677 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Blob/clob issue
Bob, Have you verified that your SQL server is listening on the standard port 1433? Try to telnet to it: Telnet servername 1433 If that doesn't open a blank screen telnet connection, that is your issue. Chris -Original Message- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 3:29 PM To: CF-Talk Subject: RE: Blob/clob issue It is enabled, although I'm definitely not a db admin by a long shot. I know the basics of to get around and work within enterprise manager and such. But I'm always willing to break things ;) Bob > -Original Message- > From: Peterson, Chris [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 10, 2007 3:23 PM > To: CF-Talk > Subject: RE: Blob/clob issue > > Check your SQL server configuration and make sure that TCP/IP access > is enabled (its off by default) > > Chris Peterson ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blob/clob issue
It is enabled, although I'm definitely not a db admin by a long shot. I know the basics of to get around and work within enterprise manager and such. But I'm always willing to break things ;) Bob > -Original Message- > From: Peterson, Chris [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 10, 2007 3:23 PM > To: CF-Talk > Subject: RE: Blob/clob issue > > Check your SQL server configuration and make sure that TCP/IP access is > enabled (its off by default) > > Chris Peterson ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blob/clob issue
Check your SQL server configuration and make sure that TCP/IP access is enabled (its off by default) Chris Peterson -Original Message- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 3:07 PM To: CF-Talk Subject: RE: Blob/clob issue Dave this is what I've run into with every attempt so far: Connection verification failed for data source: Faculty_Profile2 java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect > If you're unable to use the DataDirect drivers that come with CF to > connect, you will likely not be able to use any other JDBC drivers to > connect, either. What error do you get when you try to set up the > connection? > > 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! > > This email has been processed by SmoothZap - www.smoothwall.net > ...com/cf_lists/unsubscribe.cfm?user=28108.19997.4 ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Blob/clob issue
Dave this is what I've run into with every attempt so far: Connection verification failed for data source: Faculty_Profile2 java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect > If you're unable to use the DataDirect drivers that come with CF to > connect, > you will likely not be able to use any other JDBC drivers to connect, > either. What error do you get when you try to set up the connection? > > 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! > > This email has been processed by SmoothZap - www.smoothwall.net > ..com/cf_lists/unsubscribe.cfm?user=28108.19997.4 ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277657 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blob/clob issue
> Unfortunately, I've not been able to successfully register a > ds in cf w/ms sql drivers, yet another story ;). So, off to > pull down jdbc drivers from ms and see what I can break. If you're unable to use the DataDirect drivers that come with CF to connect, you will likely not be able to use any other JDBC drivers to connect, either. What error do you get when you try to set up the connection? 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! This email has been processed by SmoothZap - www.smoothwall.net ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277633 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blob/clob issue
I have also had good luck with the jTDS open source JDBC driver here : http://jtds.sourceforge.net/ Here is what you will need once you stick the JDBC drivers in the JVM path for CF and re-start coldfusion: Add a datasource of type 'other' The JDBC URL is: jdbc:jtds:sqlserver://hostName:1433(usually 1433, unless you have a different port)/DatabaseName So, Mine is: jdbc:jtds:sqlserver://matrix:1433/REPORTS where Matrix is my SQL server name, and 'Reports' is my database name And the driver class is: net.sourceforge.jtds.jdbc.Driver Have fun! Chris Peterson -Original Message- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 9:28 AM To: CF-Talk Subject: RE: Blob/clob issue Unfortunately, I've not been able to successfully register a ds in cf w/ms sql drivers, yet another story ;). So, off to pull down jdbc drivers from ms and see what I can break. Gracias! > -Original Message- > From: Peterson, Chris [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 10, 2007 8:57 AM > To: CF-Talk > Subject: RE: Blob/clob issue > > Bob, > > First I would try the built in MS SQL driver, and if that still fails > give the Microsoft JDBC driver a shot. > > Chris > > -Original Message- > From: Bob Imperial [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 10, 2007 8:56 AM > To: CF-Talk > Subject: Blob/clob issue > ://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=22382.15322.4 ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277614 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Blob/clob issue
Unfortunately, I've not been able to successfully register a ds in cf w/ms sql drivers, yet another story ;). So, off to pull down jdbc drivers from ms and see what I can break. Gracias! > -Original Message- > From: Peterson, Chris [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 10, 2007 8:57 AM > To: CF-Talk > Subject: RE: Blob/clob issue > > Bob, > > First I would try the built in MS SQL driver, and if that still fails > give the Microsoft JDBC driver a shot. > > Chris > > -Original Message- > From: Bob Imperial [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 10, 2007 8:56 AM > To: CF-Talk > Subject: Blob/clob issue > ://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=22382.15322.4 ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277612 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blob/clob issue
Bob, First I would try the built in MS SQL driver, and if that still fails give the Microsoft JDBC driver a shot. Chris -Original Message- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 8:56 AM To: CF-Talk Subject: Blob/clob issue Well . it's almost Friday and none to soon for me. I have an issue I've run into I'm hoping someone out there might have a solution for. First off I'm working with CFMX 7, MSSQL 2k on a Win 2003 Web Server and using an ODBC driver. I have an ntext field that's not returning any data to me for display, I've dumped my query and there are actually a couple of ntext fields that just return and empty string. The thing is, this ntext field displays fine in an aspx page within an old site I am rebuilding (or trying to anyway) using ColdFusion. Anyone ever run into this and more importantly, can anyone offer a solution? I've done a google or two on it with no real luck on a solution yet. Oh and the query is as simple as it gets, doing SELECT * Thanks! Tired Bob ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277606 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Blob/clob issue
Well . it's almost Friday and none to soon for me. I have an issue I've run into I'm hoping someone out there might have a solution for. First off I'm working with CFMX 7, MSSQL 2k on a Win 2003 Web Server and using an ODBC driver. I have an ntext field that's not returning any data to me for display, I've dumped my query and there are actually a couple of ntext fields that just return and empty string. The thing is, this ntext field displays fine in an aspx page within an old site I am rebuilding (or trying to anyway) using ColdFusion. Anyone ever run into this and more importantly, can anyone offer a solution? I've done a google or two on it with no real luck on a solution yet. Oh and the query is as simple as it gets, doing SELECT * Thanks! Tired Bob ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277604 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
