Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
ASPProtect Full 7.x Support (Info Locked Info Locked)
 CJWSoft Support Info : ASPProtect Full 7.x Support
Subject Info: SQL Server error ’80040e37’ A d d  -  P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
DavidT
New User
New User


Joined: October/25/2006
Location: United Kingdom
Online Status: Offline
Info: 6
Added: October/25/2006 at 10:53am | IP Logged Quote DavidT

Hi there

I've used ASPProtect Lite with Access before and it's great.

I've just purchased the full version to use with an MS SQL database with Hostway in London. They've been very helpful, and have changed the permissions at the server end. But we're stumped at an early stage.

I've changed dataconn_inc.asp to show the right connection string info (I think) and changed the database type to 'SQL'.

I've also put the newly generated keys in config_inc.asp

When I try to access get_me_in.asp I get the following:

Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name 'ASPP_Config'.

/courses/aspprotect/scripts/populate_config_variables_inc.as p, line 13

Any clever ideas for a frustrated newbie?

David

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

Joined: April/06/2004
Online Status: Offline
Info: 1769
Added: October/25/2006 at 1:43pm | IP Logged Quote cwilliams

'ASPP_Config' would be a table in the sql database.

That error means it is not there. Did you look in the sql SQL to verify the table and fields in it are there and correct.

Also, when creating the SQL database you must do so using the SQL creation scripts I provide. DO not upsize an access database as that will cause a lot of problems.
http://support.cjwsoft.com/code/moreinfo160-1.htm

http://support.cjwsoft.com/forum/forum_posts.asp?TID=165& ; ;PN=1



__________________

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


Joined: October/25/2006
Location: United Kingdom
Online Status: Offline
Info: 6
Added: October/25/2006 at 5:33pm | IP Logged Quote DavidT

Thanks for those tips. I've got back to the hosting company with all of them.

My suspicion is they didn't use your SQL scripts in spite of my sending them the zip file.

Fingers crossed

Back to Top View DavidT's Profile Search for other info by DavidT
 
DavidT
New User
New User


Joined: October/25/2006
Location: United Kingdom
Online Status: Offline
Info: 6
Added: November/13/2006 at 10:52am | IP Logged Quote DavidT

...a final note to say that this worked, and we're now up and running.

Many thanks!

David

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

Joined: April/06/2004
Online Status: Offline
Info: 1769
Added: November/13/2006 at 12:26pm | IP Logged Quote cwilliams

OK, if yur up and running then why the post after this  in the other thread about problems with the sql script.

Please advise... are you up and running or not..

__________________

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


Joined: October/25/2006
Location: United Kingdom
Online Status: Offline
Info: 6
Added: November/17/2006 at 6:07am | IP Logged Quote DavidT

Hi

These are two completely different installs on two completely different servers, with different hosts.

I posted in this thread as a thanks for your earlier help.

The problem outlined in the other thread still stands.

David

Back to Top View DavidT's Profile Search for other info by DavidT
 

Sorry, you can NOT post info.
This info has been locked by a info administrator.

  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


vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.powerasp.com,www.aspclassifieds.com,www.aspphotogallery.com,www.codewanker.com