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
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
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
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'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
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
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
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
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
-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
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 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
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
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
-
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
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
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
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
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
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
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
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
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?
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
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
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
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
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
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
29 matches
Mail list logo