ColdFusion MX / MSSQL

I have CF MX installed and SQL 7. I created the database along with in the Control Panel, I created the ODBC connection to the DB with a DSN name of: myDB Now in CF it will not connect. I have SQL 7 set to TCP/IP in the Client Network Utility. I have no PWD associated since this is used as my DEV box. Any ideas?

What type of drivers are you using? The ODBC Socket Connection should work. If you want to use the Sql Server Driver, you need to have mixed mode authentication on your SQL Server. You need to setup a sql server login, with a username an password. Then use this username and password to connect to the datasource via CFMX. In earlier version you could use window authentication with the sql server driver, but not in MX. And you should try to avoid the ODBC Socket Connection. I have both those services stopped.. Brook At 08:24 PM 30/09/02 -0400, you wrote: ----- Excess quoted text cut - see Original Post for more -----

I am using the local dbo account of "sa" no password. It will not authenicate in CF MX Admin. The drivers are those in CF MX. What type of drivers are you using? The ODBC Socket Connection should work. If you want to use the Sql Server Driver, you need to have mixed mode authentication on your SQL Server. You need to setup a sql server login, with a username an password. Then use this username and password to connect to the datasource via CFMX. In earlier version you could use window authentication with the sql server driver, but not in MX. And you should try to avoid the ODBC Socket Connection. I have both those services stopped.. Brook At 08:24 PM 30/09/02 -0400, you wrote: ----- Excess quoted text cut - see Original Post for more -----

FYI there is a virus going around that targets MSSQL machines with account sa set with no password... More Info here: http://vil.nai.com/vil/content/v_99499.htm At 05:48 PM 9/30/02, you wrote: >I am using the local dbo account of "sa" >no password. > >It will not authenicate in CF MX Admin. >The drivers are those in CF MX. >

On Monday, September 30, 2002, at 05:24 PM, CF-DEV wrote: ----- Excess quoted text cut - see Original Post for more ----- Why use ODBC - CFMX has a built-in JDBC driver that works just fine. Below are 3 different ways that work on CFMX OS X (Linux). HTH Dick

This is the error: Connection verification failed for data source: Mindkeeper_SQL []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. 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. On Monday, September 30, 2002, at 05:24 PM, CF-DEV wrote: ----- Excess quoted text cut - see Original Post for more ----- Why use ODBC - CFMX has a built-in JDBC driver that works just fine. Below are 3 different ways that work on CFMX OS X (Linux). HTH Dick

That says the driver is specified OK & is loaded. The problem is with the URL, UserID or Password. You might want to download ViennaSQL (quick & easy) and play around with your connections with it -- it's easier than with CFMX & when you get it workin, you cancopy paste the results to CFMX Admin. HTH Dick On Monday, September 30, 2002, at 05:56 PM, CF-DEV wrote: ----- Excess quoted text cut - see Original Post for more -----

On Monday, September 30, 2002, at 05:51 PM, Dick Applebaum wrote: ----- Excess quoted text cut - see Original Post for more -----

I am having trouble posting the setups below -- copy pasted

This is weird -- I'll try sending direct Dick On Monday, September 30, 2002, at 06:03 PM, Dick Applebaum wrote: > I am having trouble posting the setups below -- copy pasted

Don't I feel like a total A$$ In the HELP it stated to put LOCAL within the parathesis. Such as: (local) Not True.. It is the standard: localhost Thanks everyone!! This is weird -- I'll try sending direct Dick On Monday, September 30, 2002, at 06:03 PM, Dick Applebaum wrote: > I am having trouble posting the setups below -- copy pasted > > > >