Are you using SQL Server or Windows authentication? I don't think that
it will work with Windows authentication if you're using the native SQL
Server driver - either provide it a valid SQL Server account, or switch
to the ODBC Socket (be sure to check Trusted Connection).
---
Billy Cravens
---
There is no option to check "Trusted Connection".
-Original Message-
From: Cravens, Billy [mailto:[EMAIL PROTECTED]]
Sent: Friday, 14 June 2002 5:49 AM
To: CF-Talk
Subject: RE: CFMX - DSN
Are you using SQL Server or Windows authentication? I don't think that
it will wo
Thanks Billy, it did work out. you are right, need to select ODBC Socket
instead of MS SQL SERVER driver.
nagesh
-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 7:04 PM
To: CF-Talk
Subject: RE: CFMX - DSN
There is no option to check
CFMX - DSN
Thanks Billy, it did work out. you are right, need to select ODBC Socket
instead of MS SQL SERVER driver.
nagesh
-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 7:04 PM
To: CF-Talk
Subject: RE: CFMX - DSN
There is no opti
CFMX will only connect to SQLServer databases setup for SQL Server logins...
What happens if you try to set the DB up through the sa account?
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Monday, March 3, 2003 15:36
To: CF-Talk
Subject: CFMX DSN woes
I cann
> I am using the following settings:
> DSN: cm
> database: cm (this is a database in my
> local instance of SQL Server)
> server: (local)
Try the IP address or FQDN - I don't think JDBC recognizes "(local)".
> port: 1433
> username: system OR cm (system with only windows
> security set, cm with
MAIL PROTECTED]>
Sent: Monday, March 03, 2003 10:38 AM
Subject: RE: CFMX DSN woes
> CFMX will only connect to SQLServer databases setup for SQL Server
logins...
> What happens if you try to set the DB up through the sa account?
>
>
>
> -Original Message-
> Fr
d" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 03, 2003 8:38 AM
Subject: RE: CFMX DSN woes
CFMX will only connect to SQLServer databases setup for SQL Server logins...
What happens if you try to set the DB up through the sa account?
-Origina
>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 03, 2003 8:54 AM
Subject: Re: CFMX DSN woes
Actually, you can use trusted connections (Windows Authentication) with SQL
Server, however CFMX will only connect using the account that it is running
as. We have Domain level service acc
Pete,
There is a patch floating around somewhere for CF's administrator which
gives you more meaningful error messages when connecting to data sources
other than the generic JDBC pool error. Search macromedia.com
For SQL Server:
1) Make sure you are using Mixed Mode Authentication (not Windows o
The diagnostic jar file can be found here:
http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602&Method=Full
- Original Message -
From: "Pete Ruckelshaus" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 03, 2003 7:36 AM
Subject: CFMX DSN woes
> I cannot fo
"CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 04, 2003 10:06 AM
Subject: Re: CFMX DSN woes
> The diagnostic jar file can be found here:
>
> http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602&Method=Full
>
>
>
> - Original Message -
>
12 matches
Mail list logo