Re: SQLPutData against MSSQL view

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

Hi, Thank you for your response.

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.

Yes, you are right. But binding text column with SQL_LONGVARCHAR caused same problem with SQL Native Client also.

a) What is the version of your SQL Server?
Using SQL Server 2000 when connecting with MDAC, SQL Server 2005 for SQL Native Client.

b) Could you manage to perform the insert operation by specifying the
parameter with SQL_LONGVARCHAR?

Yes, I did the testing and binding the parameter with SQL_LONGVARCHAR is causing the problem.


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.

I could not find the documentation either.
I would appreciate if you could contact product team if this is a limitation for SQL Server ODBC.

Thank you very much for your help,
KM

.

Relevant Pages

  • RE: SQLPutData against MSSQL view
    ... column with MDAC; however you could do that with SQL Native Client. ... If I have misunderstood, please let me know. ... SQL Native Client can support varchar, ...
    (microsoft.public.sqlserver.odbc)
  • 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: 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: Using Access as Data Source for Report Server
    ... With Access trying to connect to SQL Server 2005 you should either use the ... SQL Native Client ODBC driver or make sure to turn on Named Pipes in your ...
    (microsoft.public.access.reports)