Creating System DSN on Vista Box

We are trying to create System DSN on vista using the API
SQLConfigDataSource(...) it give error Access denied.
Can any one help? This is going very critical every hour.
Thanks in anticipation,
Cheers,
Madhav
Try changing the security context to administrator when
creating the DSN.
-Sue
On 16 Feb 2007 02:55:28 -0800, mlimaye@.gmail.com wrote:

>We are trying to create System DSN on vista using the API
>SQLConfigDataSource(...) it give error Access denied.
>Can any one help? This is going very critical every hour.
>Thanks in anticipation,
>Cheers,
>Madhav

Creating System DSN on Vista Box

We are trying to create System DSN on vista using the API
SQLConfigDataSource(...) it give error Access denied.
Can any one help? This is going very critical every hour.
Thanks in anticipation,
Cheers,
MadhavTry changing the security context to administrator when
creating the DSN.
-Sue
On 16 Feb 2007 02:55:28 -0800, mlimaye@.gmail.com wrote:

>We are trying to create System DSN on vista using the API
>SQLConfigDataSource(...) it give error Access denied.
>Can any one help? This is going very critical every hour.
>Thanks in anticipation,
>Cheers,
>Madhav

Creating Custom code with DBNull and Report Parameters

How can I force report parameter to accept a null value. I tried using the check box for null values to no avail. I am creating a custom code to get around this problem. I used the simple IIf statement below:

=IIF (Parameters!MarketID.Value = "None", IsDBNull.Value, Parameters!MarketID.Value)

...I was getting an error message like this:

The value expression for the report parameter ‘MarketID’ contains an error: [BC30455] Argument not specified for parameter 'value' of 'Public Shared Function IsDBNull(value As Object) As Boolean'.

How can I frame the IIf statement?

Thx in advance

You could try replacing IsDBNull.Value with System.DBNull.Value