I just added the SQL connection string to my web.config:

________________________________________
<configuration>

<system.web>
<customErrors mode="Off"/>
compilation debug="true"/>
</system.web>
<appSettings>
<add key="ConnectionString"
value="server=localhost;database=testdb;uid=sa;password=!@#ddi386;"/>
</appSettings>
</configuration>
__________________________________________

Now I am getting a runtime error telling me to turn <customErrors
mode="Off"/>
but I already have that set. The page I am trying to access is in the same
directory my web.config I just post. Can anyone help me out?

Thanks in advance

"localhost" is an alias used by your web server, not by SQL Server. Try
using your machine name, or the local loopback IP address of the machine
(127.0.0.1), or the LAN address of the machine instead.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Everybody picks their nose,
But some people are better at hiding it.

"Bigal" <(E-Mail Removed)> wrote in message
news:846F8CC0-884D-4BC8-9EF7-(E-Mail Removed)...
>I just added the SQL connection string to my web.config:
>
> ________________________________________
> <configuration>
>
> <system.web>
> <customErrors mode="Off"/>
> compilation debug="true"/>
> </system.web>
> <appSettings>
> <add key="ConnectionString"
> value="server=localhost;database=testdb;uid=sa;password=!@#ddi386;"/>
> </appSettings>
> </configuration>
> __________________________________________
>
> Now I am getting a runtime error telling me to turn <customErrors
> mode="Off"/>
> but I already have that set. The page I am trying to access is in the same
> directory my web.config I just post. Can anyone help me out?
>
> Thanks in advance

Thanks for your reply. I changed it to 127.0.0.1 and still same error message

"Kevin Spencer" wrote:

> "localhost" is an alias used by your web server, not by SQL Server. Try
> using your machine name, or the local loopback IP address of the machine
> (127.0.0.1), or the LAN address of the machine instead.
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> ..Net Developer
> Everybody picks their nose,
> But some people are better at hiding it.
>
> "Bigal" <(E-Mail Removed)> wrote in message
> news:846F8CC0-884D-4BC8-9EF7-(E-Mail Removed)...
> >I just added the SQL connection string to my web.config:
> >
> > ________________________________________
> > <configuration>
> >
> > <system.web>
> > <customErrors mode="Off"/>
> > compilation debug="true"/>
> > </system.web>
> > <appSettings>
> > <add key="ConnectionString"
> > value="server=localhost;database=testdb;uid=sa;password=!@#ddi386;"/>
> > </appSettings>
> > </configuration>
> > __________________________________________
> >
> > Now I am getting a runtime error telling me to turn <customErrors
> > mode="Off"/>
> > but I already have that set. The page I am trying to access is in the same
> > directory my web.config I just post. Can anyone help me out?
> >
> > Thanks in advance
>
>
>

Thanks for your reply. I changes the ip to 127.0.0.1 and then the lan ip but
still the same error message.

"Kevin Spencer" wrote:

> "localhost" is an alias used by your web server, not by SQL Server. Try
> using your machine name, or the local loopback IP address of the machine
> (127.0.0.1), or the LAN address of the machine instead.
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> ..Net Developer
> Everybody picks their nose,
> But some people are better at hiding it.
>
> "Bigal" <(E-Mail Removed)> wrote in message
> news:846F8CC0-884D-4BC8-9EF7-(E-Mail Removed)...
> >I just added the SQL connection string to my web.config:
> >
> > ________________________________________
> > <configuration>
> >
> > <system.web>
> > <customErrors mode="Off"/>
> > compilation debug="true"/>
> > </system.web>
> > <appSettings>
> > <add key="ConnectionString"
> > value="server=localhost;database=testdb;uid=sa;password=!@#ddi386;"/>
> > </appSettings>
> > </configuration>
> > __________________________________________
> >
> > Now I am getting a runtime error telling me to turn <customErrors
> > mode="Off"/>
> > but I already have that set. The page I am trying to access is in the same
> > directory my web.config I just post. Can anyone help me out?
> >
> > Thanks in advance
>
>
>

"Bigal" <(E-Mail Removed)> wrote in message
news:846F8CC0-884D-4BC8-9EF7-(E-Mail Removed)...
>I just added the SQL connection string to my web.config:
>
> ________________________________________
> <configuration>
> <system.web>
> <customErrors mode="Off"/>
> compilation debug="true"/>
> </system.web>
> <appSettings>
> <add key="ConnectionString"
> value="server=localhost;database=testdb;uid=sa;password=!@#ddi386;"/>
> </appSettings>
> </configuration>
> __________________________________________
>
> Now I am getting a runtime error telling me to turn <customErrors
> mode="Off"/>
> but I already have that set. The page I am trying to access is in the same
> directory my web.config I just post. Can anyone help me out?


You're missing an "<" on the fourth line. Fourth line in your config should
read:
<compilation debug="true"/>

My guess is that you missed this part as you set customErrors off, the
server is no longer able to read the config and is still going with the
previous config.

--
IT-Rådgiver Ulf Kristiansen
http://www.it-radgiver.no

Well, you're going to have to give us more information about the error.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Everybody picks their nose,
But some people are better at hiding it.

"Bigal" <(E-Mail Removed)> wrote in message
news:0777EE35-965E-4757-97DD-(E-Mail Removed)...
> Thanks for your reply. I changes the ip to 127.0.0.1 and then the lan ip
> but
> still the same error message.
>
> "Kevin Spencer" wrote:
>
>> "localhost" is an alias used by your web server, not by SQL Server. Try
>> using your machine name, or the local loopback IP address of the machine
>> (127.0.0.1), or the LAN address of the machine instead.
>>
>> --
>> HTH,
>>
>> Kevin Spencer
>> Microsoft MVP
>> ..Net Developer
>> Everybody picks their nose,
>> But some people are better at hiding it.
>>
>> "Bigal" <(E-Mail Removed)> wrote in message
>> news:846F8CC0-884D-4BC8-9EF7-(E-Mail Removed)...
>> >I just added the SQL connection string to my web.config:
>> >
>> > ________________________________________
>> > <configuration>
>> >
>> > <system.web>
>> > <customErrors mode="Off"/>
>> > compilation debug="true"/>
>> > </system.web>
>> > <appSettings>
>> > <add key="ConnectionString"
>> > value="server=localhost;database=testdb;uid=sa;password=!@#ddi386;"/>
>> > </appSettings>
>> > </configuration>
>> > __________________________________________
>> >
>> > Now I am getting a runtime error telling me to turn <customErrors
>> > mode="Off"/>
>> > but I already have that set. The page I am trying to access is in the
>> > same
>> > directory my web.config I just post. Can anyone help me out?
>> >
>> > Thanks in advance
>>
>>
>>

Figured it out. The OS was 2003 server and I didnt have sql service pack
installed. That is a requirement for running sql server 2000 on windows 2003

thanks for everyone time.

AL

"Kevin Spencer" wrote:

> Well, you're going to have to give us more information about the error.
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> ..Net Developer
> Everybody picks their nose,
> But some people are better at hiding it.
>
> "Bigal" <(E-Mail Removed)> wrote in message
> news:0777EE35-965E-4757-97DD-(E-Mail Removed)...
> > Thanks for your reply. I changes the ip to 127.0.0.1 and then the lan ip
> > but
> > still the same error message.
> >
> > "Kevin Spencer" wrote:
> >
> >> "localhost" is an alias used by your web server, not by SQL Server. Try
> >> using your machine name, or the local loopback IP address of the machine
> >> (127.0.0.1), or the LAN address of the machine instead.
> >>
> >> --
> >> HTH,
> >>
> >> Kevin Spencer
> >> Microsoft MVP
> >> ..Net Developer
> >> Everybody picks their nose,
> >> But some people are better at hiding it.
> >>
> >> "Bigal" <(E-Mail Removed)> wrote in message
> >> news:846F8CC0-884D-4BC8-9EF7-(E-Mail Removed)...
> >> >I just added the SQL connection string to my web.config:
> >> >
> >> > ________________________________________
> >> > <configuration>
> >> >
> >> > <system.web>
> >> > <customErrors mode="Off"/>
> >> > compilation debug="true"/>
> >> > </system.web>
> >> > <appSettings>
> >> > <add key="ConnectionString"
> >> > value="server=localhost;database=testdb;uid=sa;password=!@#ddi386;"/>
> >> > </appSettings>
> >> > </configuration>
> >> > __________________________________________
> >> >
> >> > Now I am getting a runtime error telling me to turn <customErrors
> >> > mode="Off"/>
> >> > but I already have that set. The page I am trying to access is in the
> >> > same
> >> > directory my web.config I just post. Can anyone help me out?
> >> >
> >> > Thanks in advance
> >>
> >>
> >>
>
>
>