Webmaster Forum / ColdFusion / Server Administration / August 2006

I've been trying to use a FileMaker Pro database as a datasource using a local
CF test server (I'm on Mac OS  X so I don't have Access but have FM Pro
already), and did something stupid that seems to have messed up all my existing
data sources. In the CF Administrator under Data and Services>Datasources, I
tried to add a FM Pro doc as a data source but found no way to navigate to a
local file, so I clicked on the edit button for an existing data source and
copied the entire line of what at least partially looked like a path:


jdbc:pointbase:cf7experience,database.home=/Applications/ColdFusionMX7/wwwroot/C
FIDE/gettingstarted/extranet/db

I then returned to the Data & Services>Datasources page and pasted it into
Data Souce Name and clicked the Add button. Now when I click on the Verify All
Connections button, I'm getting errors for all of them. Two say:

Connection verification failed for data source: cfartgallery_pb
java.sql.SQLException: null
The root cause was that: java.sql.SQLException

Two others say:

Connection verification failed for data source: cfcodeexplorer
java.sql.SQLException: Attempted to open a database named "CFCODEEXPLORER"
when another database named "CF7EXPERIENCE" is already open.
The root cause was that: java.sql.SQLException: Attempted to open a database
named "CFCODEEXPLORER" when another database named "CF7EXPERIENCE" is already
open.

I am completely lost. Does anyone know how to remove what I just added to get
things back to normal? And would anyone be kind enough to tell me if I can
simply use and existing FM Pro document as a database for a locally running CF
test server? Is there an easy way to connect to a data source using the
existing drivers, or do I need to install something?

As you might imagine, I'm in the early stages of building a Web application
and just want something to test if I'm writing my CF code properly so it'll
interact with a database. Many thanks to anyone who might be able to help. By
the way, I did get the CF testing server working with the Mac's built in Apache
server, but now trying to get a database going, since that'll be a big part of
my application.

Many thanks