Re: CF8, Vista, SQL 2005

2009-11-21 Thread A D
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

Re: CF8, Vista, SQL 2005

2009-11-21 Thread A D
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

Re: CF8, Vista, SQL 2005

2009-11-21 Thread A D
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

Re: CF8, Vista, SQL 2005

2009-11-21 Thread A D
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.

Re: CF8, Vista, SQL 2005

2009-11-20 Thread A D
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

CF8, Vista, SQL 2005

2009-11-19 Thread A D
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

RE: CF8, Vista, SQL 2005

2009-11-19 Thread brad
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

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
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

RE: CF8, Vista, SQL 2005

2009-11-19 Thread brad
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

RE: CF8, Vista, SQL 2005

2009-11-19 Thread Chad Gray
-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

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
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

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
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

RE: CF8, Vista, SQL 2005

2009-11-19 Thread brad
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

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
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

RE: CF8, Vista, SQL 2005

2009-11-19 Thread Robert Harrison
- 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

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
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

RE: CF8, Vista, SQL 2005

2009-11-19 Thread Robert Harrison
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

RE: CF8, Vista, SQL 2005

2009-11-19 Thread Chad Gray
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

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
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

Re: CF8, Vista, SQL 2005

2009-11-19 Thread Dave Watts
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

RE: CF8, Vista, SQL 2005

2009-11-19 Thread Chad Gray
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

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
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

Re: CF8, Vista, SQL 2005

2009-11-19 Thread Dave Watts
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?

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
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

Re: CF8, Vista, SQL 2005

2009-11-19 Thread Dave Watts
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

Re: CF8, Vista, SQL 2005

2009-11-19 Thread A D
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

RE: CF8, Vista, SQL 2005

2009-11-19 Thread 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

Re: CF8, Vista, SQL 2005

2009-11-19 Thread Dave Watts
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

Re: CF8, Vista, SQL 2005

2009-11-19 Thread Jaime Metcher
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