just FYI ;-)
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: Ray Thompson
To: SQL
Sent: Monday, April 19, 2004 7:57 AM
Subject: RE: SQL
You can only use the Enterprise version of SQL server when SQL is on a
different box than CF. The standard edition of SQL2K will not work in your
configuration.
I tried everything that I could think of to get it to work, but no success.
_____
From: Randy Vaughn [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 10:48 AM
To: SQL
Subject: SQL
I have been trying to connect CF to SQL Server on a different computer. I
have successfully installed and have been running SQL and CFMX on the same
box for over a year. However, I thought it would be good to have SQL on a
seperate box to gain better performance. Here's what I did:
1. Installed SQL on another win 2k server
2. Set up a DSN on the coldfusion server that points to the instance
on the SQL box
3. Tested the connection by pressing the "test connection" button and
everything seemed to work fine.
4. inside CF Admin set up a datasource and received this message:
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username, password,
URL, and other connectivity info.
Does anyone have a clue?
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
