Connect to SQL Server

[JRock]

I'm trying to connect to SQL Server, but when I click 'Test' or 'OK' it doesnt
do anything. It doesnt even seem to be trying. Server has SQL Server, CFMX 6.1
Workstation has DWMX 2004 Any suggestions?

[Alexandro Colorado]

On Thu, 24 Mar 2005 23:52:39 +0000 (UTC), JRock <jason@rockenbach.net>
wrote:

> I'm trying to connect to SQL Server, but when I click 'Test' or 'OK' it
> doesnt
> do anything. It doesnt even seem to be trying. Server has SQL Server,
> CFMX 6.1
> Workstation has DWMX 2004 Any suggestions?
>

Does the coldfusion administration panel succesfully display the database
in the pool? Try to make a call from the CFADMIN. This might be an issue
of the database not having the correct user or password.

--
Alexandro Colorado
------------------------------
Support Engineer
InterAKT Online
[url]http://www.interaktonline.com[/url]
Tel: 40(21) 312.5312

[JRock]

Yes, that datasource is setup up correctly.
I usually just hand type my queries, but I saw this video where they setup the connection in dreamweaver and it just inserts the code.

[michaelmuller]

I'm working on an app that creates websites on the fly. Each website has it's
own copy of a standard DB but all run off the same codebase. I'm expecting that
the number of sites will grow into the thousands over time.

Currently I'm able to create the DB on the fly, but making the connection to
it is the issue.

What would be easier:

1. Create an ODBC connection on the fly and connect through usual means, or
2. Connect to the DB directly through other means (dbname, etc)

How would you go about it?

Any advice would be great.