http://us.php.net/manual/en/function.mssql-select-db.php *_select_db does not return a connection id, it returns true or false. Just change your script like this: $Conn=mssql_connect('192.168.1.20','username','password'); mssql_select_db('My_Database',$Conn); $QueryString="select id, name from my_table"; $Test=mssql_query($QueryString, $Conn); That should work just fine. -- Plutarck Should be working on something... ...but forgot what it was. ""davek"" <[EMAIL PROTECTED]> wrote in message 9ba2po$jnb$[EMAIL PROTECTED]">news:9ba2po$jnb$[EMAIL PROTECTED]... > Does anybody know how to fix this error? "Supplied argument is not a valid > MS SQL-Link resource" I am running: > > NT4 > MSSQL7.0 > IIS4 > PHP 4.0.4pl1 > > I've been running php3 for some time now without any problems but want to > upgrade to 4. This error seems to be occuring at the mssql_query() > function. > > $Conn=mssql_connect('192.168.1.20','username','password'); > $ThisConnect=mssql_select_db('My_Database',$Conn); > $QueryString="select id, name from my_table"; > $Test=mssql_query($QueryString, $ThisConnect); > > Please help! Thanks. > Dave > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]