Visual Basic .NET Forums  
Click here to advertise with us

Go Back   Visual Basic .NET Forums > Database > Database General Discussion

Database General Discussion General discussion on database related topics

VB.NET Forums Newsletter Signup:
Email address:


Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-06-2009, 12:40 PM
VB.NET Forum Newbie
.NET Framework: .NET 2.0 (VS 2005)
 
Join Date: Mar 2009
Posts: 19
Reputation: 14
ganesh71 is on a distinguished programming path ahead
Default problem with data

hi...
I am using a "database.mdf" in my vb.net application. However the data displays correctly but it does not insert or update data.Pls help me. I am using bindingsource & tableadapter inbuilt functions of the toolbox.

I'm also using msaccess database in another application. I want that user doesn't able to see the database so i used the database password. Now when i try to connect the datasource using "add new datasource" it connects perfectly. But when running application it says "not a valid Password" while the correct password is provided in the "add new connection wizard". However when not using password it works fine. Is there any way to hide or encrypte the database password in xml config file of the application.
thanks
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 07-06-2009, 6:53 PM
cjard's Avatar
VB.NET Forum All-Mighty
.NET Framework: .NET 2.0 (VS 2005)
 
Join Date: Apr 2006
Age: 65
Posts: 6,442
Reputation: 807
cjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond repute
Default

when you put a passowrd on an access database you do NOT set it in the "password" part of the connection string, you set it in the "Jet OLEDB:Database Password" Extended Properties part (not a great screenshot):




for the other thing, read the dnu link in my signature
__________________
DW1 DW2 DW3 DW4 DNU PQ
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 07-09-2009, 12:15 PM
VB.NET Forum Newbie
.NET Framework: .NET 2.0 (VS 2005)
 
Join Date: Mar 2009
Posts: 19
Reputation: 14
ganesh71 is on a distinguished programming path ahead
Default

hi cjard...
I read ur FAQ about database. It's a nice article. Now I do the same things as u suggested ie. I set the database to "copy if newer" (my database is "database.mdf"). But i am facing the same problem ie. in my application the messagebox of successful updation is shown but when i re-debug the application the data is not updated. What the problem may be?
Waiting for ur kindly reply...
thanks.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





All times are GMT -4. The time now is 11:41 PM.

Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2


For advertising opportunities click here.