hi experts,
I am trying to connect my application to read from ms access database 2007. I am using C# and Visual Studio 2008. How to setup the sql Adapters to read and write to the database tables, my adapters are setup now to read from MS SQL Server 2005 Express edition and i am trying to modify the connection to ms access database.
1- I need the connection string (ODBC or just Access database file?)
2- is it wise to use sql adapters to read/insert/update or should I use embedded SQL statements
3- I will have a parameters to pass at some points and more than one Update statement per table (Overwrite my Update Statement)
Thank you
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I had a lot of problems with SQL Server 2005 Express edition (look at this post)
http://www.experts-exchang
although i thought i solved it, the problem shows. (some issues with the express edition and single process!)
anyway,
1- can you tell me whats the difference between Access Database File or using ODBC? which one is recommended?
2- If i want this path (C:\somedir\somedbfile.acc
thanks again
Business Accounts
Answer for Membership
by: pragmatistMSPosted on 2008-04-15 at 08:17:04ID: 21359463
1. Provider=Microsoft.ACE.OLE
2. Matter of choice really. The biggest reason not to use embedded SQL is SQL injection attacks -- I assume this is a DB where security is not a concern (if it is, I recommend SQL Server and not using Access).
3. See above