This is for anyone having trouble connecting to SQL Server on Parallels from ColdFusion on Mac OS X.
Each time I’ve installed a new version of SQL server — be it 2005 or 2008 — it took me a bit a random clicking to get a ColdFusion datasource connected to SQL Server.
Here are some tips.
Make sure [...]
One of the advantages of our decades of combined experience is speed—we identify, prioritize and fix the causes of performance and stability problems as quickly and effectively as humanly possible. If you’ve got ColdFusion performance and/or stability problems, and you haven’t yet hired us for consulting, then I’d like to invite you to try our [...]
Maintenance Plans in MS SQL 2005 are a powerful and easy way to manage and backup your databases. In this article, I’m going to walk through 4 basic tasks that we run weekly on a client’s database. You’ll learn how to reorganize indexes, create a full backup (*.bak), shrink your database (shrinks both data and [...]
Seems there’s a lot of ColdFusion sites out there getting hit by an automated SQL Injection attack, which adds a “<script>” tag to varchar fields using a bit of SQL Server t-sql.
Many years ago, I wrote a script that would find and automatically <cfqueryparam> queries (which has been at Daryl’s ColdFusion Primer. I’ve dug [...]
ColdFusion 8.0 added the ability to specify a “validation query” that will be run every time a connection is reused in a connection pool. This is useful in cases where database servers or firewalls sometimes drop connections without warning, as it causes a new connection to be made to the database server for the [...]
If you’re using ColdFusion to access BLOBs stored in a Sybase server, you may have a problem. Apparently, Sybase severely limits the timeframe wherein you’re allowed to retrieve the actual binary data, which is supposed to be available until the end of the current transaction. ColdFusion doesn’t pull the backing binary data immediately, and when [...]
At Webapper, we’re big fans of monitoring tools. You absolutely MUST be able to see what’s going on inside your software in real time. We use MySQL on some of our production servers, and we’ve been using SQLyog as an administration GUI for many years. It’s a great way to run MySQL databases–it’s one of [...]
There’s a copious quantity of information online about running MSSQL2k and MSSQL2k5 at the same time, but I just did it, and wanted to document my process.
First off, you must have SP4 installed on SQL Server 2000. (I’m running the MSDE edition.) Additionally, you have to have that version installed before installing 2005. (I’m using [...]
A blog entry at:
http://www.coldfusionmuse.com/index.cfm/2005/6/10/sqlInterbase
reminded me of how people don’t fully understand the multithreaded nature of ColdFusion with respect to databases when looking for the next ID value for a table.
People quite often do something like this in a page:
::CODECOLORER_BLOCK_4::
However, this will give you duplicate IDs when two pages run concurrently. For example, request A [...]
The development practice at Webapper does a fair bit of “version 2″ system development. Our customer has an existing application, built maybe in ColdFusion, maybe in PHP or another scripting language. Maybe in Access forms, maybe as a desktop application. We’ll use it as a prototype for creating a new webified application.
One part of these [...]
