CR7 to SQL7 connection...

[wrbodine]

I've been using CR to connect to Access databases with no problem, but now I have some reports that need to connect to a SQL 7.0 Database. How can I connect so the connection is valid on the client's machine (not a local dsn)? (with access I used a UNC when I would "Set Location", but I don't know how to do this with SQL...)

TIA,
Ray

 

[Guest_imported]

Are you using crystal reports stand alone, or integrated in an app?

 

[wrbodine]

Its integrated into a VB6 app. I'm not currently working on this, but I think we ended up putting DSN's on the workstations that use the app. It might come in handy to know a better way for the future....

Thanks,
Ray