Re: OLEDB error with SQL 2005

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

Radzi (imradzi@xxxxxxxxx) writes:
It still didn't work. Same problem with SQLNCLI or with SQLOLEDB. Still
could not find why this is happening. My workaround for the time being
is to pass all string as empty string instead of setting status flag to
DBSTATUS_ISNULL, and modify my stored-procedure to check if the string
is empty to set the variable to null.

Again, without seeing your code, it's difficult to assist.

All I can say is that I have been able to pass NULL values successfully
to SQL 2005, both with SQL Native Client and SQLOLEDB.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Counting the occurence of a string ...
    ... table of string values that appear in all the urls viewed. ... INSERT statements with sample data. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: I want to parse @ArrayOfDays into @d1 through @d5
    ... @char - current char in string ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: datepart function
    ... Is it possible to use this function to give the format like ... If it is the case the data type will be string and no more ... Look up the function CAST and CONVERT in Books Online. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Re: I need to extract .pdf/.doc/.xls documents from an sql 2000 table.
    ... I have stored an image, as an image datatype, in a SQL Server 2000 ... If you see a file name, that is a string. ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: I need to extract .pdf/.doc/.xls documents from an sql 2000 table.
    ... If you see a file name, that is a string. ... It is a piece of data, and it probably has a meaning, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)