I would suggest you use Technet
http://technet.microsoft.com/en-us/default.aspx
and search for "sql server odbc connection" and then further refine the seach to "SQL 2005".
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]