Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Error executing database query

Author  Topic 

mattastic
Starting Member

15 Posts

Posted - 2005-02-02 : 04:50:05
Hi, I keep getting the following errors, do you know what causes it? Thanks

SQL server JBDC Driver, error establishing socket. No buffer space available (maximum commections reached):connect

-----

Error Executing Database Query, Timed out trying to establish connection.

jparker
Posting Yak Master

118 Posts

Posted - 2005-02-02 : 05:18:37
The error message that you are seeing typically indicates that either the host name or port is specified incorrectly. Is your SQLServer server really listening on port 1216? By default SQLServer listens on port 1433.
Go to Top of Page

mattastic
Starting Member

15 Posts

Posted - 2005-02-02 : 05:28:23
quote:
Originally posted by jparker

The error message that you are seeing typically indicates that either the host name or port is specified incorrectly. Is your SQLServer server really listening on port 1216? By default SQLServer listens on port 1433.




It's on 1433. Does the www server think it should be something else?
Go to Top of Page

jparker
Posting Yak Master

118 Posts

Posted - 2005-02-02 : 05:31:47
Not unless you have inadvertantly changed it.

The error however does typify that one or the other is wrong. so if you say that the port is correct than looked to make sure that the host is resolved
Go to Top of Page

mattastic
Starting Member

15 Posts

Posted - 2005-02-02 : 05:45:58
All the data sources are using an ip address and port 1433.
Go to Top of Page
   

- Advertisement -