Glad to help...I remember getting that dang error and scratching my head for quite a while ;-)
Yup..SQL Server Standard is a great option....the price is lower and it is basically Enterprise minus a a certain number of concurrent connections and some bells and whistles that most apps don't need IMHO!!
Cheers
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: Randy Vaughn
To: SQL
Sent: Monday, April 19, 2004 8:06 AM
Subject: RE: sql problem
You solved my problem ! 1000 Thank you's :-)
-----Original Message-----
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 10:53 AM
To: SQL
Subject: Re: sql problem
I didn't see any mention as to whether you set a username and apssword
in the datasource in CF Admin....if not you will need one if the
datasource is on another machine.
Also...if memory serves, the datasource setup via Windows ODBC has to be
set to use Windows authentication and NOT SQL Server authentication
HTH
Cheers
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: Randy Vaughn
To: SQL
Sent: Monday, April 19, 2004 7:45 AM
Subject: sql problem
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]
