How do I convert a VB 6 project with a data environment to SQL stored procedures? I am using CR 8.
Brett Please visit my websites!
Brett Please visit my websites!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Stored Procedures in VB/CR
- Thread starter bburnell
- Start date
If I understand the question, I think you want to use the report's database menu option "Convert Database Driver" and select the appropriate driver, like P2SODBC.dll. It should then ask you to select your ODBC Connection. If you get an error message about "no fields" you have to also "set location" to the SP. This is also in the Database menu.
Before conversion, make sure you have the File - Options setting (Database tab) to allow reporting on Stored Procedures before you do this, so that you can see the SP when you log into the database. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
Before conversion, make sure you have the File - Options setting (Database tab) to allow reporting on Stored Procedures before you do this, so that you can see the SP when you log into the database. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
- Thread starter
- #3
Thanks Ken!
Brett Please visit my websites!
Brett Please visit my websites!
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question