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

 

[mmmsonu]

Hi,

Can you help me ?How can i connect to access 2000 database without using local dsn?

Mail me at - mmmundhra@rediffmail.com

 

[wrbodine]

There may be an easier way, but the way I've done it is to go to the Database Menu, and pick "Remove from Report" and remove all tables (you'll have to put the fields back on). Then, pick "Add Database to report" and select your database and one of your tables. When you go to Database:"Set Location" you should now see your connection as a file written as a UNC like so:

tblTableName!\\ServerName\Dir\Database.mdb

Then add your fields back on the report & you should be golden. Let me know if that's not clear enough...