RDC VB 6 Best Practice

[dtrumbower]

What is considered best practice for connecting reports with VB6 and SQL Server ?

Currently the reports are delveloped with ole db and connections in the vb app use ole db. The reports use stored procs for data source.

Thanks
Dwight

 

[synapsevampire]

Since MS no longer supports ODBC, you're well served to go with their new standard, OLE DB.

Stored Procedures are also a great thing as they give you the best performance, and if anything changes in the underlying data structures you won't have to touch the report, just modify the SP.

The only addition I might make is that you base the SP's on Views rather than Tables, again this is to ease maintenance if the underlying structures change.

-k

 

[SurfingGecko]

Remember though if you do modify the actual SP, you will need to open the report in the designer and do a 'Verify Database' to ensure the reports field indexes are in-sync. The database should report back with "database is up-to-date"



Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com