Jump to content

odbc_num_fields returns incorrect results


Recommended Posts

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.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.