Crystal Reports Connection Error "Invalid Authorization Specification"
Jan 12, 2010
[Code]...
I am trying to generate crystal reports from visual studio..net 2008 and my database is created using SQL server management studio express 2005. I am getting login errors when using the OLE DB for SQL Server source. In studio express I use SQL server and windows authentication and I have tried leaving the user ID and password blank and putting in my login details but still getting the error. I have enabled multiple connections to the database.
View 1 Replies
ADVERTISEMENT
Sep 15, 2007
I am trying to make an oledb connection to an Access database.
1. I added a component class.It said drag from the toolbox to add components.
2. I dragged over the Oledbconnection and OledbdataAdapter
3. I clicked on new connection string for the oldeb Connection and try to connect to the SHX.mdb datababase in the debug/ bin folder I don't have a username or password for the database and do not want to set one up.( is this possible in .net?)
4.As soon as I try to test the connection, I get the "invalid authorization specification" message. I can't get past this and do not really understand why I am getting this message.I have vb 2005 standard edition, not express edition.The exact same thing happens when I try to set up the data adapter to the shx.mdb database.
I am on XP2 and not logged in with a password or username. Could this be the issue or is there something else I am overlooking.Also, since I am coming from vb6 and ADO is there anyway to just write the code without having to use datasets, adapters and oledb connections to bound controls?
View 6 Replies
Jun 19, 2012
Currently I'm working on a piece of code that involves using the Crystal Reports Viewer to export .RPT files to PDF. My problem is that the code works on literally everything except the website I'm planning to eventually put it on.
When placed on the website it throws back the error "Failed to open the connection." which I believe is connected to the SQL Server connection that's formed in order to read data for the report itself.
The code itself is solid and works when used in a separate console application I built to test it whether said code is run on my local machine or on the server itself. It even runs when I test the website in Visual Studio's virtual host.
I've narrowed it down to being some sort of permissions issue, but I am not knowledgeable enough in the various permissions settings to figure out which ones specifically apply to this situation. It's worth mentioning that other pages on the website are directly connecting to the same database, but they are doing so directly through Linq instead of going through the Crystal Report Viewer.
So does anybody know which settings I need to modify in order to fix the connection error.An added note: One of the other suggestions is to make sure there's an ODBC DNS in place that matches the one being used by the code. I have created such a DNS already.
View 1 Replies
Oct 17, 2009
I use SQL server 2005 express on VS 2008 TS, I can make connection to DB from the server explorer but i cannot make connections from teh Crystal reports OLE DB connection wizard, the drop down box doesnt show my SQL server. How do i fix this?
View 2 Replies
Feb 8, 2012
i have a "Connection.vb" where all my Connection string stored and used by the entire program.i'm new to Crystal Reports.. and i want to changes its connection string based on the connection string i made... im using MS SQL 2008.. SQL Server Native Client 10.0 OLE DB Provider..
and here is my connection string."Provider=SQLNCLI10;Server=....SQLEXPRESS;Database=Blah;Trusted_Connection=yes"
i tried to google it.. but they are using different language, different database, and complex examples.
View 1 Replies
Mar 28, 2010
I have some Crystal Reports connecting to a Sql Server db that I would like to detect whether the connection is trusted or whether I need to supply the log on info (reports are not supplied by me so I can't control the connect method). If I just blindly supply login credentials, it won't connect if it is a trusted connection.The following does not work:
oRpt = oCR.OpenReport("C:MyReport.rpt")
if oRpt.Database.Tables(1).ConnectionProperties.Item("Integrated Security") = True then
'trusted connection[code]....
It gives the following error:Operator '=' is not defined for type 'IConnectionProperty' and type 'Boolean'.
I cannot find how create a construct in vb.net for IConnectionProperty. I can't find any documents from Crystal that explain it.I am using Crystal Reports XI - Developer
View 1 Replies
Dec 15, 2011
I'm trying to use crystal reports in my database that i have made using vb 2010 and access 07, I'm trying to make a new crystal report in vb, have gone add new item, crystal report, etc but when i go to specify the new connection using the Microsoft office 12.0 access database engine )LE DB provider i keep getting a catastrophic failure error 0x8000fff?
View 2 Replies
Nov 5, 2009
I�m converting some Crystal reporting functions from VB 6.0 to VB .Net 2008, have reports up and running, and I�m not quite sure how to approach one aspect. The issue I have is most of the Crystal reports connect to a database and run a stored procedure. The connection properties are set up in the report usually pointing at the development region. At run time I need to be pointing to either development, user acceptance, or production. I know what environment I�m in from a configuration file but don�t know how to go about telling Crystal what environment and stored procedure to point at. In VB 6.0 it was:
CR1.Connect = "DSN=" & A.ReportServer & ";<<Use Integrated Security>>;DSQ=" & A.ReportManhattanDB
Where A.ReportServer and A.ReportManhattanDB contain the connection poperties. The stored procedure is passed via:
[Code]....
View 3 Replies
Jun 29, 2010
I'm using the Crystal Reports Basic for Visual Studio 2008 to print reports. I have just one user that gets periodic errors saying "The handle is invalid". If she tries printing a second time, it works just fine. I've looked over her machine and it looks like it has all the same software as everyone else, and of course it never happens when I'm around. The code I'm using is: frmPrint.LogTag1.PrintToPrinter(1, True, 1, 0) ErrorToString() only returns that one line.
View 1 Replies
Jun 21, 2010
I am working on VB.NET(Visual studio 2008)..I completed developing my application and i need to deploy the application. I tried it and faced problems in some areas like adding crystal reports to the setup and deployment. I created a setup file to my application and everything is fine except crystal reports...its showing the error like; An error occurred in crystalDecisions.Reports, crystalEngine threw exception.
View 2 Replies
Jan 8, 2010
I have created a data source connection to an access db by using the wizard in vs2008. I have then used this as a data source for crystal reports. My user would like to put the database on a network and reference it there. Is there a way to set a new path for this data source during runtime?
View 4 Replies
Jun 15, 2011
i upgrade my project to vb.net by using visual basic. i get a error when run the crystal report.
[Code]...
my connection is Public Function ReportConnection(ByRef CrystalReport1 As Object, ByRef dsnname As String) As Boolean
[Code]...
View 1 Replies
Mar 15, 2012
I have this code in my form (in load event) wherein there is a crystal report viewer: there is a "A number is required here" error in [Code]. how can I solve this error?
View 3 Replies
Oct 15, 2009
I'm running through this tutorial found here: report_from_multiple_tables.htmwhich teaches how to pass a parameter text field on a vb form to an embedded Crystal Report in visual studio. I've followed it all the way through however when I attempt to build, I received the error:
Name 'CrystalReportViewer1' is not
declared.
[code].....
View 2 Replies
Nov 20, 2010
vb2005 crystal reports : Name 'CrystalReportViewer1' is not declared error
View 6 Replies
Apr 14, 2009
tell me wat is the difference between crystal reports created in vb and in vb.net??how to create crystal reports in vb??
View 1 Replies
May 4, 2012
I have one PC whereby the OS has been installed on E: and it has no C: drive. Onto this I have installed my .Net 4.0 WPF Application which runs fine.
However, when I try to access a crystal report it gives the exception below. This user is able to access the report from its network location in windows explorer so I assume the act of asking Crystal to copy it locally is causing a problem?
Therefore, can anyone advise where the local copy will be created and/or how I can control this.
[Code]....
View 1 Replies
Apr 10, 2012
How do I open my Crystal Report in VB code (RPT files) on password-protected Access 2007 database? Ever since I protected my database with password, my Crystal Report generates an error.
View 3 Replies
Nov 26, 2009
I am refactoring an old program to use VS2008 (instead of VS2005) and the 2003 Crystal Reports merge modules no longer work on the client machine. I am using the CR version bundled with VS2008. Neither the CR10 merge modules downloaded from the SAP site work, nor the CR x86 msi.
Could not load file or assembly 'CrystalDecisions.Windows.Forms, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.
View 2 Replies
Aug 26, 2011
I am creating reports in Crystal Reports that is integrated within Visual Studio 2008, and I noticed that some of the features are disabled. One is the ability to link tables with a Right Outer Join or Full Outer Join. I also cannot "Show SQL Query" in Crystal Reports. Is this something I can enable or do I have to purchase or upgrade?
View 1 Replies
Feb 3, 2011
Working on a Migarition(VB6 to VB.Net(VS 2005)) application, where some of the reports are loaded in the application. The VB application is using the Crystal reports version 8. While migrating the application, we used the Crystal decisions and tried to load the report. Few of the reports are working fine, few are giving error(like boolean is required here, This field name is not known etc..). For few of the issues we have regenerated the report in CR XI it worked fine and few are giving the performance issue, but few reports are giving the same error as "This field name is not known".
To load the report we followed the steps.
1. Based on the user access level, the report connects to different DSNs.
2. Applies the LogonInfo to the report.
3. Sets the datatable as the datasource to the report
4. View the report.
If we run the application to load the report, it's throwing error as "This field Name is not known. Error in file C:Docs~UserLocal~TempSampleReport{EE6CC25A-D216-496C-AA95-E2F0C61718C6}.rpt:Error in Formula '{ViewReport.field} ="AB'"This field Name is not known".For this I have tried changing the setdatabaselocation in database expert.Still getting the error.The reports giving the error are using a View in it's Query. Is it causing the issue?
View 1 Replies
Feb 2, 2010
We are running Crystal Reports on a Windows Server 2008 with .NET framework 3.5 SP1. I have seen many causes of the general error "The request could not be submitted for background processing." on other forums, however they tend to be persistent and repeatable affecting just a single report due to a specific formatting issue with a specific report.We are seeing this error with the below stack trace, intermittently. It affects multiple different reports we have. It affects one particular report more frequently than other reports. Once a report is affected the same error will often appear in multiple reports at approximately the same time eg. for the next 10 minutes.The same report run with the same parameters may work when run again (soon after) or the application may need restarting before the report can be successfully re run. These reports all worked previously without issue. No change in server or code seems apparent which would have precipitated this error. All code behind for this is VB.NET We have had difficulty reproducing it in test environments and upgrading to the latest version of Crystal has not helped at all.
[code]...
View 3 Replies
Dec 1, 2011
How can we create a report in vb.net without using any crystal reports
View 11 Replies
Jan 19, 2011
I'm developing an app in vb.net (visual studio 2008). I have a Teradata back-end that will be supporting multiple users in a production environment. I need to use variables in the connection string as the user/pass will be changed every 3 months.
For the gist of the application:
In it's most basic form - I have a search form which works correctly - it pulls results into a listbox and the user then double clicks the list box which will then open a form that is bound via table adapter to the back-end table (Teradata). My connection string is fine everywhere in the application. My problem is using a modified connection string for the "fill" function of the table adapter once the form is opened.
I'm using the code below for the on-load event and keep getting an "invalid connection string" - again, the connection string works fine everywhere else in the app, and the variables etc... are working correctly.
Private Sub adaptertest_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim DBConnStr As String = "Provider=TDOLEDB;Data Source=TDDEV;Persist Security
[Code].....
View 5 Replies
Sep 26, 2011
I am preparing crystal reports using vb.net 2008 with ms sql server 2005.everything is showing fine.. except that i want my report to be multiple column... I cant do this using "format multiple column" option because the data is not shown in details section. Actually i need to group the data in data.
e.g: i am preparing a warehouse report to know how much quantity of which products are left, products with 0 (zero) value are not displayed..
I want my reports to be as follows: item1 item_quantity item2 item_quantity item3 item_quantity
View 2 Replies
Jan 26, 2010
I am developing an application using VS 2008/MySql and I am trying to export the crystal report on runtime using my own code. I get an error saying:
Quote:Invalid export DLL or export format.
My code is:[CODE].....
View 8 Replies
Dec 22, 2010
I'm using VS 2008 to develop a solution which will report on data mostly contained in SQL Express databases, across two servers. It will be used by up to about 10 XP clients. I am unfamiliar with the Reports Applications. Will I need to buy extra licenses to use a Crystal Reports application? Why are they both included in VS? What is the basic difference between them?
View 3 Replies
Jul 26, 2009
How can I connect to a Crystal Reports 4.6 report that connects to SQL Server 2005 as a data source, using Visual Basic?I don't want to specify the connection string in the report. I want to pass the connection from VB. Is there any way to do this?
View 1 Replies
Jan 28, 2011
I am working on Windows Forms Projects.I am creating a report for customers.The report data is pulled from a "CustomerDetails" table.A field in the table is called "CustPhotoName", this holds a string which relates to an image file.
I Currently have a report set up which runs for a single customer by passing in a customer ID. Then using the passed in ID to populate a Dataset with an ImageRow and then a sub report with the image from the dataset.
I am wanting to set up this report where I can pass in an array of customer IDs and produce the reports (1 page per customer with image (if CustPhotoName has value))
View 1 Replies
May 14, 2009
I have created reports using Crystal Reports in my asp.net application(vb). It was fine. But when I run it in another system, the report loading fails. So I modified my code like this.
sub Loadreport()
try
Dim sreport as new ReportDocument
sreport.Load(Server.MapPath("ClientList.rpt"))
[code]....
When the control comes to the line:-
sreport.Load(Server.MapPath("ClientList.rpt"))
it jumps to the catch block showing "Invalid Report path". But initially, the code was not showing any error. I haven't changed the path.
View 1 Replies
