ConnectionString: set ANSI NULL on/off

  • Thread starter Thread starter Dumbo DotNet
  • Start date Start date
D

Dumbo DotNet

I want to know if there is a way to specify ANSI NULL
processing ON/OFF, based on a ConnectionString parameter.
This will take care of processing "x = NULL" and "x IS
NULL" kind of SQL expressions appropriately based on the
ON/OFF setting.

I expect to set this like:
ConnectionString="Provider=...; ANSI_NULL=no";
OR
ConnectionString="Provider=...; Extended
Properties="ANSI_NULL=no;"

This is for connecting to Sybase, using Ole DB classes.

TIA
Raj

"Operator... Get me outa here."
 
Back
Top