This is how I do it, use ADOCONNCTION to connect to the database, then, DATSOURCE to connect to the data source, and then if you use a stored procedure, you have to have that STOREPROC component.
Generally, the username is sa and the password is three sa