I am unable to download and use EM at this time. MS has taken the trial version of SQL Server down due to the slammer worm. I am just trying to use lower-level coding to connect to my sql db. Using Crystal Tech as my host.

ConnectString = "Provider=SQLOLEDB;UID=myid;PWD=mypwd;" &
"Data Source=server name;Initial Catalog=MyDBName;"

I have a DSN created. Anyone have any ideas how to make this connection with them? Preferrably using DSN name.
Thanks.