RE: CFMX - DSN

2002-06-13 Thread Cravens, Billy
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 ---

RE: CFMX - DSN

2002-06-13 Thread Peter Tilbrook
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

RE: CFMX - DSN

2002-06-14 Thread nagesh
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

RE: CFMX - DSN

2002-06-14 Thread Cravens, Billy
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

RE: CFMX DSN woes

2003-03-03 Thread Mike Townend
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

RE: CFMX DSN woes

2003-03-03 Thread Dave Watts
> 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

Re: CFMX DSN woes

2003-03-03 Thread Pete Ruckelshaus
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

Re: CFMX DSN woes

2003-03-03 Thread Jeff Garza
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

Re: CFMX DSN woes

2003-03-03 Thread Jeff Garza
> 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

RE: CFMX DSN woes

2003-03-03 Thread Andre Mohamed
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

Re: CFMX DSN woes

2003-03-04 Thread David K
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

Re: CFMX DSN woes

2003-03-04 Thread Bryan Stevenson
"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 - >