Does anyone know how to import a excel spreadsheet from a sharepoint site using Data Connector ?
Rather than a directory or drive path, I would like to use a sharepoint url as my OLEDB data source path. Would anyone have any quidance on this ?
dbo.MySp(@From datetime, @To datetime)
In Analytics, I created a report, added a prompt page, created two “Date and time prompts ” and named them Param_From and Param_To.
In SQL object, I set SQL syntax to “Pass-Through” and use this code
exec dbo.MySp #sq(prompt(‘Param_From’,’date’))#, #sq(prompt(‘Param_To’,’date’))#
it WORKS, but ignored the time portion of the Date and time prompts.
if I changed the code to
exec dbo.MySp #sq(prompt(‘Param_From’,’**datetime**’))#, #sq(prompt(‘Param_To’,’**datetime**’))#
then I get error
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Error converting data type varchar to datetime. (SQLSTATE=22018, SQLERRORCODE=8114)
I can’t even pass validation.
Is there any solution to get OLEDB provider for IBM DB2 from Microsoft like an explicit install for Standard Edition?