sql connection fails - SQL Server Forums

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

Other Forums

MS Access

sql connection fails

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-05-23 : 09:02:15

Kid writes "I'm having a SQL issue that I can't track down and it's bugging me.
Especially because the query is ridiculously simple.

SELECT
IIf(IsNull(month(Budget_Summary.[Maintenance_Renewal_Date])),0,month(Bud
get_Summary.[Maintenance_Renewal_Date])) AS [MaintenanceMonth],
Sum(Budget_Summary.[EOY_Projected_Total_Spend]) AS
[SumOfEOY_Projected_Total_Spend]
FROM Budget_Summary
GROUP BY month(Budget_Summary.[Maintenance_Renewal_Date])
ORDER BY month(Budget_Summary.[Maintenance_Renewal_Date]);

It's in an ASP script and the script is failing when it goes to open the
db connection. There are two other db connections that successfully
open (and close) before this point so I know the connection part is
good."

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-05-23 : 14:32:36

whats your connection parameters/string
see this www.connectionstrings.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources