SQL Server connection problem

[zingmatter]

There are serveral ways to connect to a SQL Server running locally on a PC. All I want to do is get it to work. In fact, using :

openStr="Driver={SQL Server};Server=servername;UID=username;" & _
"PWD=password;Database=mydatabase;Trusted_Connection=yes;"

all is fine in Internet Explorer, but FireFox throws up a 401.2 permission denied error page, which is really annoying. Is there some way of turning this off in FF, or am I missing something?

Thanks

[chazzy]

what webserver are you using?

[zingmatter]

IIS 5 on windows XP Pro

[chazzy]

iis typically does not work with firefox. you can try searching on google, i have not found a definitive answer for this.

this also has nothing to do w/ it using sql server backend, it's IIS not interpretting firefox'es request headers properly.

[zingmatter]

The odd thing is that I have FireFox running the same locally installed web site and database quite happily on a pc at work with Window 2000 (not sure of the version of IIS here).

At least I know it isn't SQL server. Thanks.