Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Components
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Classic ASP Components Discussions specific to components in ASP 3.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Components section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old July 19th, 2004, 01:39 AM
Authorized User
 
Join Date: Jul 2004
Location: , , .
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to vinodkalpaka Send a message via Yahoo to vinodkalpaka
Default error in snapshot generating code (asp)

hi all,

i have a problem with devoloping an asp program ,that is dynamically generating snapshot files (in .snp format)from

a MS-access database.
database name is datafile.mdb.
Report name is "reportTarge".
please find below the asp code for this.


<%
    Dim objAccess
    Set objAccess = Server.CreateObject("Access.Application")
        objAccess.OpenCurrentDatabase request("APPL_PHYSICAL_PATH") & "databasename.mdb"
    objAccess.DoCmd.OutputTo 3, "reportName", "Snapshot Format (*.snp)", "snapshotname.snp", 0
    objAccess.DoCmd.Quit 2
%>



But while executing this asp code ,i am getting the following error in my IE browser.

Error Type:
Server object, ASP 0178 (0x80070005)
The call to Server.CreateObject failed while checking permissions. Access is denied to this object.


What is the reason of this error (while creating instance of the access)?.
Is there any problem with my IIS server setting ?If there, how to solve it?

Please help me?
Thanking in advance.

From Vinod




  #2 (permalink)  
Old July 19th, 2004, 02:52 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Hello,

This may be your solution: http://p2p.wrox.com/topic.asp?TOPIC_...Terms=dcomcnfg

Brian
  #3 (permalink)  
Old July 20th, 2004, 01:14 AM
Authorized User
 
Join Date: Jul 2004
Location: , , .
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to vinodkalpaka Send a message via Yahoo to vinodkalpaka
Default

dear,

Thanks for you suggestions.That error is not appearing now ,but appering another error,

error '800a1eba'

if i trap the error with asp code

it shows the message

Microsoft Access can't open the database because it is missing, or opened exclusively by another user.

but this database is not opened elsewhere.
Is this the correct code for dynamically creating snapshots from asp.
If no ,please give help me.

Thank you

from,
Vinod

 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error 429 while generating excel report ganesan.k Access VBA 0 April 16th, 2007 02:29 AM
Error generating the jasperReport krishnatlk J2EE 0 April 27th, 2005 05:44 AM
error in snapshot generating code (asp) vinodkalpaka Pro VB 6 0 July 19th, 2004 01:19 AM
Subform generating error Mitch Access 3 April 12th, 2004 09:37 AM
Generating Letters from an ASP application Darkforces Classic ASP Databases 1 September 23rd, 2003 04:13 PM



All times are GMT -4. The time now is 05:07 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.