Password Problems with Microsoft Access databases in Crystal Reports

[Former Member]

Post Author: hd1

CA Forum: Authentication

Hello,

I am hoping someone has a solution to this problem. I cannot access my Access Database from my Crystal Report. I had a posting in another section but haven't gotten a response so I made a new posting in the Authentication section. I can access and edit the report from my local machine using the Crystal Reports editor, however when I save it to the server and run it through the CMC it will not access the report. I keep getting invalid login creditials. I am using an ODBC connection and I even have the server mapped to the network drive that the database tables are on. Why do I need login credentials when the report is unsecurred? I found this article but it doesn't seem to help, I am running Crystal Reports XI.

http://support.businessobjects.com/communitycs/technicalpapers/scr_access_open_session.pdf.asp

[Former Member]

Post Author: hd1

CA Forum: Authentication

Turns out I didn't have to specify a path for the System.MDW after all. I just forgot select "None" for drive so it was still mapping. So all you really need to do is steps 1 through 6. The report is working fine now.

[Former Member]

I do have the same issue. When I run any reports, I get a Error in file ~*.tmp / Unable to connect/ issue.

In all cases, the data source was MS Access DB hosted on a network drive. I tried steps 1 through 6 too and it is perfect. But still I keep getting this error.

Please let me know if there's a way to resolve this.

[former_member617949]

Hi,

I am trying to map the drive after hitting the "Network" button but I do not have an option to select none.

Is there a workaround?

Thanks

[Former Member]

Post Author: hd1

CA Forum: Authentication

I found this on Business objects knowledgebase or something like that. The drives I had were mapped. So I guess I am a little confused on this process, I think I did everything right until I get to step 8. Do you know anything about this?

Cause

During the creation of the System ODBC on the Enterprise XI Server, a mapped network drive was used, rather than a UNC path. Even starting the servers connecting to the database (Page Server, RAS Server, Report Job Server, and List of Values Server) with a domain user account does not solve the issue

To resolve the error messages, reconfigure your ODBC connection as follows:

Open the ODBC Data Source Administrator for your version of Windows.

Click the System tab.

From the list, click the name of your System Data Source that your Crystal report uses, and then click Configure.

Click Select and then click Network.

In the Folder field, browse to or type the UNC path to the Access database.

In the Drive drop down list click None and then click Finish.

Select your database and then click OK.

In the ODBC Microsoft Access Setup dialog box, select the System Database radio button, and then specify the UNC path of the SYSTEM.MDW.

Click Advanced and then type the Login Name and Password.

Confirm the changes in the ODBC Data Source Administrator and then click OK.

Restart the Page, RAS, Report Job or LOV servers.

[Former Member]

Post Author: hd1

CA Forum: Authentication

I found this on Business objects knowledgebase or something like that. I get stuck on step 8. Do you know anything about this?

To resolve the error messages, reconfigure your ODBC connection as follows:

Open the ODBC Data Source Administrator for your version of Windows.

Click the System tab.

From the list, click the name of your System Data Source that your Crystal report uses, and then click Configure.

Click Select and then click Network.

In the Folder field, browse to or type the UNC path to the Access database.

In the Drive drop down list click None and then click Finish.

Select your database and then click OK.

In the ODBC Microsoft Access Setup dialog box, select the System Database radio button, and then specify the UNC path of the SYSTEM.MDW.

Click Advanced and then type the Login Name and Password.

Confirm the changes in the ODBC Data Source Administrator and then click OK.

Restart the Page, RAS, Report Job or LOV servers.

[Former Member]

Post Author: hd1

CA Forum: Authentication

That is exactly the same situation. I should have mentioned that the Access tables are in the sub-reports. Sorry for leaving that out. I did try that but it didn't work. First what I did was I created my new connection to my informix database. That worked fine, I updated it and it took the update. I then tried to add the first Access table to the subreport, but when I clicked finished it said it couldn't connect and it wanted a password. So I checked my ODBC connection in the Adminstrative tools and then I had to connect the server that it was connected too. So I entered my login information and went back into Crystal reports and then I was able to add the Access table. I didn't enter any password information when I added it though. I'm going to try it again and see how it goes. Thanks for you response! I will keep you posted.

Thank you!

Brian

[Former Member]

Post Author: Ranjit

CA Forum: Authentication

I had a simlar problem.

My report in CR 10; was working properly on my development machine however it used to ask me user ID and password for the database and never accepted a single one.

Problem was, I had main report and its sub reports, having database name and user name in different case. application in which Crystal report was displayed was not upper casing this info, and so could never run the report on server. While on my development mchine I used to put correct database and user ID manually.

Solution.

Go to Database=> set Datasource location => create a new and correct connection in the lower box, click on main report connection , then click on new connection, and then click on update. repet same thing with sub report connection. This will correct connection problems if any.

Now save the report with data.

I hope this helps you.

Ranjit