ID: 17563 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Feedback +Status: No Feedback Bug Type: MSSQL related Operating System: WIN2K PHP Version: 4.2.1 New Comment:
No feedback was provided for this bug for over 2 weeks, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". Previous Comments: ------------------------------------------------------------------------ [2002-12-07 01:43:29] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip ------------------------------------------------------------------------ [2002-11-30 20:39:12] [EMAIL PROTECTED] Can you please be very specific about your table and column names. The ODBC driver doesn't handle odd names very well. There's a big difference between: SELECT * FROM froo SELECT * FROM [FR oO] ------------------------------------------------------------------------ [2002-08-25 23:54:30] [EMAIL PROTECTED] Yes, try that first, after recreate the data field, I have no problem afterwards. You can use the mssql.dll if you want~ I use that in all time, I don't like ODBC, ------------------------------------------------------------------------ [2002-08-25 00:51:28] [EMAIL PROTECTED] Hi I Have this problem Too I use an Odbc conennection on Win2000 prof and IIS ver 5 I try to fetch some data from my database by this lines : $query="Select username,name,family,Sex,pic,pic_type ,about from [users]"; ........... ........... $username = odbc_result($result, 1); $name = odbc_result($result, 2); ............ this page is work probebly at first time but after some refreshing I recive "PHP has encountered an Access Violation at XXXXX" only at this page and other .php page is work probebly; I install PHP on my computer in ISAPI mode in my users table "Pic_type" and "about" allow null I rename these fieldes but not effect . you say I remove this field's and add them again ? is it effective? I try it but not sure thank's ------------------------------------------------------------------------ [2002-06-08 20:28:34] [EMAIL PROTECTED] Server Version: MSSQL Server 2000 Operating System: WIN2K Server Database Details: The error field is smallmoney, allow null. Error Solution: I've tried rename it with other field which is also 'smallmoney' and 'allow null', but problem does not solve this way. The only way to solve this problem is to remove that field and create another new field again. Notice: Notice that the field works fine inside the MSSQL server's 'Query Analyzer', no error occur inside MSSQL server itself, but it produce error with the PHP engine. How does the bug act like: This error might not hang the whole php engine in first few times you recieve the message "PHP has encountered an Access Violation at ########", but it will eventually hang when you load that page few more times. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/17563 -- Edit this bug report at http://bugs.php.net/?id=17563&edit=1