>I am having a very difficult time using the adodb.parameters collection in that I can't seem to properly define or map many different VB data types to the SQL Server stored procedure data types they are passed to (ie. adDate doesn't match properly to DateTime, and adGUID doesn't seem to match properly to UNIQUEIDENTIFIER.) Is there a good reference somewhere out there for this kind of information?

Have you seen this page: http://msdn.microsoft.com/library/officedev/vbaac10/acdatComparisonDataTypes.htm