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: >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? > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
