Which connection method to use when calling CR from VB6?

[CrystalMeister]

Here is my basic environment:
- using vb6 and SQL Server 2000
- calling/using CR XI created RPT files from VB6 program
- integrating CRAXDRT.DLL into VB code
- tried to create "one size fits all" vb class to handle overwriting RPT files created with and without DSNs (ODBC versus OLEDB connections)
- trying to override the database connection information stored in the RPT with another database and server all through VB6 application
- have something running well using SetLogonInfo function
- also using ConnectionString property to pass SQL connection string to RPT file.
- so far TestConnectivity function says it's connecting cleanly
- have read hundreds of blogs, articles, white papers from many websites til my eyes hurt and turned bloodshot trying to find EXACTLY what I need but can't find it

???? question: will using the crTable.ConnectionString assignment be enough to establish a valid functioning connection to the database?
???? OR do I need to call/use use BOTH the ConnectionString assignment AND SetLogonInfo functions to establish a valid table override and database connection?
???? is there one all-encompassing method of connecting to different databases/SQL servers from VB6 app?

Thanks for the help,
CrystalMeister