We are building MVC application and using LDAP for user authentication (form based). We are able to authenticate user using LDAP. But after user authentication though login page it goes to a data page and try to access SQL server database and get following error message: Cannot open database "HRDataBase" requested by the login. The login failed. Login failed for user 'Anonymous'
Database is having permissions with which user logged in but MVC application is not using the loggedin user identity to connect to the database. I have allowed Login page for anonymous access. but all the other pages are not allowed to have anonymous access. But application is not picking up the login user id. we are using .NET4 on IIS6.0 and windows 2003 with SQL server 2008. In web.config file i am having <identity impersonate="true"> defined.
am in deep trouble with retriving the data from oracle database. Please HELP ! In one line: "When i retrive the data from oracle database, it's truncate the data if it is more than 4 kb"I have oracle proc param as below:
PROCEDURE p_GetData ( ivar_id IN id_n%TYPE, oclb_owners OUT CLOB, onum_sqlcode OUT NUMBER, [code]...
I am facing problem..how to read Excel file from the 5th row onwards and how to store the all records into Database Note: More over i do want store few coloumns records(3 out 8) only in my database. consider this point.
Server Error in '/' Application. Attempted to read or write protected memory. This is often an indication that other memory is corrupt.Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Is there anything missing in IIS 6.0 that prevents me from (Insert into table) using MS-Access?
Explain: The application works fine under Visual Studio 2008 IDE the insert into table works fine with no error, Also I tested with hosting provider and works fine with no problem. but now I have published the same exact app in a dedicated server windows 2003 with IIS 6.0 .NET framework 2.0 with latest service pack I gave IIS_WPG write/modify access to the folder where MS-Access database is located and database but at the time of insert an error pop-up. I need to install in the Server or settings in the IIS to recognize my MS-Access db is it some office runtime that I am missing. (BTW I am using OLEDB connection string in my C# )
I can retrieve data off of it with no problem but when I try to insert is when it fails I thought the problem was Access Rights but I do not think is the case.
I created a new database with the help of Database Configuration Assistant !I created with the scott account.Now i'm not able to connect to the database with the connect identifier with the scott account.The error i get is.,
ERROR - ORA-12154: TNS:could not resolve the connect identifier specified.
ok i have my GUI installed on the server which has users as administrator as the role of an administrators and user1 which has the role of the guest...I have one project and there are different pages for administrators and guests... when the login screen comes up and the administrator logs in he should be redirected to the admin.aspx page and for user1 he should be redirected to the guest.aspx page.
Now the scenario is i have 10 users in a company and one administrator. This GUI is on the network server and these 10 users are able to access it as guests.
How do the guest user logs in and can access the SQl database in the read only mode but when the administrator user logs in he can access the database in the read and write mode.?? I dont know how to do this really... any suggestions
(by IIS server or webconfig or some setting in SQL server)
and the previous question is what to use (forms or windows authentication) where can i get information on how to set up this kind of authentication???? Is there the need to use impersonation also??
We are currently migrating our test databases to a new server and I am switching one of our sites over to use them. When running the application from my development box it hits the database just fine. However when I compile and push the code out to our test server and try to use the same datbase I get the ExecuteNonQuery requires an open and available Connection. The connection's current state is closed error. I cannot seem to figure out why. Also when I point the site at our old test server it works just fine.
In school we have been making a website where we need to use .adp vbscript pages. But also Microsoft Access databases.
We've added the connection string etc and bindings - all that works fine but when we go to open the page we get page cannot be found. It loads sometimes but most of the time we get that page not found screen.
We are using IIS.
The teachers and another students one works fine, We have done exactly what they have but we get no luck with bringing up the pages.
Iam using the DBconnection object through out my applicationI use the same as a singleton objectWhen more operations are performed on the single objectit throws an error ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] Cannot open any more tables.But it occurs only some timesHow to solve this?Can any property can be set to avoid this type of error.Or can i overload and write any method to avoid thisTo Identify the same i wrote some Poc and tried alsoLike opening the connection object and looping through 1000 times and creating a command object for the connection and running a query.Some times iam getting the exception and some times its running
I created a database with all text fields. I am using asp to enter the data into access INSERT INTO Form (fname, lname, sID, fl, email, job, employer, Position, grade, degreename, degreetime, degreePlace ) VALUES ('chris','v','12323','cv','firstname.lastname@example.org','Yes','Uc','Developer','Yes','test','2010','Uc') Above is the sql I am trying to insert [ Response.write(sSql)] But it is failing and I am not able to insert the data in the table. I am getting Microsoft JET Database Engine error '80040e14' Syntax error in INSERT INTO statement Error.