Ado.net and Foxpro Database question.

[hllee75]

Dear All,
This is the situation, my application is using VB.net 2003 as
front-end and Foxpro 9.0 as database. I don't want other people to
access the foxpro database and see the table structure, so i added a
proceduce in Foxpro open table event. The proceduce will prompt for
password,only allow to modify table structure if the password is
right.
After doing so, my program will not be access the table in Foxpro
because of the proceduce, everytime i call dataadapter.fill, or
OleCommand.excutenonquery or oleDBCommand.excutescalar i'll get error
message.

Guys, any solutions? Does Foxpro 9.0 has a database password
feature like Microsoft Access? Is Foxpro a good way to go with
Ado.Net?


Best Regards,
Han Lim

 

[Cindy Winegarden]

Hi Han Lim,

If you want true database security you're best off using Microsoft SQL
Server. MSDE or the new SQL Server Express are free to distribute with your
applications.

You haven't said exactly what your error message is, but if your code is
running in the OpenTable event then it will run every time a table is
opened. I don't have enough time right now to set up test data and write VB
code against it, but if, as you said, you only want to prevent someone from
seeing or modifying the table structure then it looks like the place to put
the code is in the BeforeModifyTable event.

 

[hllee75]

Hi Cindy,
Thanks for your reply, I followed your suggestion by calling the
"Password" proceduce in BeforeModifyTable event, then everything works
fine. Now my VB.net program can do select, update and insert.
Thanks a lot.

Best Regards,

Han Lim