Last post Mar 30, 2011 06:26 AM by azermann
Mar 29, 2011 06:28 AM|azermann|LINK
Hi i need some help here i am new at reporting service things when i try to create a report i got this error and idea how to fix it
An error occured during local report processing.
An error has occured during report processing.
Qery execution failed for dataset 'ds_testtablosu'
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MMDB"
Mar 29, 2011 06:49 AM|asheejtk|LINK
It seems you are using linked server.
Try to enable inprocess from your server.
1. Open "SQL Server Management Studio"
2. Go to "Server Objects"-->"Linked Servers"-->"Providers",
3. Right click "MSDASQL" and select the "Properties" .
4. Check the checkbox "Allow inprocess" to enable the same.
Mar 29, 2011 06:58 AM|azermann|LINK
hi and thnx alot fro your quick replay i did as u said but now i got this error
Qery execution failed for dataset 'ds_ortalama'
Mar 29, 2011 07:29 AM|asheejtk|LINK
Request you to go through below URL for detailed explanation,
Mar 30, 2011 06:26 AM|azermann|LINK
i did as u said and cheked that link and did same but when i try to make new linked server i get this error Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MYSQL".
OLE DB provider "MSDASQL" for linked server "MYSQL" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303)