Topic awaiting preservation: Connecting ColdFusion with Microsoft SQL Server 2005

I am using ColdFusion MX 6.1 and Microsoft SQL Server 2005 on a Windows XP machine. the problem comes when i try to register my database in the ColdFusion admin section. i get this error message:

Connection verification failed for data source: Hustluz
[]java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "Hustluz" requested by the login. The login failed.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "Hustluz" requested by the login. The login failed.

does anybody have any suggestions it would be apprecaited...thanx

have you tried connecting to the db with something else like "PhpMyAdmin"?

nah i dont know how to use php. i have a cold fusion tutorial which is lynda.com plus its very easy to take hold of. should i be using php is that the top of the line server application software

Can anyone else help me im trying to connect to a mssql database created in mssgl 2005 using php. the code that i am using to connect is:

// Connecting to and selecting a database
$connect = mssql_connect('localhost', $user, $passwd)
or die('Could not connect: ' . mysql_error());
echo '<b>Step 1:</b> Connected successfully! <BR>';

$db = 'localhost';
mysql_select_db($db) or die('Could not select database ('.$db.') because of : '.mysql_error());
echo '<b>Step 2:</b> Connected to ('.$db.') successful!<BR>';

// Now we close the connection...
mysql_close($connect);

The error message that i am getting is:

Fatal error: Call to undefined function mssql_connect() in c:\program_files\wamp\www\learning_php\working_with_databases\connecting_to_data.php on line 8


is there something that im missing. or can someone correct me.

hustluz has open a new thread

Please continue discussion there. Thank you.