It may be many things. You should ask the question into the SQL Server thread. If you can't have the query working into the Query Analyzer, it won't work through an application.
>this thing is wearing me out. i did get a different error this time though:
>
>communication link failure. if i query through SQL server
>
>I get login failed for user 'x' in the Query analyzer.
>
>could my security settings be setup wrong for my local server? it only checks windows authentication. I really don't know too much about changes these settings and adding the proper security settings.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com