This topic is locked

-2147467259 Once again why?

10/13/2006 11:48:59 AM
ASPRunnerPro General questions
D
dunga author

guys, hi, here what I have:
this is my connection string:

<%

strConnection = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=G:\HR & Corporate Services\Education & Quality Management\Education\Registration\Sept_06_to_June_07.mdb;UID=;PWD="

%>


here is the error:

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xe70 Thread 0xf08 DBC 0x15f50e4 Jet'.


URL /training/db/registration/Sept_2006_to_June_2007_list.asp
I do not understand:
why error points to a database inside my wwwroot folder whereas in the connection string it is clearly stated that it has to look for the database inside a remote folder.???
things that are ok:

  1. index.htm is accessible
  2. login is OK (which surprises me)
  3. list of the tables in the database is shown
    but once clicked error appears:
    on the webserver I have and application as well has ALL FULL control options.
    if I had used server.map instead EVERYTHING ESLSE works fine.
    but it does not surve the purpose!!!!!

    the same database is accessible from many people on the network and that how is has to be...
    please help what I am doing wrong
    thak you

Alexey admin 10/16/2006

Hi,
to get your pages working you need to do the following:

  1. Ensure that this file exists on the server:

    G:\HR & Corporate Services\Education & Quality Management\Education\Registration\Sept_06_to_June_07.mdb

    If not copy your database there or modify your connection string to point to the actual database file on the server.
  2. Grant IUSR_... user at your server read & write permissions on the database file and on the folder where it resides.

    Or give the read and write permissions to Everyone.

D
dunga author 10/20/2006

hi, Alexey
we have done it all:
added IUSR

checked database(name, location, permissions)

checked permissions on folders where it is located:

same issue
no problems though when the database is located inside the ACTUAL webserver.
what can you do to help?

Alexey admin 10/23/2006

Not sure what do you mean by:

no problems though when the database is located inside the ACTUAL webserver.

Please clarify.
If your G: drive is a network one make sure IUSR_... user has permissions on this drive and network share.

Sergey Kornilov admin 10/23/2006

A bit more detailed tutorial on this issue:

http://www.xlinesoft.com/articles/remote_asc_db.htm
Hope this helps.

D
dunga author 10/27/2006

hi, I would like to add that, there is NO problem with the ASP runner while the DB is hosted INSIDE the server in question usinge a copy of the database
THE problem is when the file is networled elsewhere(ALL permissions set to the correct ones)
Please someone, HELp me finally to realize this issue. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=12235&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

C
chris 10/28/2006

hi, I would like to add that, there is NO problem with the ASP runner while the DB is hosted INSIDE the server in question usinge a copy of the database

THE problem is when the file is networled elsewhere(ALL permissions set to the correct ones)
Please someone, HELp me finally to realize this issue. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=12238&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />



Are you building the asp pages using G:... or \\...?

That may be your problem, you need to use the correct path to build the asp pages. Make sure you can use asp runner while connecting to that db where it is permanently located.

Hope that helps.

Chris.

D
dunga author 11/1/2006

hi, chris,
I can connect to the database using G:
waht do you mean by \\ ??

C
chris 11/1/2006

hi, chris,

I can connect to the database using G:
waht do you mean by \\ ??


Use UNC naming, like \\computer\directory\...
Does that help?

Chris.

D
dunga author 11/1/2006

nope <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=12431&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
I am trying to do whatever I can...to no avail...
also new version has this bug
Microsoft VBScript runtime (0x800A01AD)

ActiveX component can't create object: 'Scripting.Dictionary'
I can run any other ASP pages except generated from ASPrunner pro 4.1

Sergey Kornilov admin 11/1/2006

Dunga,
you have to tell what exactly you doing, step by step.
Did you see the article that explains how to connect to the database located on the network drive?
PS.

ActiveX component can't create object: 'Scripting.Dictionary' error message means a problem with web server configuration.
Check the following article for more info:

http://windowsxp.mvps.org/scrrun.htm

D
dunga author 11/3/2006

ok step by step:)

  1. created database
  2. connected to it using common procedure
  3. used SERVERMAP
  4. used ASP runner pro to generate application
  5. copied(!!!!) entire folder into the Inetpub
  6. right clicked to change permissions
  7. went to administrative tools and set all required permissions there as well
  8. in addition set permisions toa mdb itself (full control)
  9. typed localhost/test (it is there where my application generated by ASP runner is located)
  10. got THIS
    name_of_thedatabase Advanced search Export results Printer-friendly version
    Please wait ...
    Microsoft VBScript runtime error '800a01ad'
    ActiveX component can't create object: 'Scripting.Dictionary'
    /test/name_of_thedatabase_list.asp, line 470
    TO MY SURPRISE!!!!!
    if you click on Advanced search Export results Printer-friendly version

    they work, BUT the database is not being accessed.
    lastly, I have visited the link porvided and installed necessary scripting etc,

    after which the IIS STOPPED functioning at all.
    So right now, entire machine was reloaded with brand new windows sytem, nothing extra, asprunner and IIS
    SAME issue.
    PREVIOUSLY EVERYTHING ELSE worked
    Please continue helping eith this issue

Sergey Kornilov admin 11/4/2006

You need to ask for help in IIS related newsgroups or contact Microsoft Support.
If 'Scripting.Dictionary' object cannot be created ASP pages generated by ASPRunnerPro won't work.
Btw, what version of Windows you run?

D
dunga author 11/5/2006

hi, I am running windows XP pro service pack 2
t is the first time I have encountered this problem... it might be a problem with IIS...

D
dunga author 11/7/2006

guys, I think you should really REconsider RECHECKING your hard core codes.
for example version 4.0 works perfectly.
but 4.1 has "error rows"
has this issue mentioned above
for admin users:

  1. I have even reformatted the HDD with NO other software other than windowx xp sr2 and asprunner <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=12616&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

Alexey admin 11/8/2006

Hi,
you can zip and send to support@xlinesoft.com a full set of generated files along with your database creation script or database itself and I'll help you to get your project working.
Also please give me a more detailed description of the error you get.