> I have searched usenet & dev sites to no avail although many have had
> similar problems, reckon its an issue with DSN but not sure.. error
> occurs intermittently (but more often than not) heres the biz:
> ASP querying SQL Server 7.0 via IE5.5
> Provider error '80004005'
> Unspecified error
> when launching asp:
> Set connInc= server.CreateObject("ADODB.Connection")
> connInc.Open "DSN=db_nsso;User ID=userid;Password=passwd"
> rsInc.Open strSQL, connInc
> where strSQL is a working SQL string based upon variables sourced from
> dropdown lists in a previous asp page. The SQL string works fine
> directly on the SQLServer Query yzer.
> I know there are issues if User ID & password are not mentioned but as
> you can see they are, the strSQL is a rather complex one, summarising
> data from several tables using variables .The error only
> intermittently occurs when selecting a specific set of variables. I
> have trawled the data for incongruencies, null values, values that
> could be named variables etc to no avail
> Is it an issue with the DSN>? if so what should i use instead?
> Its a good job I'm bald cause I wouldnt have any hair left by now so
> any help muchas gracias.