Home  |  Index  |  Dotnet4all Snippets  |  Submit resources
About  |  Mail us  
Dotnet4all Logo
Creating a DSN via odbc - But do i need one at all? (Thursday, January 06, 2005)
 

Found the following interesting discussion in the Newsgroups:

Creating a DSN via odbc - But do i need one at all?
by: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


 Reply:
by: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



Posted by Xander Zelders



 
Previous Posts
    - Getting ASCII Output From Web (using wget)
    - Treeview highlight node on form load
    - Parsing a flat file to retrieve only a single line...
    - Is there something like this in VB.Net?
    - Outlook interop not available
    - webpages
    - help needed on how to export result to Excel Sprea...
    - MSScript control problem...
    - how to export result into excel???
    - ADO connection with VB.NET

Archives
    - 08/01/2004 - 08/08/2004
    - 08/08/2004 - 08/15/2004
    - 08/15/2004 - 08/22/2004
    - 08/22/2004 - 08/29/2004
    - 08/29/2004 - 09/05/2004
    - 09/05/2004 - 09/12/2004
    - 09/12/2004 - 09/19/2004
    - 09/19/2004 - 09/26/2004
    - 09/26/2004 - 10/03/2004
    - 10/03/2004 - 10/10/2004
    - 01/02/2005 - 01/09/2005
    - 01/09/2005 - 01/16/2005
    - 01/30/2005 - 02/06/2005
    - 01/01/2006 - 01/08/2006


Disclaimer & Terms of Use  | DotNet4All.Com concept & © 2004 - 2007 by  Zelders²  - Holland