hollettster Posted May 27, 2008 Share Posted May 27, 2008 I have setup a system dsn to a mssql 2k5 server on my iis 6 webserver. I can get PHP to connect just fine to the table I am querying. However I am trying to get information from a specific field and I was getting and error saying the Column did not exist. I went to the SQL Server Studio and rean the exact same query and I got the result I was looking for. I am able to get results from several other columns in the table. So in PHP I did a odbc_num_fields call and it only returned 166 columns when there is in fact 179 columns. I have altered my php.ini file to allow text sizes of 2 gigs and I allow for 65k instead of 4k and I have no change. I am unable to get a DSN-less connection to work. It supposedly can't find the server. I have tried everything I can think of. I HOPE someone can help. Thanks in advance. Quote Link to comment https://forums.phpfreaks.com/topic/107508-odbc_num_fields-returns-incorrect-results/ 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.