sql server connect: hello all,
iam trying to connect to a sql server using thsi format

Application("ConnectStr")
= "provider=SQLOLEDB;SERVER=xxxxxx;UID=xx;PWD=xxxxxxxxxx;
DATABASE=xxxxxxxx".

earlier this used to work fine. but offlate i started
getting a error :

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionRead (recv()).]General network error.
Check your network documentation. to avoid this i added

OLEDB Services=-2 to the connection string . i have also
increased the timeout of te pages , command object and
connection but now the following error keep coming

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or access denied.

the problem is that ths error comes anytime while browsing
the site not depending on any specific page.

So any of you can please givea solution for this. it is
urgent

You need to retrieve the actual OS error to troubleshoot this problem.

Reply with the OS error returned while connecting using an ODBC test DSN.
Or test using ISQL.exe from a command prompt.

Example:

ISQL -Stcp:ServerNameHere -Usqluseridhere -Ppasswordhere -Q"select
@@version"
or
ISQL -Stcp:ServerNameHere -E -Q"select @@version"

Search the kb for the OS error returned.
Example:
10060 == Connection Timeout
10061 == Connection Refused. The server is not listening on TCP. This
could be caused if we fail to bind to the port.

General Network errors are usually caused by underlying network problems.
You'll need to make network traces to determine what's wrong.


Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.