Hey guys, im trying to write an application to connect to a database on a mssql server using asp.net.  Thus far any code i've seen and tried seems to not recognize the ODBC connections, so i was hoping you guys can offer some suggestions.  For the example lets say the server is mssql9.aaa.com the db name is xyz with a username of welsh_welsh and the password is q with a table named abc in the database.  How exactly would you go about connecting.  The code i've tried so far is below:

<%

"Data Source = mssql9.aaa.com;Initial Catalog = xyz;UserID = welsh_welsh;Password = q;"

%>

The error i get from the sever is

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30035: Syntax error.