IIS virtual directory - what to do?

Why why why do I get the message "an error occured connecting to the server 'servername'. This server does not exist or is unavailable" when trying to connect to a server in IIS. I know the server exists (it's the same computer I'm using) and that is up and running. Also, why do I need to connect, can I use the SQLXML features without a virtual directory? I have no need to access my DB from the Internet.
Thank you,
HelenaHi

Is the SQL account you are using to connect ot SQL Server, actually exist on the SQL server?

Is the SQL server oyu are trying to connect to the default instance or a named instance?

Are you using OLEDB or ODBC connection to SQL from IIS?

Cheers

SG|||Yes, the SQL account exists.

The server I'm trying to connect is a named instance. (But it should be the default as well since i only have one server?)

I have no idea whether I use OLEDB and ODBC connection, how do I know..?

Thank you, Helena

Originally posted by sqlguy7777
Hi

Is the SQL account you are using to connect ot SQL Server, actually exist on the SQL server?

Is the SQL server oyu are trying to connect to the default instance or a named instance?

Are you using OLEDB or ODBC connection to SQL from IIS?

Cheers

SG|||Hi Helena,

If you are using OLEDB ( i.e a DSN-less connection ) you will see the connection string like this in your ASP page :

Connection.Open "PROVIDER=SQLOLEDB;DATA SOURCE=SQLADMIN1;UID=testiis1sql;PWD=password;DATA BASE=ServerMon"

If you had an ODBC ( i.e. a DSN connection ) it would look like this :

"Provider=MSDASQL;DSN=dsnName;UID=MyUserID;PWD=MyPa ssword;"

see also :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/pg_ado_providers_2.asp

See also :

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForODBCDatabases

What does your connection look like?

Cheers

SG.

IIS not installed

Can someone explain mistery behind that message while installing RS?
What if IIS is running? What else to check then?
ThanksOn Jul 1, 8:35 pm, "markgoldin" <markgoldin_2...@.yahoo.com> wrote:
> Can someone explain mistery behind that message while installing RS?
> What if IIS is running? What else to check then?
> Thanks
If you are running Windows Vista, this article might help.
http://support.microsoft.com/kb/934164/
Regards,
Enrique Martinez
Sr. Software Consultant|||No, it's Server 2003.
A thought about that article. Just imagine aliens reading it. Their
impression would have been probably:
Wow, these humans must be smart if they can understand it. Sorry, bad mood.
I think closer to midnight I am going to honor myself with a title
:"Microsoft uncertified installer".
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1183343909.508685.227570@.q69g2000hsb.googlegroups.com...
> On Jul 1, 8:35 pm, "markgoldin" <markgoldin_2...@.yahoo.com> wrote:
>> Can someone explain mistery behind that message while installing RS?
>> What if IIS is running? What else to check then?
>> Thanks
>
> If you are running Windows Vista, this article might help.
> http://support.microsoft.com/kb/934164/
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

IIS issue

I just installed IIS on my windows xp pro machine and when I try to access a
website on the local IIS server, I get the following error message:

"You are not authorized to view this page"

I have enabled "Anonymous access" inside Directory Security option of IIS
and I also granted full NTFS permissions to all users so that the IIS root
directory is readily accessible. However, I am still not able to access any
website that resides on the localhost.

Please help.

Thanks.
JessIs this a SQL Server question?

IIF Statement in Query designer

Hello,

I am trying to use following IIF Statement in Query designer but getting error message saying "Incorrect syntax

near '>')

Can anyone please help, perhaps correct the statement for me?

IIF([Expected Receipt Date] > now(), 1, 0) AS EXPR1

Thank you in advance

-- Praf

the Query Designer uses SQL

Try a Case Statement instead of the IIF statement

example

CASE

WHEN [Expected Receipt Date] > getdate() THEN 1

Else 0

END as EXPR1

|||

Charles is correct; IFF is available in Report Services but is NOT part of the Transact SQL language. If you are going to edit this query from the Query Designer then CASE syntax is a good choice.

( OK, I am confused with this; where am I going wrong with this? )

|||

I tried the case statement,

I error "The Query Designer does not support the CASE SQL construct." but did provide the results.

Also I am building this query in Query designer.

Thanks

|||

Your code seems like a mix between SQL and RS expressions. To use expressions, you must have the = sign in front of the query. This will allow you to build the SQL statement by concatenating strings, using the IIF expression if needed.

Michael

IIF Statement in Query designer

Hello,

I am trying to use following IIF Statement in Query designer but getting error message saying "Incorrect syntax

near '>')

Can anyone please help, perhaps correct the statement for me?

IIF([Expected Receipt Date] > now(), 1, 0) AS EXPR1

Thank you in advance

-- Praf

the Query Designer uses SQL

Try a Case Statement instead of the IIF statement

example

CASE

WHEN [Expected Receipt Date] > getdate() THEN 1

Else 0

END as EXPR1

|||

Charles is correct; IFF is available in Report Services but is NOT part of the Transact SQL language. If you are going to edit this query from the Query Designer then CASE syntax is a good choice.

( OK, I am confused with this; where am I going wrong with this? )

|||

I tried the case statement,

I error "The Query Designer does not support the CASE SQL construct." but did provide the results.

Also I am building this query in Query designer.

Thanks

|||

Your code seems like a mix between SQL and RS expressions. To use expressions, you must have the = sign in front of the query. This will allow you to build the SQL statement by concatenating strings, using the IIF expression if needed.

Michael

iif inside iif

I'd error message on this expression ,

It is written in hidden property of an image

Can you help me to correct it?

thanks all.

=iif(Parameters!Direction.Value = "none", True, iif(Parameters!Direction.Value = "Ascending",True,False )

You are missing a closing ")" and when comparing strings I would use the "equals" method.

Here is what the statement should be:

=iif(Parameters!Direction.Value.equals("none"), True, iif(Parameters!Direction.Value.equals("Ascending"),True,False ))

IIf in SQL

I'm trying to use the function IIf in a view in SQL SERVER 2005, but I get a message "IIf is not recognized as a built-in function".

How can I make it work, or at least see a list of all the built-in functions?

Your DB --> Programmability --> Functions for all built-in functions

|||

You need to use CASE in SQL Server (which is not the same as IIF in Access). You can search (SQL CASE) to find how to use it.