Webmaster Forum / ColdFusion / Database Access / November 2007

Hello I have a script that was developed a long time ago.  I wish to use it
now, However i'm receiving the following errors. Is this because it was
developed with an older version of CF?   Can anyone spot out what I can change
to make this work.  Im running CFmx7.  Any help is ...

Hi, I am having trouble with this error message - have used similar code before
without any problems (I'm pretty new to coldfusion)
Error Executing Database Query.  
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft

This seems like it probably has a simple solution that I just can't seem to get
correct...
I need to output the next 4 events that take place from the current date.  I
tried:

Please Help!
I've created database connections to both Mysql and MS Access databases in the
ColdFusion Administrator Data Source page (I've used both Mysql and Access to
test what's wrong with the connection).

While testing a new application using the CF 8 rich text control and pasting in
Word content to update a database, I came across a strange problem. I pasted
about 30 separate entries and successfully updated the database each time.
However, one block of content returned the error ...

I downloaded and installed CF8 and I haven't been able to connest my access
database.  I saw another post whereby the same problem occured and someone
stated that there was a problem with the installer.  Has this been correct?  I
also lost the connection to my CFMX 6.0 ...

I have just setup a new installation for CF 8 on windows XP Pro.  Windows XP is
also only a few days old.
When attempting to create a datasource (either access or SQL Server), I
recieve the following error:

Does anyone know what the practical limits are on the number of datasources one
can set up withing a single CF
application? I'd like to be able to create one app and serve sveral clients,
each client with its own database..

How can I save an dynamic array in a DB, without looping over the content.
I think serialization is the key word. Can anybody give me further information, pls?
Thx an lot.
Regards, Philipp

I was given a long list of email addresses from a client, some of which are
badly formatted, don't include an @, or a dot, etc.
Is there a quick routine or program out there that can look through a long
list of email addresses, and ID the bad ones, so I don't have to go through

Since upgrading from MX 7 to Coldfusion 8 I have serious database issues.
Simple queries with small database tables ( less than 100 records) take
minutes to run.
I am getting many deadlocks even though I am the only one on the server or

Is anyone else getting this error?
I?m using the oracle JDBC drivers instead of the Macromedia drivers.
Here's the PL/SQL I used to create the test table...
CREATE TABLE my_table (

I have a cfquery in CF8 that is creating a temp table in SQL2005, the query
itself is not erroring out but when I try to dump the results it is telling me
that the variable is not defined. I've narrowed it down to this small query
that is still having the same problem:

Hi, I have 7 tables in my database that i need to query. The tables i have are
[bullet]client details[/bullet]
[bullet]Caseworker[/bullet]
[b]Tranaction tables[/b]

Running under CF7.02 and SQL Server 2000, we're getting bottlenecks on
attempting database inserts into our by far most active requests table. Within
the database transaction, we check to see if the request is a duplicate. Then
we do an exclusive type cflock with timeout of 90, ...