Reporting Service Vfpoledb Problem
Feb 27, 2008
We have a vfp free table directory linked to our SQL 2005 server called tele
select * from tele...employee runs in Management studio
we have a test report designed in BIDS that uses this query.
The report runs on the server.
On other machines, loged in as domain admin we get this error:
An error has occurred during report processing.
Query execution failed for data set 'cnj'.
Cannot initialize the data source object of OLE DB provider "VFPOLEDB" for linked server "tele".
the vfpoledb provider is set to allow inprocess...
View 3 Replies
ADVERTISEMENT
May 16, 2008
i have a list report
some values of this are blank or null
i want to avoid that spacing if it is null
like
name:jjj
lastname kkk
firstname
address uuuu
i want it should be
name jjj
lastname kkk
address uuuu
View 3 Replies
View Related
Mar 27, 2006
We are using the whole BI-package from Microsoft - from SQL, DTS-package,Raporting Service and Analyze Service.
It should be very helpful to be able to create a metadata databases where you could find all releations between different objects (tables,views,reports,cubes,DTS-package,Databases.
Just to get answer for: 'where is view xxx used', 'what are Report xxx depending upon'.
While everything exists in different SQL databases it should possible to do.
Has anyone any comments or the same needs ?
View 1 Replies
View Related
Mar 31, 2006
Hello,
In our project, we would like to use the same data source for our analysis service database cubes and for our reporting service reports.
I created the analysis service project first, deployed successfully. When trying to setting up the data source in the report model project, I selected the "create a data source based on another object", and then selected the "create a data source based on an analysis service project". However, there is no analysis service project to select, and no browse button to see where the reporting service is looking for analysis service project either.
I have tried creating a new analysis service project with data source views, cubes, dimensions and all the stuff, but still cannot see the analysis service project in the drop down box to be selected for my reporting model project data source.
As I am fairly new to the reporting service, I'm sure I'm missing something, but couldn't find much information in the help or on the web. Any suggestion would be much appreciated.
Thank you very much,
Annie
View 5 Replies
View Related
Sep 19, 2006
I keep getting the error "Could not fetch a row from OLE DB provider 'VFPOLEDB' when I do a query on a FoxPro Linked Server through SQL 2000. If the query returns 0 rows I don't get an error I just get the structure of the table. But if the query returns rows I get the error. I can replicate this on a test machine but my development machine works fine.
I have checked the SVRNETCN and the CLICONFG apps in SQL Server and they seem to be set the same on both machines. I am using NamedPipes on the server. I tried starting the DTS and that didn't fix the issue.
Would anyone know what I don't have working correctly?
NOTE: I also posted this in the MSDN Newsgroups
View 3 Replies
View Related
Jan 23, 2007
Hi forum
I'm developing a report in SQL Server 2005 Reporting Services based on a query from SQL Server tables joined with Visual FoxPro free tables. I created a Linked Server with Microsoft OLE DB Provider for Visual FoxPro provider, whith VFPOLEDB.1 string provider. Everything runs ok
within a Business Intelligence Development Studio environment, but when I implement my report, at runtime an error occurs it said "Cannot create an instance of OLE DB Provider VFPOLEDB object". I swtched any combination of Linked Server security and Provider security pages without to solve the problem.
Navigating the web today, I read a similar thread posted by stephanielauym
at April 3, 2006 but I`m not clear if she passed the issue or not. In case of yes, I would like to know how she solved it. I'proved among other with "Allow inprocess" but don't.
Please, if Stephany or Cindy (that she answered) or anyone knows how to solve this error, I'll thank very much.
Arturo Carrión
artcarrion@yahoo.com.ar
at Tiempo Hard SA
Mendoza, Argentina
View 3 Replies
View Related
May 14, 2008
Hi all,
I have some problem about reporting service add-in.
After I install reporting service add-in for SharePoint, reporting service menu does not appear in Application Management Tab in SharePoint Central Administration.
I try to uninstall and re-install again, it remain not work.
How can I solve this problem?
Thank you very much.
View 4 Replies
View Related
Aug 29, 2006
It appears that the VFPOLEDB driver tries to convert numeric types in VFP to decimal types in .NET. In this case, it's a Numeric 9,3 in VFP and it's trying to put it into a decimal 8,3 in .NET.
I know that VFP has this funny quirk where if you don't use all of the decimal places after the decimal point, it allows you to use extras in front of the decimal point. In our case, the number is 104895.83 and yes, VFP is happy storing this in a Numeric 9,3 column.
When trying to read this in .NET, you get this message:
System.InvalidOperationException
The provider could not determine the decimal value. blah, blah, blah...
The question then is - is there a work-around? I can find no way to force .NET to use greater precision. About all I can come up with is to catch the exception and return a nice error message asking the user to make the column larger in VFP.
Here's the .NET code, thanks in advance
Mike
string sqlString = "SELECT * FROM " + Path.GetFileName(dbfFullPath);
OleDbConnection oleConn = new OleDbConnection("Provider=VFPOLEDB.1;Data Source=" +
folderName + ";Collating Sequence=MACHINE;");
OleDbCommand oleCmd = new OleDbCommand(sqlString, oleConn);
OleDbDataReader oleReader;
try
{
oleConn.Open();
oleReader = oleCmd.ExecuteReader();
View 3 Replies
View Related
Apr 11, 2008
Hallo
i'm trying to connect a VFP DBC as a linked server on MSSQL2000sp3a, using following parameters:
Product name: VFP
Data source: \networkpath odbc
Provider: VFPOLEDB.1
No security context
I'm trying the same operation both from a W2000sp4 server (+ MDAC 2.8sp1 ?) and a WXPPsp2, against two identical copies of the DBC that resides on two different path (one on the final path and one on a test path).
From WXPPsp2 everything runs ok, from W2000 i'm always getting this error:
Error 7399: OLE/DB Provider 'VFPOLEDB' IUnknown::QueryINterface returned 0x80070005: Access Denied
(already reported in this thread, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1832362&SiteID=1 but it didn't helped me)
The error happens independently from the user the query runs under (basicly AD account, both domain admin and normal user).
MSSQL runs under a domain account which have full permissions (for test purpose) on the directories where DBC reside.
I did no further modifications on the WXP machine in order to have the linked server running, simply it ran smoothly from the beginning.
Clearly the difference rely on the different OS... but what else?
i ran component checker to determine the MDAC version but some components version numbers slightly differs from the expected ones (eg. resulting version is 2.0.1064 versus 2.0.1022 expected in MDAC 2.8) so i suppose to have MDAC2.8 sp1 on the server.
thanks in advance
View 1 Replies
View Related
Jul 8, 2007
Hi Cindy,
After hours (days?) researching this, your name keeps popping up, you must be the GOTO person for VFP. So:
We have a server that runs a VFP application and stores .dbf free tables in a directory shared as F:apps ele.
I am working on an XPPro box running SQL Server Express 2005 using Management Studio Express.
I am logged on as a user with administrator rights for the domain
We would like to be able to query this data and move it to our SQL tables as needed.
Here is what I have:
EXEC sp_addlinkedserver @server = 'tele',
@srvproduct = 'VFP',
@provider = 'VFPOLEDB',
@datasrc = 'F:apps ele',
@provstr = 'VFPOLEDB.1'
GO
SELECT * FROM tele...PROSPECT_DIVU
Here is what I get:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "VFPOLEDB" for linked server "tele" reported an error. Access denied.
Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE DB provider "VFPOLEDB" for linked server "tele".
I have tried:
exec sp_addlinkedsrvlogin
@rmtsrvname = 'tele',
@useself = false,
@locallogin = NULL,
@rmtuser = 'admin',
@rmtpassword = NULL
go
Same result.
I have also tried:
EXEC sp_addlinkedserver
'tele2',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'F:apps ele',
NULL,
'dBase IV'
GO
When I run:
select * from tele2...prospect_divu
I get:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "tele2" returned message "The Microsoft Jet database engine could not find the object 'prospect_divu'. Make sure the object exists and that you spell its name and the path name correctly.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_COLUMNS" for OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "tele2". The provider supports the interface, but returns a failure code when it is used.
What would you suggest?
View 4 Replies
View Related
Sep 4, 2007
Hi,
Can we pass the Database name/Catalog name for the datasouce that will be used for report,
as a report parameter . Is yes can any one help me on how to achieve that .
Thanks in Advance
View 1 Replies
View Related
Mar 28, 2007
Hi,
I am using SQL Server 2005 Reporting Services. I want to make it secure. I am also using WCF services and made them secure using Claim based System.Identity Model.
I want to apply same claim based model to Reporting Services.
How can I do that?
Amit
View 2 Replies
View Related
Sep 3, 2007
Hello sir
I am using SQL Reporting Service in SQL Server 2005
There I am creating a Report from Parameterised Stored Procedure
Its show the report after clicking on Button View
but it not sort a data according to parameter
Please help me out in this
Thanks
Ever Smiling
Ashish
You Have to Loss Many Times to Win Single Time
View 2 Replies
View Related
Nov 23, 2005
let's work together
View 1 Replies
View Related
Feb 8, 2008
How to deploy the newly created report on the Reprt Server
View 3 Replies
View Related
Feb 9, 2006
Hi all,
I am new to reporting services.
I have to call the reporting service(some else did this) from the web application that I have created using VB.NET . Not sure how to do it .. was reading few articles on the web .
Any good atricles out there ?
I have created web reference to http://server/ReportServer/ReportService.asmx in my web app. The report expects one parameter .
Below is the code I was starting to write to call the reporting service
Dim rs As New RSWebReference.ReportingService
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim result As Byte
Dim encoding As String
Dim mimetype As String
Dim parameters(2) As Parametervalue()
For some reason I cannot do ParameterValue() it says undefined. I am using Microsoft .NET Framework 1.1 . do I have to use ASP.net2.0 for using reporting services?
ANy way i can get this working
Thanks in advance.
View 2 Replies
View Related
Apr 17, 2008
I have already Installed SQL Server management studio express edition in my computer. Now I want to install SQL reporting service.
Can anyone please guide me to how to do that.
Thanks
Kalloo
View 1 Replies
View Related
May 14, 2004
Hi all
When I'm installing sql reporting service I get an error that says "ASP.NET is not installed or is not registered with your web server."
I have iis installed, all of .net, and just installed .NET Framework Redist version 1.1
Can anyone tell me what I need to do to register ASP.NET or what I've done wrong.
Thanks for your help
Jerry
View 3 Replies
View Related
Apr 5, 2008
CAN ANYONE HELP ME OUT.
I have Generated a report using Tamil in reporting services in sql server 2005... i can able to generate and preview the report in local system,
But when i deployed in report manager server, the generated report
statement font's overlapping with others, even after alignment..
hope am clear...
pls gve the solution....
View 1 Replies
View Related
Jun 11, 2008
I want to make a table with dataset such as
employee
and in the header of the table i want to put
another table which has another dataset such as
empdata
Could you please help me
View 1 Replies
View Related
Jun 28, 2007
Hello all experts!
I have a problem I would be very happy if someone could help me out with;
I have a windows 2003 server with SQLExpress and Reporting Services.
I have developed a report in visual studio and successfully deployed that report to the server. I can browse http://localhost/reports to access the report and view them (Via terminal server). But when I browse the page from outside I recieve the following error;
"The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version."
If I run from VisualStudio 2005 and try to access the page I get this message;
"The request failed with HTTP status 401"
What is Wrong??
Thanks in advance for any good suggestion.
best regards
Nroblex from sweden
View 3 Replies
View Related
Sep 17, 2007
Hi there
I've created Report Parameter called AssetCode. In quiry for database, I've created like this:
SELECT a.id1, a.deliverydate, a.retirementdate, b.organisationname, c.costcentre,a.id4,mm.hierarchydescription
FROM Asset as a (NOLOCK)
LEFT JOIN makemodel as mm (NOLOCK) ON a.makemodelid = mm.makemodelid
LEFT JOIN OrganisationTree as b (NOLOCK) ON a.physicalLocationOrgID = b.orgid
LEFT JOIN AssetChargeSplit as c (NOLOCK) ON a.assetid = c.assetid
WHERE a.status = '2'
AND a.id1 LIKE @AssetCode
AND (mm.assettype = 1 or mm.assettype = 6)
ORDER BY a.id1 ASC,
c.costcentre DESC
But when you run a report, if you put for instance "NA196" as keyword, it doesn't return the data for "NA1961", "NA19602", "NA1965", etc etc. But if you put in textfield such as "NA196%", it get the data. ?!?! So how do replace this behaviour?
Thanks
View 3 Replies
View Related
Oct 1, 2007
hello there,
i am trying to using SSRS with Excel. in the BI Design(Visual Studio) wehn i preview the report i can see the report.but when i deploy it on the localhost and try to view the report in there.i get this error.please help
An error has occurred during report processing.
Cannot create a connection to data source 'DataSource1'.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection
View 1 Replies
View Related
Feb 25, 2008
Hello, All!
It`s the first time with Reporting Services and would like to know if there
are any performance problems when installed on the same server with a SQL
Server.
I`m a Database Administrator and I have a SQL Server into a DMZ with almost
200GB of data and nowadays the company is demanding a Reporting Service into
a DMZ and we don`t have a dedicated server to use with. Otherwise, we buy a
SQL Server license just for this request don`t worth.
So, we decide to install Reporting Service on this server, but I have no idea
about how much recource is needed to handle it and if this installation could
cause any issues.
Anybody knows how Reporting Service works? Are there any best practices when
installing Reporting Services on a OLTP SQL Server ?
Thanks
Juliano Horta
View 3 Replies
View Related
Aug 19, 2005
Does anyone know if reporting services in sql server 2005 will supportquerying against the native xml datatype?
View 1 Replies
View Related
Jul 20, 2005
I have the following Question:Is it possible to install a Reporting Service at IIS Webserver withoutSQL Server 2000 on the same machine.We have a Enterprise SQL Server at another machine and i don't want toinstall another SQL Server at a IIS.Thank you for all responsesFlecki
View 1 Replies
View Related
Sep 30, 2006
Hi,
I'm new to SQL Reporting Service. Now only I've started studying that. My question is,
I wanna list out my product sales for each month for each keywords. For example, I have 4 products, some 15 keywords (its an ecommerce site. Visitor coming from a particluar keyword and buying some products. Wanna list out sales for each keywords and product for Every month. To know the quarter sales wanna see the sales and product name for particular keyword). I'm having reports for each month sales. like,
Keywords
Product A
Product B
Product C
Product D
Keyword 1
125
24
275
12
Keyword 2
456
245
67
1223
For quarter sales, I want to see the sales and keywords list for each month and for each products in the same report. I don't want to create one another report for each and every product and month. If I want to see the sales and keywords for a particular product I want a report like,For Product 1
Keywords
Month1
Month2
Month3
Month4
Keyword 1
125
24
275
12
Keyword 2
456
245
67
1223
and For Month 1
Keywords
Product A
Product B
Product C
Product D
Keyword 1
125
24
275
12
Keyword 2
456
245
67
1223
Just by using drilldown I want this report. If any other method is possible, please tell me. It's very urgent. Please Help me. I'm very new to SQL Reporting Service. Started studying before 2 days. Thanks.............
View 6 Replies
View Related
Apr 26, 2007
i use VS 2005 to develop.
And my DB is oracle
i use the SQL 2005 report service to crate the report .When i deploy to one server is ok .but when i deploy to another server (the server has install the sql 2005 & Oracle client is 10.1.0). when i try to view the report in this server : there will have some error message
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CmtDataSoucre'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Hope some one can help.
Thanks
Lizzy
View 1 Replies
View Related
Sep 17, 2007
Hello Techies
i have SSRS 2005 report the source data from oracle views i simply select * from the view and display data for a particular entity say empID using filter in the reports which is passed as parameter
the question is whether SSRS will cahe the data and for subsquent request it will take from Cache instead of going back to database even if i change the parameter say empID 1,2,3,
please help me on this
thanks in advance
View 19 Replies
View Related
Dec 3, 2007
Hi Friends,
I have some problem in passing null value parameters in the URL to the Report Server.
Eg.http://localhost/ReportServer?/DTSPhase1/GetSearchResults&locationId=3&distributorId=1002&fromDate=30Oct2007&toDate=29Nov2007&orderTypeId=1&FromOrderValue=100&ToOrderValue=100000&OrderStatusId=1,2,3&TaxAuthority=1000&TaxStampType=1000&orderId=0&PurchaseOrder=null&OrderedBy=9c1a8a1c-f70b-4ef6-b990-3cf166dc4260,37b51693-bfa6-46e6-8c8e-5788774f90f8,c41d9617-7869-4c22-8816-5d2c879f130d,b160077d-8ede-4784-9cd7-6451c36be3ad&DorAdminId=1000,1001,1091,1089&rs:Format=HTML4.0&rs:Command=Render
if the Value of the 'FromOrderValue' parameter in the URL, it is showing the error like " Parameter 'From Order Value' is missing a value ".
So, i tried to hide the parameter 'From Order Value' at the report Server.Then, i got the same above error.
I can't able to assign default value for the parameter 'From Order Value'.
So, i need the solution for passing null values to the URL.
Thanks & Regards,
Rakshi
View 1 Replies
View Related
Jan 14, 2008
Hi,
Currently I'm trying to execute my reports but I'm getting this eror message:
Report Execution error
The report might not be valid or the server could not process the data.
when I click the "Details" buttom it shows me this information:
Para obtener más información acerca de este error, vaya al servidor de informes en el equipo del servidor local o habilite los errores remotos
----------------------------
No se puede crear una conexión al origen de datos 'dataSource1'.
----------------------------
Error al procesar el informe.
But another user can run the reports without any problem.
Can someone helps me with this please.
View 5 Replies
View Related
Aug 1, 2007
Hi All
Can I use Reporting service reports on MSDE severs in local mode without installing reporting service.
View 4 Replies
View Related
Jan 16, 2007
I wanted to add Reports Service to my sql express. I downloaded the SQLEXPR_ADV.EXE and also Edition Toolkit SP1. But can't see the option to install Report service.
Any help please.
Juvan
View 1 Replies
View Related
