I am using VB 6 on XP and Crystal 8.5. My application has been successfully using an ODBC connection but I now find I need to redesign to connect to an SQL server based database.
I have been reading all the info I can find and it looks to me like I need to create a Field Definition File.
The forum provides some information but has left me wondering. One article stated that if I go to 'Database Fields' on the report select ADD Database then select SQL Table button - then I can create Field Definitions.
I do not get this option. However if I select 'More Data Sources', I get an option 'Active Data (Field Definitions Only).
Is this the correct option?
Are there ant samples available that provide further guidance?
I have been reading all the info I can find and it looks to me like I need to create a Field Definition File.
The forum provides some information but has left me wondering. One article stated that if I go to 'Database Fields' on the report select ADD Database then select SQL Table button - then I can create Field Definitions.
I do not get this option. However if I select 'More Data Sources', I get an option 'Active Data (Field Definitions Only).
Is this the correct option?
Are there ant samples available that provide further guidance?