RE: [PHP-WIN] PHPLIB, IIS5.0 , PHP404 --> MSSQL Error
| From: | Svensson, B.A.T. | Date: | Tue, 10 Apr 2001 18:48:25 +0000 |
| Subject: | RE: [PHP-WIN] PHPLIB, IIS5.0 , PHP404 --> MSSQL Error | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-6612@lists.php.net to get a copy of this message | ||
A "General error" can occur when you are trying to connect to
the database. But this seams not be your problem in this case?
I am going for a long shot here:
Is it possible that you have ended up in SQL-state HY000 or HY004?
If you are in HY004, then your data types are incorrect!!!
Is really csm_hosts.subnetz a char/varchar?
If so, what is the maximum length of csm_hosts.subnetz?
E.g. is it true that:
subnetz char(x) or subnetz varchar(x)
implies
x >= datalenght('neues_netz')?
If you are in SQL state HY000, then, hmm... well... good luck! :)
(In principle any ODBC function are allowed to return state HY004,
except for SQLError(), SQLGetDiagField() and SQLGetDiagRec()).
Best regards,
/Anders
>-----Original Message-----
>From: Helmut Himmelstoss [mailto:Helmut.Himmelstoss@t-online.de]
>Sent: Tuesday, April 10, 2001 8:15 PM
>To: php-windows@lists.php.net
>Subject: [PHP-WIN] PHPLIB, IIS5.0 , PHP404 --> MSSQL Error
>
>
>Hello,
>
>after getting the mssql functions to work I ran into a strange
>problem: I can do inserts, deletes, and selects on records in
>my database.
>
>When I call the script:
>------------------------------------------------><-------------
>-------------
>-----------------------------------
><?php
> $db = new DB_Example("UPDATE csm_hosts set
>subnetz='neues_netz' WHERE
>subnetz='test'" );
>?>
>------------------------------------------------><-------------
>-------------
>-----------------------------------
>
>I got:
>------------------------------------------------><-------------
>-------------
>-----------------------------------
>Database error: Invalid SQL: UPDATE csm_hosts set
>subnetz='neues_netz' WHERE
>subnetz='test'
>MSSQL Error: 1 (General Error (The MSSQL interface cannot
>return detailed
>error messages).)
>Session halted.
>------------------------------------------------><-------------
>-------------
>-----------------------------------
>
>My System: Win2000, IIS5.0, php404pl1, phplib-7.2c, SQLServer2000
>
>
>WHY??!?!?!?!?!?
>
>THX
>Helmut
>
>
>
>
>--
>PHP Windows Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
>For additional commands, e-mail: php-windows-help@lists.php.net
>To contact the list administrators, e-mail:
>php-list-admin@lists.php.net
>