Re: Connection to SQL Server works in VB.NET, not ASP.NET

From: Roy Lawson (roy_at_xeon.tv)
Date: 02/26/04 

Date: 26 Feb 2004 08:38:37 -0800

Suresh <anonymous@discussions.microsoft.com> wrote in message news:<4DAF5136-06C2-4C19-8F54-DC294646095E@microsoft.com>...

> Try changing your connection string to,
> server=DATA.MYWEBSITE.COM;uid=USER;password=PW; database=DATABASE

Hi Suresh, thanks for the security tips. That change to the
connection string did not work. My error is:
System.InvalidCastException: Specified cast is not valid. It occurs
as soon as I open the connection.

Still puzzled :-)

-Roy

Relevant Pages

  • SQL connection string security (Summary, I think)
    ... Security through obscurity is a horrible concept, and you are correct that eventually someone will find it. ... And again, noting the most common bugs/exploits in web-servers tend to be file disclosure problems, my basic premise remains intact, keep the connection string out of the file-system. ... I'm telling you from experience that if you use standard SQL Server security ... > Now, the "shell game" thing. ...
    (Focus-Microsoft)
  • RE: SQL connection string security (Summary, I think)
    ... Integrated authentication to SQL server is much better. ... So that rules out doing security that way. ... keep the connection string out of the file-system. ...
    (Focus-Microsoft)
  • Re: [SQL connection string security]
    ... time to put some real thought into increasing the security of an application. ... the method of obfuscation. ... connection strings in the metabase is also a documented Microsoft suggestion ... application settings (commonly the connection string is among them) in the ...
    (Focus-Microsoft)
  • Re: BDC Application Setup problem
    ... Security to be present in your connection string. ... your own login name and password, you should specify the authentication ... login and password rather than SSPI. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: How do I include a file
    ... web site really secure. ... download the asp and dll files and the database (more difficult ... >> I suspect that all the talk about securing the connection string is aimed at ... >> This whole security thing is a bit of a maze. ...
    (microsoft.public.dotnet.languages.csharp)