VB accessing a text field in a table on SQL server 2000

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bruce Gilbert (anonymous_at_discussions.microsoft.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 12:00:18 -0800

I inserting a row in a table on SQL server. Every field
works until I reach the datatype "text" and VB ADO dosen't
even see the field and referencing it causes an OLE DB error.
Does anyone have suggestions.I must use a text field
because it corresponds to a memo which can grow very large.

Relevant Pages

  • Re: ADO and SQL2K5 and Speed
    ... TAdsTable component and a MSSQL2K5 via ADO. ... Which ADO components are you using to access SQL Server? ... TADOCommand and TADOConnection ... How are you inserting the records in SQL Server? ...
    (borland.public.delphi.database.ado)
  • Re: Can I use the SQL "Table" Datatype to pass parameter info from VB?
    ... this datatype. ... could do to pass array safely is to pass it as an XML structure ... > string values from VB (using ADO) to the SQL Server stored procedure. ...
    (microsoft.public.vb.database.ado)
  • Re: Concurrency Issues after a Delete has occurred in Access
    ... With ADO and Sql Server, you can use the "timestamp" datatype that made the field automatically updated whenever the row is touched. ... Concurrency Issues after a Delete has occurred in Access These kind of false concurrency detection is AFAIK most often caused by a delete criteria that returns no rows. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... > using SQL Server for efficiency reasons. ... > connection up programmatically using ADO or ADOX or some SQL Server API? ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... ADO does not have a query engine. ...
    (microsoft.public.data.ado)
  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)