RE: SQLPutData against MSSQL view

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,
From your description, I understand that:
You application failed to insert data by using SQLPutData against view
column with MDAC; however you could do that with SQL Native Client.
If I have misunderstood, please let me know.

To find the root cause of this issue, I would like to confirm with you the
following questions:
a) What is the version of your SQL Server?
b) Could you manage to perform the insert operation by specifying the
parameter with SQL_LONGVARCHAR?

I believe that SQL_VARCHAR cannot be used on text/binary/image columns in
MDAC. SQL Native Client can support varchar(max), so it most likely support
using SQL_VARCHAR on text columns. However I have not found any public
documents clearly talking about this. I will consult product team to
confirm this and let you know the result as soon as possible.

If you have any other questions or concerns, please feel free to contact us.

Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

.

Relevant Pages

  • Re: Version of MDAC for SQL 2005?
    ... The minimum version for named instances is 2.71. ... I would recommend the ... latest MDAC 2.8 SP1. ... Check out this blog about SQL Native Client. ...
    (microsoft.public.sqlserver.clients)
  • Re: ADO and SQL2005
    ... Paul wrote: ... The MDAC isn't changed at all. ... They only installed the new SQL Native Client 2005. ... installation which can not handle correctly SQL 2005. ...
    (borland.public.delphi.database.ado)
  • Re: SQLPutData against MSSQL view
    ... however you could do that with SQL Native Client. ... Using SQL Server 2000 when connecting with MDAC, SQL Server 2005 for SQL Native Client. ... I would appreciate if you could contact product team if this is a limitation for SQL Server ODBC. ...
    (microsoft.public.sqlserver.odbc)
  • Re: ADO and SQL2005
    ... The MDAC isn't changed at all. ... They only installed the new SQL Native Client 2005. ... which version requires SQL 2005 but IMO MDAC 2.8 SP1 should do it ...
    (borland.public.delphi.database.ado)
  • RE: Named Queries, Object reference not set to an instance of an objec
    ... this issue might be related to sql native client. ... this work has to be done by contacting Microsoft Product Support ... For a complete list of Microsoft Product Support Services phone numbers, ...
    (microsoft.public.sqlserver.olap)