MSSQL QUESTION, please help

I am switching from crystaltech(excellect hoster) because they don't provide the bandwidth I need for my site reggaeflavaDOTcom. they used access databases.
With my new hoster, matrixreseller, I uses MSSQL.

My question is "How do I query a MSSQL database?"
I keep getting errors, my website/IP on the new host is 216.157.157.70

To query my access database the code would be"<cfquery name="getArtists" datasource="#dsn#">"

I AM A NOVICE AND WILLING TO LEARN, PLEASE HELP.

 

 

 

 

Top