C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




ADO.net connection


Posted Date: 23 Jul 2007      Total Responses: 3

Posted By: Deva       Member Level: Silver     Points: 2


hi all,
Am trying to establish a connection from a windows form to Access. When i add the adapter and give the connection string, it says "user authorisation failed" and hence in the further steps am unable to retrieve the schema. Can you please help me on this issue???




Responses

Author: Padma    23 Jul 2007Member Level: DiamondRating:     Points: 2
hi check your userid and pwd for the database you tried to connect


Author: Deva    23 Jul 2007Member Level: SilverRating:     Points: 2
actually i have logged in as admin and requires no password... even then i get the error.


Author: Awais Mushtaq    23 Jul 2007Member Level: BronzeRating:     Points: 2
Lady, even signing in as administrator won't help you if you had accidentally added user & admin groups to access database. Sometimes, some viruses interrupt the operation. First make sure that your system is clean of all worms and viruses. And then check whether you had added some user of admin groups. If you had added database password etc. etc. After that try to reconnet. And besides try to connect programatically and make sure, you don't have more than one instances of any Win32 application attempting to connect to database. Access is a single user type DBMS which means supports only one connection at a time. This could also be the cause of error. In case it happens, .NET will fail to get descriptor for the database file and will illicit error messages even experts some time fail to comprehend. Take Care.
Bye.


Post Reply
You must Sign In to post a response.
Next : Date format(very urgent)
Previous : MCTS Dumps for Exam 70-536, 70-528
Return to Discussion Forum
Post New Message
Category: .NET

Related Messages



dotNet Slackers   BizTalk Adaptors    Web Design

masks masks masks

Contact Us    Privacy Policy    Terms Of Use