Question about WinNT+IIS+PHP+ODBC Access Driver
| From: | slimfish | Date: | Fri, 27 Aug 1999 09:39:16 +0000 |
| Subject: | Question about WinNT+IIS+PHP+ODBC Access Driver | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-10247@lists.php.net to get a copy of this message | ||
I use PHP 3.0.11 on Windows NT 4.0 + IIS 4.0 + ODBC 3.51.
I post long data to a MEMO fields of the MSAccess database,
when the data is about over 16378, the following message is returned:
Warning: SQL error: [Microsoft][ODBC Microsoft Access 97 Driver] Syntax
error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in d:
\phpwebroot/mzfz/maxins.php3 on line 184
At last, I found that the same error is returned in VB, interdev , etc.
but except MSAccess itself.
In MSDN, the ODBC sdk shows that there are a function SQLPutData to put
long data into database. Is there some odbc_ php functions to do it?
Thanx a lot.