Re: Appendchunk/Update of varbinary column fails on ODBC Linked table?

Tech-Archive recommends: Speed Up your PC by fixing your registry


<ash.sozoh@xxxxxxxxx> wrote in message
news:fcf07548-c57d-4eb6-b5a9-9253c0dea5bd@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a varbinary(max) column in a SQL Server table. I am trying to
populate it through VBA code.
The code fails when the update to this column is done with a large
file and in a linked table environment in MS Access.
The linking is done using an ODBC system DSN. It is interesting that
the code works fine with smaller files.

<snipped code>

So, the question is, is there a limit on varbinary columns supported
through ODBC? If no then how I can fix the error. I will appreciate
the help.

Ash

Take a look at this article: http://support.microsoft.com/kb/194975

One of the suggestions is to use OLE DB instead of ODBC drivers if you
experience problems. Another is to Select individual fields, not "*", and
always Select the BLOB columns last.

AddChunk and GetChunk have always been an adventure with DAO and ADO, with
odd behavior between different configurations the Norm, not the exception.
<g>

-ralph


.

Relevant Pages

  • Re: Manipulating data in .NET
    ... I retrieve the record set from the ODBC provider using a datareader. ... For each jobno that matches my criteria, I extract the part of the string ... to populate the ds that is passed in the web service. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VBA code to import table via query
    ... Create a linked table for the ODBC table. ... about MakeTable queries. ... Microsoft Access MVP ... I need VBA code for MS Access to import a table using an ODBC datasource ...
    (microsoft.public.access.modulesdaovba)
  • Re: Manipulating data in .NET
    ... "Given the constraints of your ODBC drivers, ... I retrieve the record set from the ODBC provider using a datareader. ... For each jobno that matches my criteria, I extract the part of the string ... to populate the ds that is passed in the web service. ...
    (microsoft.public.dotnet.framework.adonet)
  • MS Query in VBA
    ... I have a set of VBA code to create a pivot table using the ... I am using ODBC to connect with MS ... The message said that waiting for the MSQuery to response, ... however, this is waiting forever. ...
    (microsoft.public.excel.programming)
  • Re: Delete Query how to?
    ... name) necessary to updating records using an ODBC connection from Access. ... DELETE DistinctRow [CLERK INVENTORY].* ... but that often solves problems with deleting records. ... cannot figure out how to call it via the ODBC and/or VBA code. ...
    (microsoft.public.access.gettingstarted)