Creating a DSN via odbc - But do i need one at all?

[Dan Keeley]

Hi,

I'm writing a vb.net project which uses crystal reports to access the
database ( currently msaccess, but could be changed in the future )

I've found articles in this group, saying dont use odbc, use a dsnless
connection. However can that work with embedded crystal reports? If so how?

If not, then how do i get my setup program to install the dsn? The only code
ive found so far for installing a dsn has been for vb, not vb.net, is it all
done in the same way?

Thanks!
Dan

 

[Bernie Yaeger]

Hi Dan,

I'm not following you completely, but when you open the Access database in
cr, connect to it via ole db (Jet 4.0 Provider). Then call the report
inside vb .net with
CrystalReportViewer1.ReportSource = "c:\apps\sst.rpt"

Where crystalreportviewer1 is simply the cr report viewer - then launch it
and you're in business.

HTH,

Bernie Yaeger