Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
Database Connection Issues
 CJWSoft Support Info : Database Connection Issues
Subject Info: Help please with database A d d  -  P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
jayphilips
New User
New User


Joined: November/18/2008
Location: United States
Online Status: Offline
Info: 6
Added: November/25/2008 at 3:39pm | IP Logged Quote jayphilips

Hi,

I purchased ASP Protect, extracted everything and everything was going okay till I got to the step on opening the "get_me_in.asp" file.  When I navigate to the page I get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/aspprotect/scripts/populate_config_variables_inc.asp, line 11

I verified that the IUSR, ASPNET & IWAM all have R, W, M, E, D rights.

I am using ASP Protect 8, with the access database it came with on Windows 2003.

Can anyone help me with this issue?

Thanks,

Jay

Back to Top View jayphilips's Profile Search for other info by jayphilips
 
cwilliams
Admin Group
Admin Group
Avatar
CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1729
Added: November/25/2008 at 3:51pm | IP Logged Quote cwilliams

unfortunately it's the oldest error in the book when setting up a data connection.. and not specific..  could be a lot of things

usually though it's an incorrect path to the .mdb file or folder permissions..

for starters
use the "test_physical_path.asp" in the extras folder to see if the physical path your using to the .mdb file is valid (you'll need to edit the file with a text editor and put in the physical path your using) then when you run the page it will check to see if the file exists..

If you can't get that page to report back a valid path then there is no sense going any farther until your path to the .mdb file is right

also.. PM me the connection string your using so I can make sure there are no syntax errors there..

__________________

Best Regards, Christopher Williams www.CJWSoft.com
Back to Top View cwilliams's Profile Search for other info by cwilliams Visit cwilliams's Homepage
 
jayphilips
New User
New User


Joined: November/18/2008
Location: United States
Online Status: Offline
Info: 6
Added: November/25/2008 at 4:17pm | IP Logged Quote jayphilips

Hi,

Thank you for the fast response.  I tried the Test_physical_path.asp and it shows:

That path does not exist on the server and is not correct.

The file specified could not be found.

It is also remotely possible that read permissions are not set for the anonymous webserver account where that file resides. However, That is unlikely because read permissions are there by default.

The database is right in the program files in this path:

C:\Program Files\Serena\Collage\aspprotect\data\database\ASPProtect_acc ess2002.mdb

I'll PM you the path that the "setup_info.asp" gave me.

Thanks,

Jay

 

Back to Top View jayphilips's Profile Search for other info by jayphilips
 
cwilliams
Admin Group
Admin Group
Avatar
CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1729
Added: November/25/2008 at 4:26pm | IP Logged Quote cwilliams

C:\Program Files\Serena\Collage\aspprotect\data\database\ASPProtect_acc ess2002.mdb

doesn't seem right to me... a web should never never be located there..


use the path the setup page told you to use.. test that path in the "test_physical_path.asp" file

then if it reports the path is valid make sure the folder the .mdb file is in there has permissions..

I have no idea why you put a copy of of the databse inside the program files directory structure but I know whatever your doing there is out of the norm..

The asp code wants the path to the mdb file on the server.. not anywhere else..



__________________

Best Regards, Christopher Williams www.CJWSoft.com
Back to Top View cwilliams's Profile Search for other info by cwilliams Visit cwilliams's Homepage
 
jayphilips
New User
New User


Joined: November/18/2008
Location: United States
Online Status: Offline
Info: 6
Added: November/25/2008 at 4:36pm | IP Logged Quote jayphilips

Hi,

It's a content management system.  In IIS there is a website for it and it points to the root folder of where the database is.

I switched the "test_physical_path.asp" file to the path the setup file gave me and I get the same error.

Any ideas?

Thanks,

Jay

Back to Top View jayphilips's Profile Search for other info by jayphilips
 
cwilliams
Admin Group
Admin Group
Avatar
CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1729
Added: November/25/2008 at 4:55pm | IP Logged Quote cwilliams


At this point I really have no clue what you have going on with this local server you setup. Everything you have described sounds kinda goofy.

Put it on a real professionally setup server somewhere that I can go into and I will get you going. Otherwise you have to sort it out.

Officially I don't support installations on local servers. Reason being is 9 of of 10 times the person setting up his own local server has something strange like you described going on. Then there are iis setup issues that might not be correct or other programs running on the computer that can cause problems with things like the the filesystem object. (norton antivirus comes to mind and there are others)

Most importantly I can't ftp in, run the site pages, and troubleshoot so how can I possibly figure out what you got going on?  Or can I do those things? If that is all setup I am willing to go look.

__________________

Best Regards, Christopher Williams www.CJWSoft.com
Back to Top View cwilliams's Profile Search for other info by cwilliams Visit cwilliams's Homepage
 
jayphilips
New User
New User


Joined: November/18/2008
Location: United States
Online Status: Offline
Info: 6
Added: November/25/2008 at 5:29pm | IP Logged Quote jayphilips

I got it figured out.  The site is accessible from the outside but since it's a CMS system it has to be setup on a physical path in order to run.

The issue was the file I was changing was not the actual file I was hitting on the website.  Meaning the folder that I had aspprotect in wasn't the corect directory where the virtual server was being pointed to. Our DB guru got back and I asked him and he was able to find that the directories were wrong.

It's all better now.

Thank you though for all your help.

Back to Top View jayphilips's Profile Search for other info by jayphilips
 
cwilliams
Admin Group
Admin Group
Avatar
CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1729
Added: November/25/2008 at 5:30pm | IP Logged Quote cwilliams

I'm glad ya figured it out...

__________________

Best Regards, Christopher Williams www.CJWSoft.com
Back to Top View cwilliams's Profile Search for other info by cwilliams Visit cwilliams's Homepage
 

If you wish to make a comment to this info you must first login
If you are not already registered you must first register

  A d d  -  P o s tAdd P o s t
Printable version Printable version

Info Jump
You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area


Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.powerasp.com,www.aspclassifieds.com,www.aspphotogallery.com,www.codewanker.com