Hi all

I have this SQL in Report Manager. Using the old system of ODBC the SQL works w/o complaints. Enter OLE-DB the unmodified report same SQL won't work.

Error Generated:

SPACKINGLISTITEMS:SQL: GROUP BY clause is missing or invalid.

SQL Statement as specified in the Report Manager for SPACKINGLISTITEMS:

SELECT * FROM lv_LKsPackingListInvoice WHERE iPID = :iID

The following is the Database Conection strings passed and interpreted by reportmanager for OLE-DB, if there is some configuration mistakes I may have made:
Passed:

ThisForm.cntreportmanager.oleReportManager.setdatabaseconnectionstring("C04Data", ;
	'Provider=VFPOLEDB.1;Data Source=' + ADDBS(goapp.cPathToDBC) + 'vso3.dbc' + ;
	';Mode=Read;Password="";Collating Sequence=MACHINE')
ThisForm.cntreportmanager.oleReportManager.setdatabaseconnectionstring("C04Views", ;
	'Provider=VFPOLEDB.1;Data Source=' + ADDBS(goapp.cPathToDBC) + 'vso3views.dbc' + ;
	';Mode=Read;Password="";Collating Sequence=MACHINE')

Interpreted:

Provider=VFPOLEDB.1;Data Source=C:\VSO3\PROJECTS\C04\DATA\vso3.dbc;Mode=Read;Password="";Collating Sequence=MACHINE
Provider=VFPOLEDB.1;Data Source=C:\VSO3\PROJECTS\C04\DATA\vso3views.dbc;Mode=Read;Password="";Collating Sequence=MACHINE

These are the originally specified ODBC strings:

Provider=MSDASQL.1;Persist Security Info=False;Data Source=C04 VSO3Data;Mode=Read
Provider=MSDASQL.1;Persist Security Info=False;Data Source=C04 VSO3Views

Please advise