I am having trouble connecting to my local sql server from either the Server
Explorer or vb.net code. The problem is connected to the Norton Internet
Security 2005 Firewall as when I disable Norton everything works and if
Norton is enabled but the PC is not plugged into the network it also works.

When I am connected to the network the Firewall does pop up asking whether
or not I want to allow my vb.net program to access a DNS. I have tried using
localhost, the hardcoded IP of my machine, and my machine name (the usual
method) without any success. It is as if Visual Studio always tries to
resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
Enterprise Manager all work fine at the same time Visual Studio/VB.Net does
not.

Any ideas?

Thanks,

Mark Lewis
(E-Mail Removed)

P.S I am using the latest production/old Visual Studio and SQL Server on XP
with all SP applied.

Resubmitting this with my new MSDN Alias.

Thanks,

Mark Lewis
(E-Mail Removed)
"Mark Lewis" <(E-Mail Removed)> wrote in message
news:u$(E-Mail Removed)...
>I am having trouble connecting to my local sql server from either the
>Server Explorer or vb.net code. The problem is connected to the Norton
>Internet Security 2005 Firewall as when I disable Norton everything works
>and if Norton is enabled but the PC is not plugged into the network it also
>works.
>
> When I am connected to the network the Firewall does pop up asking whether
> or not I want to allow my vb.net program to access a DNS. I have tried
> using localhost, the hardcoded IP of my machine, and my machine name (the
> usual method) without any success. It is as if Visual Studio always tries
> to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
> Enterprise Manager all work fine at the same time Visual Studio/VB.Net
> does not.
>
> Any ideas?
>
> Thanks,
>
> Mark Lewis
> (E-Mail Removed)
>
> P.S I am using the latest production/old Visual Studio and SQL Server on
> XP with all SP applied.
>

here's an idea: configure the Norton product so that your machine can access
DNS.

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"Mark Lewis" <(E-Mail Removed)> wrote in message
news:u$(E-Mail Removed)...
>I am having trouble connecting to my local sql server from either the
>Server Explorer or vb.net code. The problem is connected to the Norton
>Internet Security 2005 Firewall as when I disable Norton everything works
>and if Norton is enabled but the PC is not plugged into the network it also
>works.
>
> When I am connected to the network the Firewall does pop up asking whether
> or not I want to allow my vb.net program to access a DNS. I have tried
> using localhost, the hardcoded IP of my machine, and my machine name (the
> usual method) without any success. It is as if Visual Studio always tries
> to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
> Enterprise Manager all work fine at the same time Visual Studio/VB.Net
> does not.
>
> Any ideas?
>
> Thanks,
>
> Mark Lewis
> (E-Mail Removed)
>
> P.S I am using the latest production/old Visual Studio and SQL Server on
> XP with all SP applied.
>

Resubmitting this with my new MSDN Alias to qualify for support.

Thanks and sorry about the double post,

Mark Lewis
(E-Mail Removed)
"Mark Lewis" <(E-Mail Removed)> wrote in message
news:u$(E-Mail Removed)...
>I am having trouble connecting to my local sql server from either the
>Server Explorer or vb.net code. The problem is connected to the Norton
>Internet Security 2005 Firewall as when I disable Norton everything works
>and if Norton is enabled but the PC is not plugged into the network it also
>works.
>
> When I am connected to the network the Firewall does pop up asking whether
> or not I want to allow my vb.net program to access a DNS. I have tried
> using localhost, the hardcoded IP of my machine, and my machine name (the
> usual method) without any success. It is as if Visual Studio always tries
> to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
> Enterprise Manager all work fine at the same time Visual Studio/VB.Net
> does not.
>
> Any ideas?
>
> Thanks,
>
> Mark Lewis
> (E-Mail Removed)
>
> P.S I am using the latest production/old Visual Studio and SQL Server on
> XP with all SP applied.
>