(Really nobody knows...)How can i set the database password via AccessDataSource? [modified]
-
Hi everybody I’ve developed a web application project by VS.2005 and .Net FrameWork 2.0. And its database is MS Access 2003. I use just AccessDataSource component for database tasks. And now I have a problem. The database has password. But there is no such property with AccessDataSource component or at least I didn’t find any way. I didn’t use any oledbconnection component or such to set the database password. Just I used AccessDataSource component. What should I do? Thanks a lot. Thanks Rastgar -- modified at 7:14 Sunday 30th July, 2006
-
Hi everybody I’ve developed a web application project by VS.2005 and .Net FrameWork 2.0. And its database is MS Access 2003. I use just AccessDataSource component for database tasks. And now I have a problem. The database has password. But there is no such property with AccessDataSource component or at least I didn’t find any way. I didn’t use any oledbconnection component or such to set the database password. Just I used AccessDataSource component. What should I do? Thanks a lot. Thanks Rastgar -- modified at 7:14 Sunday 30th July, 2006
Hi there, If you do a simple research on MSDN, you can easily find the answer saying that the AccessDataSource does not support working with an Access database which is protected by a password. In this case, you should use the SqlDataSource control instead which is also able to work with Access, and allows you to set the connection string. In addition, there are a couple of off-topic thoughts that come to mind when I was reading your two posts above: + Sometimes, people don't answer your question, it's just because it's simple enough, and it can be answered within a second on MSDN or Google, they assume you are able to do this simple research. + From the time you posted your question, I guess that it's Saturday, and you may probably know that people mainly spend this time for thier families after a hard working week, they rarely hang out on the forum, so you can wait until Monday when they come back. If it's really urgent for you, you can seek for help from the Microsoft support service with a reasonable fee. + I also think that you don't want to be rude in the eyes of other CP members ;), do you? So you should not abuse the forum as you still have many more alternatives for example other forums on the internet, MSDN ..... Just a couple of humble opinions.