Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Advanced Query
Ice, if you just want the counts, no verbiage, here's your solution: -- this version returns only members having BOTH active AND inactive posts listed: select M.*,count(PA.*) as ActiveCount, COUNT(PI.*) AS InactiveCount from Members M inner join posts PA on M.memberid=PA.memberid and...- eichen
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Error Handling on SQL DB connection
SQLOLEDB requires "InitialCatalog =" in the connection string; "Database = " is used for an MSDASQL-type connection,- eichen
- Post #20
- Forum: Visual Basic (Classic)
-
SQL server Timeout problem?
I have seen the same errmsg(without the following 5) from a lazy server that won't pick up the phone on the first or second ring. If you are using ADO, before you open the connection you can set the ConnectionTimeout property to an integer value in seconds: mycxn.ConnectionTimeout = 10 Maybe...- eichen
- Post #2
- Forum: Microsoft SQL Server: Programming
