Wrox Programmer Forums
|
ASP.NET 1.0 and 1.1 Basics ASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 2nd, 2007, 03:43 AM
Authorized User
 
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database Error

I uploaded my access database and placed in the db folder.
i also used a web config file for the connectionstring.

I can view data from the database ,but the problem lies with my registration.

Current users display ,but i cant register a new user.

Now,it can be my code ,but i tested the page on the localhost webmatrix server and the registration worked.

I think it could be some Privileges.

If anyone knows what can be wrong or how to fix the problem,dont hesitate to email or post.

webnathan@webmail.co.za



 
Old November 2nd, 2007, 07:44 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

hi there.. where and how are you registering new users???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old November 2nd, 2007, 10:17 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 550
Thanks: 0
Thanked 1 Time in 1 Post
Default

As Gonzalo said, let us know the exact process you are following, and the error/problem you are facing!!

Regards
Mike
 
Old November 5th, 2007, 05:09 AM
Authorized User
 
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well guys im getting the following error message:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".




<configuration>
    <system.web>
        <customErrors mode="Off"/>
    </system.web>
</configuration>


Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.




<configuration>
    <system.web>
        <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
    </system.web>
</configuration>

'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''

I added the customErrors in my web config afterwards ,but nothing changed.

I still get the same error,everytime i run the application.

I'm using an Access database and Asp.net 1.1.

The database connections are all done with functions,using the controls.

The login page works on the same principal,but the database connection works on that page.(It only selects data)

I can also select data from the registration page ,but as soon i need to insert the data,i get an error.

Here is my web config code:

<?xml version="1.0" encoding="UTF-8" ?>
<configuration>
<appSettings>
<add key="ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4;
Data Source=C:\domains\cctcsa.co.za\db\cctc_database.md b"/>
</appSettings>
</configuration>

'''''''''''''''''''''''''''''''''''''''''''''''''' '''''
I have changed my datasource to the server path.

I hope i explained well enough and that someone can help.

Nathan

 
Old November 5th, 2007, 08:26 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

hi there.. if you add customerrors = "Off" then you should have a explained error.. are you sure you did this this way???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old November 5th, 2007, 09:47 AM
Authorized User
 
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Here is my latest web config code:

<?xml version="1.0" encoding="UTF-8" ?>
<configuration>
<appSettings>
<add key="ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4;
Data Source=C:\domains\cctcsa.co.za\db\cctc_database.md b"/>
</appSettings>
<system.web>
               <customErrors mode="off">
               <error statusCode="403" redirect="default.aspx"/>
               <error statusCode="404" redirect="default.aspx"/>
            </customErrors>
</system.web>
</configuration>

''''''''''''''''''''''''''''''''''''''''''''
Im still getting the same error ,which states to change my custom errors mode to off.



 
Old November 5th, 2007, 10:21 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

I hope you are uploading this file to the server to...

anyway.. are you testing this on your site or in a provider??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old November 6th, 2007, 04:43 AM
Authorized User
 
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi i uploaded all the files onto the server which is with the Paradigm solutions hosting company.

I have uploaded my database to their db folder and my files to the
wwwroot folder.

I only have a problem when i need to insert data,not to display data.

I gave you my web config code.

Can i please email you my registration page with the web config page.

Nathan

 
Old November 6th, 2007, 08:37 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

another question.. how are you registering you users?? (you never told us how you do that)...

also try removing the error redirect directives (leave only the customerror)....

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old November 6th, 2007, 10:02 AM
Authorized User
 
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi guys

I need to know how to change the users permissions or rights for
my database.

I'm using an access database with asp.net 1.1.

The files are hosted by ParadigmSolutions.

Please help.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Database error LJN BOOK: Beginning VB.NET Databases 1 July 24th, 2006 05:18 PM
Database Error!!! aprnip Classic ASP Databases 2 November 8th, 2004 11:35 AM
error trying to open a database Boomer ASP.NET 1.0 and 1.1 Basics 2 June 22nd, 2003 01:46 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.