jaspereggink Posted November 24, 2005 Share Posted November 24, 2005 Hello, For a corparate intranet I am trying te read information from a MS Access database, using php and the MS SQL Server 2000. PHP works fine, SQL sever works fine and I can connect to that server using my php script. My problem is this: I can't get result from even a simple SELECT query: $query = "SELECT * FROM tablename"; $result = mssql_query ($query); Is this problem because of the Access database? Should it be an SQL Server db? The computer where php is installed, also has the SQL Server tools installed. So that can't be the problem. [a href=\"http://at2.php.net/manual/nl/ref.mssql.php\" target=\"_blank\"]http://at2.php.net/manual/nl/ref.mssql.php[/a] did't give me any solutions. Does anybody have an idea? Thanks, Jasper Quote Link to comment https://forums.phpfreaks.com/topic/2928-error-php-ms-sql/ Share on other sites More sharing options...
jaspereggink Posted November 25, 2005 Author Share Posted November 25, 2005 - problem solved: used odbc() in php Quote Link to comment https://forums.phpfreaks.com/topic/2928-error-php-ms-sql/#findComment-9859 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.