Thanks. It may be several days, weeks even, before I get a chance to try
again. I had posted to this list when I was trying to get it working and got
very few responses, none that solved the problem.
I had SQL set up for mixed mode authentication. I tried windows
authentication, sql authentication (which you say does not work). Of course
the MM error message is fairly useless in trying to solve the problem.
I will save your email and will get back with you privately when I have the
time to try this again. I can always use another brain to fill in for the
holes in my own cerebral matter.
_____
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 11:32 AM
To: SQL
Subject: Re: SQL
OK...now I'm confused....how many folks out there can't get this
working....somebody said I solved their problem???
Ray if you still can't get it going let me know
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 8:15 AM
Subject: RE: SQL
No, not 100%. But I tried everything that I could think of to make it
work,
including the same settings that I used when running the enterprise trial.
But sometimes I am not the brightest bulb.
_____
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 11:08 AM
To: SQL
Subject: Re: SQL
Are you sure about that Ray?? I'm about 99% certain that our current
project runs off SQL Standard on a Windows box and CF MX 6.1 on a Linux
box
(but the ISP configured it...not me).
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]
