Re: CF8, Vista, SQL 2005
I've changed server in CF datasource settings to 'localhost' as opposed to 'OWNER-PC' Seems to be working now for both types of driver. Thanks for the help! I'll try out another driver as soon as possible. Thanks for the links and info. How can I setup a different JDBC driver ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328583 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
I changed datasource server setting to 'localhost' instead of 'OWNER-PC'. Seems to work for both drivers now. Thanks I'll try out another driver as soon as possible. Thanks for the links and info. How can I setup a different JDBC driver ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328582 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
I've changed server in CF datasource settings to 'localhost' as opposed to 'OWNER-PC' Seems to be working now for both types of driver. Thanks for the help! I'll try out another driver as soon as possible. Thanks for the links and info. How can I setup a different JDBC driver ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328584 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8, Vista, SQL 2005
I've changed server in CF datasource settings to 'localhost' as opposed to 'OWNER-PC' Seems to be working now for both types of driver. Thanks for the help! Place its JAR in your class path, restart CF and add the data source by constructing the JDBC URL and specifying the driver class name. I've always used the data direct drivers for SQL Server, but this might get you started: http://msdn.microsoft.com/en-us/data/aa937724.aspx ~Brad How can I setup a different JDBC driver ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328585 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
I'll try out another driver as soon as possible. Thanks for the links and info. Place its JAR in your class path, restart CF and add the data source by constructing the JDBC URL and specifying the driver class name. I've always used the data direct drivers for SQL Server, but this might get you started: http://msdn.microsoft.com/en-us/data/aa937724.aspx ~Brad How can I setup a different JDBC driver ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328573 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8, Vista, SQL 2005
Hi, I have CF8 installed on a Vista laptop using SQL Server 2005. I can connect to the datasource from CF but my queries appear to timeout or hang when using 'SELECT *'. Using 'SELECT colA, colB.' seems to work. I didn't have any problems with the CF8 and SQL 2005 on an XP laptop. Any help appreciated. Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF8, Vista, SQL 2005
What happens when you run the query in SQL Server management studio? When it hangs what is the CPU and disk I/O doing? What is the execution plan being used? ~Brad Original Message Subject: CF8, Vista, SQL 2005 From: A D alandeans2...@yahoo.co.uk Date: Thu, November 19, 2009 10:27 am To: cf-talk cf-talk@houseoffusion.com Hi, I have CF8 installed on a Vista laptop using SQL Server 2005. I can connect to the datasource from CF but my queries appear to timeout or hang when using 'SELECT *'. Using 'SELECT colA, colB.' seems to work. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328515 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
No problems in Management Studio. CPU and I/O appear normal. Not sure about the execution plan. Thanks What happens when you run the query in SQL Server management studio? When it hangs what is the CPU and disk I/O doing? What is the execution plan being used? ~Brad Hi, I have CF8 installed on a Vista laptop using SQL Server 2005. I can connect to the datasource from CF but my queries appear to timeout or hang when using 'SELECT *'. Using 'SELECT colA, colB.' seems to work. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328517 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
Run a trace on the DB while you run the query in CF and see if the statement is ever making it to the database. It may be a data source driver issue. ~Brad Original Message Subject: Re: CF8, Vista, SQL 2005 From: A D alandeans2...@yahoo.co.uk Date: Thu, November 19, 2009 11:15 am To: cf-talk cf-talk@houseoffusion.com No problems in Management Studio. CPU and I/O appear normal. Not sure about the execution plan. Thanks What happens when you run the query in SQL Server management studio? When it hangs what is the CPU and disk I/O doing? What is the execution plan being used? ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
SQL Express or full installation of SQL server? If I remember right with Vista, SQL Express and CF you have to change some setting in SQL server to allow a connection. The port is different and there is a TCP setting you have to change. You may want to look at your firewall also. Chad -Original Message- From: A D [mailto:alandeans2...@yahoo.co.uk] Sent: Thursday, November 19, 2009 11:27 AM To: cf-talk Subject: CF8, Vista, SQL 2005 Hi, I have CF8 installed on a Vista laptop using SQL Server 2005. I can connect to the datasource from CF but my queries appear to timeout or hang when using 'SELECT *'. Using 'SELECT colA, colB.' seems to work. I didn't have any problems with the CF8 and SQL 2005 on an XP laptop. Any help appreciated. Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Chad I think the datasource connection is ok as I can select single individual columns in a query. Thanks SQL Express or full installation of SQL server? If I remember right with Vista, SQL Express and CF you have to change some setting in SQL server to allow a connection. The port is different and there is a TCP setting you have to change. You may want to look at your firewall also. Chad -Original Message- From: A D [mailto:alandeans2...@yahoo.co.uk] Sent: Thursday, November 19, 2009 11:27 AM To: cf-talk Subject: CF8, Vista, SQL 2005 Hi, I have CF8 installed on a Vista laptop using SQL Server 2005. I can connect to the datasource from CF but my queries appear to timeout or hang when using 'SELECT *'. Using 'SELECT colA, colB.' seems to work. I didn't have any problems with the CF8 and SQL 2005 on an XP laptop. Any help appreciated. Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8, Vista, SQL 2005
I ran a trace and the query statement showed up straight away in the trace but CF page just keeps waiting. Thanks Run a trace on the DB while you run the query in CF and see if the statement is ever making it to the database. It may be a data source driver issue. ~Brad No problems in Management Studio. CPU and I/O appear normal. Not sure about the execution plan. Thanks What happens when you run the query in SQL Server management studio? When it hangs what is the CPU and disk I/O doing? What is the execution plan being used? ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
In the trace does the statement complete? If you look at sysprocesses is that spid still running? Are there any object locks that would affect the query? ~Brad Original Message Subject: Re: CF8, Vista, SQL 2005 From: A D alandeans2...@yahoo.co.uk Date: Thu, November 19, 2009 2:22 pm To: cf-talk cf-talk@houseoffusion.com I ran a trace and the query statement showed up straight away in the trace but CF page just keeps waiting. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8, Vista, SQL 2005
Status: sleeping Command: AWAITING COMMAND Blocked By: 0 Got a bit further - The table Im using has quite a few colums. I can do 'select top 33 *' but not 'select top 34 *' Could there be some limit to the amount of data SQL can return? In the trace does the statement complete? If you look at sysprocesses is that spid still running? Are there any object locks that would affect the query? ~Brad I ran a trace and the query statement showed up straight away in the trace but CF page just keeps waiting. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
What's quite a few? I have a couple of SQL tables with more than 100 columns, one with over 200 columns, and have no problems at all... and that's SQL 2005, Vista, CF8. You may have a problem with available memory or disk space. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged -Original Message- From: A D [mailto:alandeans2...@yahoo.co.uk] Sent: Thursday, November 19, 2009 4:30 PM To: cf-talk Subject: Re: CF8, Vista, SQL 2005 Status: sleeping Command: AWAITING COMMAND Blocked By: 0 Got a bit further - The table Im using has quite a few colums. I can do 'select top 33 *' but not 'select top 34 *' Could there be some limit to the amount of data SQL can return? In the trace does the statement complete? If you look at sysprocesses is that spid still running? Are there any object locks that would affect the query? ~Brad I ran a trace and the query statement showed up straight away in the trace but CF page just keeps waiting. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Its around 40 columns - none of them text or ntext. I cant see any problems with disk space. Thanks What's quite a few? I have a couple of SQL tables with more than 100 columns, one with over 200 columns, and have no problems at all... and that's SQL 2005, Vista, CF8. You may have a problem with available memory or disk space. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged Status: sleeping Command: AWAITING COMMAND Blocked By: 0 Got a bit further - The table Im using has quite a few colums. I can do 'select top 33 *' but not 'select top 34 *' Could there be some limit to the amount of data SQL can return? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
I run CF8, SQL 2005 on my Vista laptop for demos (and development at home) and have no issues... and some of the record are significant. I doubt this is an issue, but if you SQL DB is more than 1.2 Terabytes then you're hitting the SQL Server performance limit. You probably don't even have that much disk space. Look at the processes you have running and shut down some non-essentials. Memory is the most likely culprit... or maybe your program has a never-ending loop... that will do it too. Good Luck... Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4623 (20091119) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328532 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
Just a guess, but maybe do some maintenance on the database. Try a shrink. Rebuild the indexs. Is the database from SQL 2005 or an earlier version? Sound like it is more on the CF end than the database through. Check the DSN setting in CFadministrator also. Remove it and add it back using the default settings. -Original Message- From: A D [mailto:alandeans2...@yahoo.co.uk] Sent: Thursday, November 19, 2009 4:43 PM To: cf-talk Subject: Re: CF8, Vista, SQL 2005 Its around 40 columns - none of them text or ntext. I cant see any problems with disk space. Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Database size is around 800mb. Im using a test cfm page with one query so I dont think its a loop. Thanks I run CF8, SQL 2005 on my Vista laptop for demos (and development at home) and have no issues... and some of the record are significant. I doubt this is an issue, but if you SQL DB is more than 1.2 Terabytes then you're hitting the SQL Server performance limit. You probably don't even have that much disk space. Look at the processes you have running and shut down some non-essentials. Memory is the most likely culprit... or maybe your program has a never-ending loop... that will do it too. Good Luck... Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4623 (20091119) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328534 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Its around 40 columns - none of them text or ntext. I cant see any problems with disk space. Forgive me if you've already answered this in the thread, but have you tried explicitly selecting all 40 of the columns? 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
Also try restarting the CF ODBC services. There are two of them in the services control panel. -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Thursday, November 19, 2009 5:04 PM To: cf-talk Subject: RE: CF8, Vista, SQL 2005 Just a guess, but maybe do some maintenance on the database. Try a shrink. Rebuild the indexs. Is the database from SQL 2005 or an earlier version? Sound like it is more on the CF end than the database through. Check the DSN setting in CFadministrator also. Remove it and add it back using the default settings. -Original Message- From: A D [mailto:alandeans2...@yahoo.co.uk] Sent: Thursday, November 19, 2009 4:43 PM To: cf-talk Subject: Re: CF8, Vista, SQL 2005 Its around 40 columns - none of them text or ntext. I cant see any problems with disk space. Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Selecting the 40 colums results in the same, but selecting a few coulumns is ok. Ive tried restarting services. Thanks Its around 40 columns - none of them text or ntext. I cant see any problems with disk space. Forgive me if you've already answered this in the thread, but have you tried explicitly selecting all 40 of the columns? 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8, Vista, SQL 2005
Its around 40 columns - none of them text or ntext. ... Selecting the 40 colums results in the same, but selecting a few columns is ok. I suspect you're hitting some sort of row length limitation in the JDBC drivers. Are you able to select an entire row from a native SQL Server client? 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Its works ok using SQL managment studio. Doesnt work from eclipse RDS or CF. Its around 40 columns - none of them text or ntext. ... Selecting the 40 colums results in the same, but selecting a few columns is ok. I suspect you're hitting some sort of row length limitation in the JDBC drivers. Are you able to select an entire row from a native SQL Server client? 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
Its works ok using SQL managment studio. Doesnt work from eclipse RDS or CF. Then it's almost certainly a JDBC issue. You could try to find information about it in the DataDirect documentation (CF uses DataDirect Connect for JDBC) or you could try a different JDBC driver for SQL Server. 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
How can I setup a different JDBC driver Thanks Its works ok using SQL managment studio. Doesnt work from eclipse RDS or CF. Then it's almost certainly a JDBC issue. You could try to find information about it in the DataDirect documentation (CF uses DataDirect Connect for JDBC) or you could try a different JDBC driver for SQL Server. 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, Vista, SQL 2005
Place its JAR in your class path, restart CF and add the data source by constructing the JDBC URL and specifying the driver class name. I've always used the data direct drivers for SQL Server, but this might get you started: http://msdn.microsoft.com/en-us/data/aa937724.aspx ~Brad Original Message Subject: Re: CF8, Vista, SQL 2005 From: A D alandeans2...@yahoo.co.uk Date: Thu, November 19, 2009 4:49 pm To: cf-talk cf-talk@houseoffusion.com How can I setup a different JDBC driver ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Vista, SQL 2005
How can I setup a different JDBC driver Here are some examples: http://www.bpurcell.org/blog/index.cfm?ENTRY=981mode=entry http://blog.demirkapi.net/post.cfm/installing-jtds-sql-server-jdbc-driver-for-coldfusion Here's the Adobe documentation for CF 7 - it works basically the same way in other versions also, though: http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=0056.htm 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8, Vista, SQL 2005
It might be worth looking at the connection settings in SQL studio. SQL studio by default will truncate long fields, which may be hiding row size limitations. If you bump up the field length limit in SQL studio and it still works, that would point even more strongly to JDBC. Jaime On Fri, Nov 20, 2009 at 8:37 AM, A D alandeans2...@yahoo.co.uk wrote: Its works ok using SQL managment studio. Doesnt work from eclipse RDS or CF. Its around 40 columns - none of them text or ntext. ... Selecting the 40 colums results in the same, but selecting a few columns is ok. I suspect you're hitting some sort of row length limitation in the JDBC drivers. Are you able to select an entire row from a native SQL Server client? 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4