We are currently developing in VFP6 to an SQL server 7 backend. Instead of DSN on the local machines we use and ODBC connection string created on the fly from user log-in information. I'm interested in using the connection handle created from the connection string with Crystal Reports to establish Crystal's connection. Why? Well for one thing then I don't have to start another connection to the server... but more importantly its just easier than having to create DSN's on the local machine.

I've found a reference to a SetLogOnInfo() function that you can use to set the DSN with visual basic. The code was something like
For Each oTable in .oReport.database.Tables
oTable.SetLogOnInfo(.cCurrentDSN)
EndFor
(thread#592449 Message#592660)
Now this makes sense to me... and I was able to reference [Crystal Object Variable].Database.Tables in the VFP debugger but all it says is that its an object. I cannot see the properties within the object (which I assume has a list of table names).

So I tried opening up VB and insterting the Crystal object to see its properties but still no luck. So I'm left wondering how to figure out the function syntax for SetLogOnInfo(). I'm going to just try passing it a DSN string but if anyone has any hints they're greatly appreciated.

So the issues are:
1) How can we use a DSN less connection with Crystal 8 to SQL Server 7
2) Is there any better documentation about how to use the RDC from crystal (like a function reference). Is there a book maybe? I have the crystal help files but there not much help.