In the process tab click on the Database link, choose the Use original database logon information from the report' option which should be the first option.
Then scroll down to the 'When viewing report' section and select 'Use same database logon as when report is run' and click Update.
This...
I GOT IT!!!!! WOW!!
I finally got it, although I am a few hair strands short from when I started this project, but it is all worth it. Thank you dvannoy for all your patience and help.
It turns out that your code, although well-written, was missing one ever-important line of code...
I was using the wizard to create the report using the datasets I also created using the wizard. Do these items need to be deleted and then run your code again or does it matter?
Do I create a blank report first then add the fields from the dataset via the code you provided? What is the sequence of events? Maybe I'm missing something.
I've added ASPNET to the Administrators Group successfully and I tried your code while filling in my info and I still get the same error:
Logon Failed.
Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
This is very confusing considering the data is already...
I have been trying for weeks to get rid of this error but it just won't seem to go away. I have googled high and low and found nothing. I know it is probably a simple solution to this very common error but it eludes me.
The skinny:
I am just a guy trying to impress his boss by embedding...
The best way to accomplish this is to turn autonumber OFF and place the value in it yourself with something like this:
The first thing you do is create a recordset with just this SQL Statement:
'Select MAX(ID)+1 AS <your id field> FROM <your table>'
put the results in a session:
Session("<name...
Hello jbenson001,
I can't tell exactly when the error occurs however I am familiar with the dataset error because it references it in the error page. There was no such referrence this time. It could be with Crystal Reports although I am willing to explore both possibilities. Please advise.
I have been trying for weeks to get rid of this error but it just won't seem to go away. I have googled high and low and found nothing. I know it is probably a simple solution to this very common error but it eludes me.
The skinny:
I am just a guy trying to impress his boss by embedding...
As a DBA, you can never have enough information and helpful tips regarding data recovery. Thanks NoCoolHandle, I will add this to my growing bank of knowledge.
Striker
Thanks guys,
I realized a little while after that I exported the original data to spreadsheets for some of my co-workers. Then all I had to do was import them back into the Server and perform the update the restore the column. Whew! that was a close one. Visions of the unemployment line...
I fat-fingered an update query to remove null values and forgot to enter the WHERE clause so it updated all of the records. Is there a way to undo this?
Actually this feature was the reason why I chose to migrate to ASP.NET because I thought that it would lend itself to functions of this type. I basically want to be able to discover the network after the user enters their login credentials. Is there any coding convention like WSH or something...
OK, sorry to bother. BTW, I am thinking of SMS Integration into my ASP.NET applications. We are currently upgrading to SMS 2003. Would you care to offer any advice, best practices or suggestions?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.