Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LoriM
Starting Member
29 Posts |
 Posted - 2005-04-08 : 12:55:06
|
| Hi,I am new to report server. I've got it installed and I've got it working and deploying using a straight sql server, vb.net connection.What I was wondering is- can I use an odbc or jet db connection to got directly from MS Access tables? I can run a preview in vb.net from the Access tables, but I get the ol'An error has occurred during report processing. (rsProcessingAborted) Get Online HelpCannot create a connection to data source 'dsPersonnel'. (rsErrorOpeningConnection) Get Online HelpCannot start your application. The workgroup information file is missing or opened exclusively by another user. When I deploy it to the browser.Is this a permission issue in RS? Or an Access limitation? I've seen alot of articles that tell one how to IMPORT reports from Access but not how to connect and deploy directly from Access tables. Is this not possible? Thanks for any info... |
|
|
jhermiz
3564 Posts |
Posted - 2005-04-08 : 13:21:32
|
Ive connected to access reports so that is not the issue. Did you recreate the data source for an access database?Here's an example for you:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\jakah-iis-2\IMS\OldIMSBe\IMS_beAuburn.mdbReplace the value of datasource with the path of your .mdb (access file)Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
LoriM
Starting Member
29 Posts |
Posted - 2005-04-08 : 13:26:16
|
| Great, Thanks! I'll try it out! |
|
|
|
LoriM
Starting Member
29 Posts |
Posted - 2005-04-08 : 13:53:19
|
| No Workee. I changed my path to the fully qualified, instead of pointing directly to the share and it still gives me the error in the browser.I (just for testing) have it set to 'credentials are not required', to see what will happen. Same error. I have also tried setting the login to the iusr_machinename user.I'll keep trying. It must be a permissions thing. I'll read up on it.Thanks for your help! |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-04-08 : 14:02:18
|
Yes if your db does not have a user name and password you did the right thing to NOT prompt for a user name and password (credentials not required). So leave that part alone. The problem is now a security permission. Ask your admins (if you do not have admin privelages) to add the ASP.net machine account to your database file. That process needs permissions to access the database. You are very close Lori.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-04-08 : 14:04:19
|
O btw, you need to clear your cache in internet explorer after that error message. For some odd reason, the cache or the page, stays in memory so you may need to clear your internet temps (cache, etc) to ensure the page opens up correctly.I had the same issues you are mentioning ... an error regarding permissions in RS. So play around with the security on that file and you should be able to get it.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
LoriM
Starting Member
29 Posts |
Posted - 2005-04-08 : 14:48:48
|
| Thanks Jon,I finally got it to show up in the browser. I put the Access DB onto the iis server into a Databases folder. I then put that path into the connection string and I was able to see it using the 'no credentials'.So- Let me make sure I understand what to do as far as permissions:1. leave the 'no credentials' on for the connection string, because we don't require a logon for this particular Access db.2. Add the iis machine to SECURITY for the DB? How about if I add it to the Databases folder? Since the DB is on the iis server, why do I have to add it to itself?Also, how do I make it show up for other users on the domain. What object to I click on to set the security settings? Should I add each user to the folder their DB resides in? Or should I get our network Admin to set up special groups?Ok. You can see I'm very confused about this security stuff. Thanks for your help! |
|
|
|
LoriM
Starting Member
29 Posts |
Posted - 2005-04-08 : 15:00:21
|
| I got it!I just added a user to the actual db and they can render the report in a browser. Yahoo!Everything's easy once you know how to do it.Thanks, Jon! |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-04-08 : 16:04:31
|
Bravo!Have a good weekend.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
|
|
|
|
|
MS Access and/or Permissions