First of all I would like to congratulate you of such great site your team has made. I have been studying VB.NET for two months now and I have run into a problem. Because I couldn?t make my (Northwind.mdb) file work under SQL server, I jumped exclusively to Access 2002 and I am using OleDB commands to write my project. In the book there are all on SQL server. Everything was just fine after I reached to the project that uses the SQL to create a procedure command to insert a new row to the database, but unfortunately I couldn?t use the same SQL procedure command in Access.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
Am I doing something wrong, or there is a way to create SQL procedure in Access? How I can use my northwind.mdb in SQL server, which is installed from disk 4 of Visual Studio .NET?
You should install the .NET Framework Quickstarts and Samples, which comes with MSDE, a stripped-down SQL Server version, and it automatically loads the northwind and pubs sample databases. This allow you to use all the SQL Server features, will be far more performant, and is what almost every book I know about uses.
Dig Deeper on .NET Architecture Best Practices
Related Q&A from Daniel Cazzulino
Here Daniel Cazzulino explains how to load a DSL (domain specific language) domain model instance file programmatically. This requires the .NET type ...continue reading
Here we offer a glimpse at 12 of .NET development expert Danny Cazzulino's top ASP.NET questions and answers.continue reading
C# developers should NOT be modifying InitializeComponent method in the code-behind (or any of the variable definitions) by hand.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.