Using Crystal Reports dsr file without using ODBC

[awhitsel]

I have an application written in VB5 that contains two CR9 report files imbedded as designer (.dsr) files.

We have discovered that these CR9 files are linked to the SQL Server database using an ODCB connection.

Is there any way to link the database to these two reports without using an ODBC connection?

Please advise.

Thanks.

 

[vidru]

When you open one of the .dsr's and right click in some white space > Database > 'Set Datasource Location' option. You can then browse to the 'new' datasource (in the bottom half of the window), then click the 'Update' button.

-dave

 

[awhitsel]

So, does that mean if we want to access the SQL Server database without using a DSN, we would need to connect to an ODBC connection??

How do we connect to the SQL Server without using a DSN?

 

[vidru]

Your options to connect to SQL Server with CR 9 are ODBC and OLEDB. It sound like you want to switch to OLEDB. You can either send ADO recordsets to the reports at runtime, or specify the server/db at runtime. I've got a FAQ that details the latter, here: faq768-5374

-dave