MSSQL-PHP-ADODB Issues

  • MSSQL only support FETCH_MODE_ASSOC
  • $rs->EOF cause unlimited loop
  • Only the first select statement in the procedure are returned as query object
  • the rest of query are return as true array
  • You can only fetchRow once
  • text, ntext, image fields can not be local variables
  • index on datetime will not be used if date range is in the query select statement

The following features are not working in the linked server env.

  • @@IDENTITY insert won’t return at all
  • SET ROWCOUNT 500 for insert/update/select
  • Need to use SET XACT_ABORT ON to be able to write to the linked server

Popularity: 6% [?]

Want to work hard and play hard?
 Get Inside Story by E-Mail     Subscribe with Your Favorite Reader

Save To Del.icio.us | Digg This | Stumble It



Your Ad Here