mATOK Posted November 23, 2006 Share Posted November 23, 2006 Is there a way using mssql_connect to specify a default db?Currently I am doing the following:line 42 - $cs = mssql_connect ( 'server\server', 'User', 'Password' ) or die ( 'Can not connect to server' );line 43 - mssql_select_db('dbname',$cs);Because the default db is off line I see 'Warning: mssql_connect(): message: Cannot open user default database. Using master database instead.'andWarning: mssql_select_db(): Unable to select database: dbname in f:\web\intranet\operations\bram\mail\connect.php on line 43 Quote Link to comment Share on other sites More sharing options...
marcus Posted November 24, 2006 Share Posted November 24, 2006 [code]<?php $conn = mssql_connect('MYSQLSERVER', 'sa', 'password'); mssql_select_db('[my data-base]', $conn);?>[/code] Quote Link to comment Share on other sites More sharing options...
mATOK Posted November 24, 2006 Author Share Posted November 24, 2006 how is that different from what I am already doing? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.