Re: Large varchar columns with SQL server

I'm trying to track down some bugs that I read about at
http://www.aspfaq.com/show.asp?id=2188. I'm connecting to a SQL
database in ASP. Does anyone know specifically what configurations
(e.g., what versions of MDAC, what types of connections, etc.) cause
these bugs to appear? (I'm most concerned about the bugs that cause no
error to display but return no data from the field.)

No. If there was more information from Microsoft on this, don't you think
there would be now a published KB article?
The fact that 2 MVPs can't lay their hands on this information means it
probably does not exist.
Did you read the KB articles they pointed to:
http://support.microsoft.com/default.aspx/kb/200124
http://support.microsoft.com/default.aspx/kb/175239
???

I can also add that since ADO 2.6, if you do get DB_E_ERRORSOCCURRED on
,modifying a field, you check Field.Status to get feedback on what went
wrong.

For myself, I can immediately mention flaws
(i) deficencies in ADO documentation
(ii) under-documentation of IADORecordBinding to the point where some code
"fails".
(iii) some of the Microsoft VC++ examples are "exception-unsafe" despite the
fact that Microsoft has some decent smartptr's for ADO.
(iv) over complicated VC++ example of ADO event handling. There is more code
present than is necessary to demonstrate event handling.

All of this shows how "unfinished" ADO is, so it is unrealistic to imagine
that there will be large articles documenting every last nuance of your
problem.

Stephen Howe


.

Relevant Pages

  • Re: Large varchar columns with SQL server
    ... I have looked at those articles, but I'm concerned with large varchar ... I can also add that since ADO 2.6, if you do get DB_E_ERRORSOCCURRED on ... deficencies in ADO documentation ... present than is necessary to demonstrate event handling. ...
    (microsoft.public.data.ado)
  • Re: I need advice on disconnected clients
    ... ADO.NET is much lighter than ADO in many respects. ... criteria that need to be enforced on the client. ... any object in the database. ... > Read/Write .NET articles ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Possible DAO and ADO conflicts
    ... I'll take a look at those articles. ... It is on whether to convert DAO to ADO ... >> I have a legacy application which only has DAO references. ...
    (microsoft.public.vb.database)
  • Re: DAO vs ADO
    ... Depending on how you're connecting to SQL Server, yes, it might make sense ... to use ADO. ... I've written applications where my communication to SQL Server was all done ... DAO was designed specifically for use with Jet databases (i.e.: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Problems with carating Stored Procedure from ADO
    ... connecting to SQL Server! ... > May bee ADO find parametrs in Create query.. ...
    (microsoft.public.sqlserver.server)