Variants and Catalgs and Connections oh my!

From: Ignacio Vazquez (ivazquezATorioncommunications.com)
Date: 12/24/03


Date: Tue, 23 Dec 2003 21:11:19 -0500

What the heck am I doing wrong here?! It bombs out on assigning
ActiveConnection saying "Arguments are of the wrong type, are out of
acceptable range, or are in conflict with one another".

var
  ConnectionString: String;
  SourceCxn, SourceCatalog: Variant;
begin
   ...
  SourceCxn:=CreateOleObject('ADODB.Connection');
  SourceCxn.Open(ConnectionString);
  SourceCatalog:=CreateOleObject('ADOX.Catalog');
  SourceCatalog.ActiveConnection:=SourceCxn;
   ...
end;

-- 
Cheers,
  Ignacio