I have used the eval of SQL Server Standard with Cold Fusion, and I have used the Eval on SQL Server 7 Desktop running on an NT Workstation 4.0 SP4 I have never run SQL Server on a 9x environment but MS Claims that it will work. Check your protocols and make sure the CF box and the SQL box are using the same thing as their primary connection protocol. If they are the same box try using 127.0.0.1 as the DB server when creating the datasource. If they are on the same box then set both CF and SQL to run as the same user, and when you create the datasource do not assign a username/password. Hope one of these helps. At 04:22 PM 3/25/2000 -0800, you wrote: >Opps, I was distracted by all that encoding stuff and misread your message. >Using the desktop edition is fine, but I've never tried the evaluation >version. I wouldn't be surprised if they had a setting to not allow outside >connections in since it's an evaluation copy. > >Still, you could make sure all your settings are correct and your service is >running anyway. > >Jessica > >-----Original Message----- >From: Jessica Shea >To: 'Kevin Merker '; '[EMAIL PROTECTED] ' >Sent: 3/25/00 4:03 PM >Subject: RE: Does the SQL7 Desktop Server Evaluation Work with ColdFusion? ? > >Works fine for me. You should register the server under you ODBC >setting >the way you would register a full version of SQL. This includes putting >in >the server name, database name, username and password to access the >database-all as part of setting up an ODBC datasource using the SQL >drivers. > > >Also, make sure your desktop edition is running when you try to verify >the >datasource. There should be a little SQL server service manager icon in >you >tool tray-make sure there is a green arrow on the icon-this means it's >running. If it's a red square, double click the icon and click the >start/continue button to start the service. > >Jessica Shea >Lead Developer, Professional Products >Elixis Corp. http://www.elixis.com > >-----Original Message----- >From: Kevin Merker >To: [EMAIL PROTECTED] >Sent: 3/25/00 8:43 AM >Subject: Does the SQL7 Desktop Server Evaluation Work with ColdFusion?? > > >--------------6DDD1771C9E38CD1BD4F1CE3 >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit > >Can you connect SQL7 Desktop Evaluation with ColdFusion Server >Enterprise 4.0.1? Has anyone ever set this up as a development >environment on Win98 OS. I cannot get Coldfusion Sever to recognize / >verify the the ODBC connection to the SQL7 sever. MSDE SQL7 worked fine. >What am I doing wrong? Studio see the ODBC connection to the server. > >PLEASE HELP! > >Kevin Merker > >--------------6DDD1771C9E38CD1BD4F1CE3 >Content-Type: text/html; charset=us-ascii >Content-Transfer-Encoding: 7bit > ><!doctype html public "-//w3c//dtd html 4.0 transitional//en"> >Can you connect SQL7 Desktop Evaluation with ColdFusion Server Enterprise >4.0.1? Has anyone ever set this up as a development environment on Win98 >OS. I cannot get Coldfusion Sever to recognize / verify the the ODBC >connection to the SQL7 sever. MSDE SQL7 worked fine. What am I doing >wrong? Studio see the ODBC connection to the server. > >PLEASE HELP! > >Kevin Merker >--------------6DDD1771C9E38CD1BD4F1CE3-- > >------------------------------------------------------------------------ >------ >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk >or send a message to [EMAIL PROTECTED] with >'unsubscribe' in the body. >------------------------------------------------------------------------ >------ >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk >or send a message to [EMAIL PROTECTED] with >'unsubscribe' in the body. >------------------------------------------------------------------------------ >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
